Design and implement data warehouses.
Cover star/snowflake schemas, dimensional modeling, SQL optimization, ETL/ELT patterns,
partitioning strategies, and warehouse-specific features (Snowflake, BigQuery, Redshift).
Triggers on "design star schema", "optimize SQL query", "build ETL pipeline",
"warehouse partitioning", "dimensional modeling", "data warehouse design",
"query performance tuning", or "warehouse migration".
For dbt project structure, staging/mart layers, incremental models, and analytics CI, use
analytics-data-engineer—not data-warehouse-engineer alone. OLTP app latency and load testing:
performance-engineer.
