← All Projects

Transit Operations Data Pipeline

An end-to-end ELT pipeline processing real-time transit data for a regional operator.

A production data pipeline ingesting GTFS-RT feeds, transforming them with dbt, and surfacing KPIs in a Power BI dashboard. Built for a transit authority in Quebec.

30s Real-time refresh cycles
99.9% Pipeline uptime
PostgreSQLPythondbtPower BIApache AirflowDockerGitHub ActionsPlaywrightVitest
Private repo (for now)

Let's build somethingthat moves.

Database, pipeline, dashboard, website: wherever it's stuck, that's where we start.

Get in touch View on GitHub