Data Warehousing Architecture with Snowflake & dbt

Course Overview

Master cloud data warehousing patterns using Snowflake and data transformation pipelines using dbt (data build tool). Learn how to structure raw data into clean dimensional data marts, manage version-controlled SQL transformations, and automate data testing routines.

What You Will Learn

• Architect cloud data warehouse storage schemas optimized for analytical query performance.
• Transform raw database tables into clean star-schema dimensional models using dbt and SQL.
• Implement automated data quality tests, documentation rules, and freshness checks in dbt.
• Manage Snowflake virtual warehouses, user access roles, and query compute resource costs.

Syllabus Breakdown

• Module 1: Snowflake Cloud Warehousing: Architecture, compute warehouses, storage separation, and access roles.
• Module 2: Dimensional Data Modeling: Fact and dimension table design, star schemas, and slowly changing dimensions.
• Module 3: Data Transformation with dbt: Project organization, models, materializations (views/tables), and ref macros.
• Module 4: Data Quality & CI Automation: Automated dbt testing, documentation site generation, and pipeline runs.

Who This Is For

Data analysts, analytics engineers, and database developers modernizing enterprise reporting pipelines.