Replaced fragmented on-prem reporting with a governed Snowflake estate and dbt-led modeling so finance and merchandising share one source of truth.
The retailer’s estate had grown through acquisitions — overlapping warehouses, inconsistent KPIs, and no single place to reconcile finance with store operations. We stood up a governed cloud platform with domain ownership so new regions could onboard without rewriting everything from scratch.
How we approached it
Landing zone & domains
Accounts, networking, and IAM structured around merchandising, finance, and supply-chain data products with clear boundaries.
Curated warehouse layers
Raw → staging → marts in Snowflake with dbt tests on business keys, SCD patterns where needed, and documentation in-repo.
Access & audit
Role-based access with row policies for markets; lineage from BI tools to source for controls your risk team can evidence.
What we delivered
- Landing zone, networking, and IAM aligned to retail data domains
- Ingestion from ERP, POS, and e-commerce into curated warehouse layers
- 200+ dbt models with tests, docs, and CI/CD
- Operational dashboards with freshness SLAs and ownership runbooks
Outcomes
-
Sub-hour freshness for core sales and inventory KPIs
-
Self-serve analysts in each country on shared modeling patterns
-
Clean history for pricing, promo, and range experiments
Representative stack: