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.
- Analytical, business-strategy driven work: turning scattered, untrusted data into decisions people actually act on
- Enough scope to see how the entire company's operations connect, not a siloed dashboard for one department
- Ideally with a global, remote-first team
- Built analytics systems in financial services and retail
- Ran the floor in food service and home improvement
- SQL, Python, and Spark for the engineering
- Tableau, Excel, and Google Data Studio for the reporting
- AWS, Azure, and GCP for wherever your data lives
- Remote-first, ideally with a global, distributed team
- Open to hybrid, and open to relocating anywhere in the US for the right role
- Looking for compensation and benefits strong enough to make the move worth it for both of us
- Built a team from scratch
- Cut a data vendor's cost by 80%
- Mentored analysts into engineering roles
- Fastest path is the contact form below
- Or email me directly at chrisrotunno@icloud.com
- I 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.