Designs and builds maintainable data warehouses using dbt and Kimball-style dimensional modeling principles.
This skill provides a comprehensive framework for engineering enterprise-grade data warehouses within dbt environments. It guides users through a structured layered architecture—from raw base views to consumer-ready marts—ensuring a clear separation of concerns. By implementing Kimball-style dimensional modeling, it helps developers create robust fact and dimension tables, manage surrogate keys, and enforce strict naming conventions. The skill also prioritizes data quality by providing standardized patterns for automated testing, comprehensive schema documentation, and optimized materialization strategies, making it ideal for data engineers building scalable and transparent analytics pipelines.
Key Features
01Comprehensive testing and documentation frameworks
02Kimball-style dimensional modeling for facts and dimensions
03Automated surrogate key generation patterns
040 GitHub stars
05Standardized dbt naming conventions and materialization logic
