All projects
Data products
NBA Data Pipeline
ELT pipeline for NBA data with Snowflake and dbt, modeled in bronze, silver, and gold layers.
- Year
- 2024
- Role
- Data Engineer
The problem
I built this project to practice a clean analytics engineering workflow using medallion modeling and business-facing outputs rather than raw-source analysis.
What I built
A Snowflake and dbt pipeline that transforms raw NBA data into structured analytical models for game results, player performance, and team analysis.
- 01Raw Data
- 02Bronze
- 03Silver
- 04Gold
- 05Power BI
How it's built
- Raw NBA data lands in Snowflake and is organized into layered models.
- dbt handles transformations, testing, and model structure across bronze, silver, and gold layers.
- Gold-layer outputs are shaped for BI consumption and reporting in Power BI.
Outcomes
- Clear separation between raw ingestion, transformation logic, and business-facing outputs.
Stack
- dbt
- Snowflake
- SQL
- Power BI
- ELT
Next project
DataForge