System Note 05 · Open Source & Builder Work

NYC Taxi ELT

dbtAirflowDockerPostgresSQL
What it is

A pipeline that loads a year of NYC taxi-trip data, then transforms it in clean layers (raw → cleaned → analytics) with dbt, orchestrated by Airflow and packaged in Docker.

full-year 2024 dataset · dbt medallion · Airflow · Docker

Why I built it

I wanted a public, end-to-end reference build of the modern data stack — the same patterns I use at work, but fully open.

Evidence before confidence.

← Back to Build Notes