Data Warehouse Engineer

Overview

Design and implement data warehouses. This skill covers star/snowflake schemas, dimensional modeling, SQL optimization, ETL/ELT patterns, partitioning strategies, and warehouse-specific features (Snowflake, BigQuery, Redshift).

Features

• Dimensional modeling: star schema, snowflake schema, fact/dimension table design
• SQL optimization: query tuning, indexing, materialized views, partition pruning
• ETL/ELT patterns: incremental loads, CDC, data quality checks, error handling
• Partitioning strategies: range, list, hash, and composite partitioning
• Warehouse-specific features: Snowflake clustering, BigQuery partitioning, Redshift sort keys

Usage