Job Description

This is a remote position.
Job Title: DBT (Data Build Tool) Trainer
Job Type: Freelance
Mode: Remote
Duration:Standard
Experience: 10 years total
Job Role
Design and deliver high-impact dbt training programs for analysts, data engineers, and analytics engineers. Build curricula, hands-on labs, and capstone projects covering dbt Core & Cloud, modeling best practices, testing, documentation, CI/CD, and performance. Mentor cohorts, assess skills, and enable teams to adopt analytics engineering standards at scale.
Key Skills
dbt Expertise: dbt Core & Cloud, models/seeds/snapshots, Jinja, macros, packages, exposures, sources, dbt tests (generic & singular), documentation & lineage, dbt Cloud jobs and deployment.
SQL Mastery: Advanced SQL (CTEs, window fxns, optimization); query tuning & profiling.
Data Modeling: Star/Snowflake schemas, Kimball/Dimensional design, CDC concepts, slowly changing dimensions, staging ? marts layering.
Warehouses: Snowflake / BigQuery / Redshift (any two+); cost/perf tuning basics.
Versioning & CI/CD: Git/GitHub/GitLab, PR workflows, dbt build, Slim CI, environments, code review practices.
Orchestration: Airflow / Prefect / dbt Cloud scheduling & alerts.
Quality & Governance: Testing strategy, data contracts, docs coverage, freshness & sources, SLAs/SLOs, lineage/impact analysis.
Analytics Engineering: Reusable patterns, naming conventions, modularity, metrics layer concepts (semantic modeling familiarity a plus).
Teaching Chops: Curriculum design, adult learning principles, clear communication, live-coding, troubleshooting, coaching and feedback loops.
Nice-to-haves: Python basics, Docker, Looker/Power BI/Mode, Terraform for dbt Cloud, dbt Fundamentals/Certified (or ability to help others certify).

Skills Required