01

Problem

Retail company need the ability to prepare their data for analytics and combine it with third-party data. They had Snowflake setup and raw data ingested but no data structure to properly extract, catalog, and aggregate data.

02

Solution

Implemented dbt to manage the orchestration and transformation of pipelines. Designed and developed, curated and aggregated data layers to clean, homogenize source data for analytic reporting. Established framework for development, test, and production environments for future scaling of the data solution.