01
dbt project
Make this concrete enough that another engineer can understand what you built and why.
CAREER PROJECT · Intermediate · 2 weekends
Analytics Warehouse with dbt
Model raw product and revenue data into tested analytics tables with documentation and lineage.
SQLdbtData modelingTestingDocumentation
DEFINITION OF DONE
Leave artifacts a reviewer can inspect.
02
Model docs
Make this concrete enough that another engineer can understand what you built and why.
03
Tests
Make this concrete enough that another engineer can understand what you built and why.
04
Lineage diagram
Make this concrete enough that another engineer can understand what you built and why.
05
Example dashboard
Make this concrete enough that another engineer can understand what you built and why.
RESUME / PORTFOLIO FRAMING
Describe what you actually did.
Built a tested analytics warehouse with documented dimensional models, lineage and reusable business metrics.
Use this as a starting structure, then replace it with your real implementation details, metrics and constraints. Do not claim outcomes you did not measure.
STRETCH GOALS
Go deeper if the core is already solid.
Snapshots
Add only if it strengthens the engineering story instead of delaying a finished, deployable core.
Incremental models
Add only if it strengthens the engineering story instead of delaying a finished, deployable core.
CI checks
Add only if it strengthens the engineering story instead of delaying a finished, deployable core.