dbt Training & Analytics Engineering Enablement

An advertising agency needed to move from ad hoc SQL queries to a maintainable, documented, and automated analytics workflow. I designed and delivered a hands-on dbt training program (using BigQuery as the warehouse) to help the team structure and industrialize their analytics project end-to-end.

Onboarding and setup: environment setup, dbt project initialization, environment management, and core best practices

Packages and standards: essential dbt packages, naming conventions, repo structure, and contribution guidelines

Layered modeling: staging, intermediate, and marts architecture for clean, reusable models

Quality and documentation: tests (uniqueness, not-null, relationships), sources, documentation, and catalog generation

Orchestration: scheduled daily runs via Kestra (dbt run plus basic monitoring)

Outcome A self-sufficient team with a clear dbt foundation (conventions, models, documentation), transformations industrialized in BigQuery, and a daily orchestrated run that keeps datasets consistently up to date.