Data Warehouse & Dimensional Modeling

A poorly designed warehouse accumulates technical debt faster than any other part of the stack. I design data models with the right grain, the right structure, and the right tradeoffs documented — so your team can build on top of them for years.

What’s Included

Dimensional modeling and star schema design
Warehouse setup and configuration (BigQuery, Redshift)
Staging layer design and source alignment
Mart layer modeling for business domains
Metrics layer design for consistent KPI definitions

Platforms

BigQuery · Redshift · Python · Spark · Airflow

I design for the questions the business is actually asking — not the schema that was easiest to load.

Data Warehouse Design

Warehouse architecture and data modeling that scales — star schemas, OBTs, and governance frameworks built for the long term.

Let's Work Together

Open to full-time roles, contract engagements, and consulting work. If you have a data challenge that needs solving, reach out and let's talk.

Reach Me Directly

Email: chrisrotunno@icloud.com

Location & Availability

Based in St. Augustine, FL. Available for remote-first roles nationwide and hybrid arrangements in Northeast Florida. Typically respond within one business day.

Send Us a Message

Frequently Asked Questions

Can't find what you're looking for? Reach out through the contact form below.

What kind of roles are you targeting?

I'm focused on Data Analytics Engineer and BI Leader roles — positions where I can own the full pipeline from raw data to executive-level insight. I'm especially interested in companies investing in a modern data stack (Python, BigQuery/Redshift, Tableau/Plotly).

What industries have you worked in?

I've built analytics solutions across retail, CPG, SaaS, and finance. I'm comfortable ramping quickly into a new vertical — data modeling and stakeholder communication patterns transfer across domains.

What does your technical stack look like?

Core: SQL, Python (pandas, SQLAlchemy), Spark. Warehouses: BigQuery, Redshift. BI: Tableau, Plotly, Google Data Studio, Excel. Orchestration: Airflow. Cloud: AWS, Azure, GCP. Git-based version control for all data work.

Are you open to remote, hybrid, or on-site?

I'm based in St. Augustine, FL and am open to remote-first roles. For the right opportunity I'm also open to hybrid arrangements within Northeast Florida.

Can you lead or mentor a data team?

Yes — I've led small analytics and BI teams, defined data governance standards, and mentored analysts growing into engineering roles. Building a healthy data culture is as important to me as building clean pipelines.

How do I get in touch?

Use the contact form on this site or email me directly at chrisrotunno@icloud.com. I typically respond within one business day.

Got a question?
I'll give you a straight answer.

No fluff. If I can't answer it, I'll say so.