Data and AI

dbt and the Modern Data Stack

Build genuinely tested, documented, version-controlled SQL transformations with dbt, the modern ELT standard

16h4 lessonsTier 2 hireabilityTier 2 certificate

What you'll be able to do

You can build dbt models organised into a genuine layered architecture, write dbt tests to catch data quality problems automatically, use Jinja templating and macros to avoid repeated SQL, and generate dbt documentation for a real project.

Job titles this qualifies you for

Analytics EngineerData EngineerETL Developer
Market intelligence
Demand
High
Remote
72% remote roles
Nigeria salary
Not a primary local hiring category
Remote (USD)
$114,500–$137,500/year for the typical remote mid-level range (25th-75th percentile); average around $130,000-$148,000/year; senior remote data engineers average $191,822/year

Lessons

Stage 1 — Foundation
1
dbt Models and a Layered Architecture
40 min
2
dbt Tests and Data Quality
35 min
Stage 2 — Applied
1
Jinja Templating and Macros
35 min
2
Documentation and Project Organisation
30 min
Tier 2 Proof Submission

dbt and the Modern Data Stack Portfolio

Demonstrate genuine dbt model architecture, testing, Jinja/macro, and documentation competence.

1.A layered model design (staging/intermediate/marts) with materialization choices and reasoning
2.Generic test YAML and a singular test SQL query
3.A reusable cents-to-dollars macro with a use-case explanation
4.Model/column YAML descriptions and a project folder structure
Create a free account to join this programJoin free →