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.