Bikeshop Data Warehouse DATA ENG
A multi-layer data warehouse integrating two operational systems into a single analytical model. Designed for incremental loads, historical tracking, and clean dimensional reporting.
- Designed Staging, Integrated, and Star Schema layers from two source systems.
- Built incremental ETL models in dbt with dimensional fact tables.
- Implemented SCD Type 2 for product history and consolidated customer data.
- Branch-based Git workflow for safe iteration.