Packaged snacks · LATAM and Middle East & South Africa retail
Revenue analytics across 12 retail chains, refreshed hourly
global snack food company
Replaced a nightly Excel-and-SSIS revenue pack with a Databricks lakehouse serving trade-spend-adjusted net revenue to 400+ commercial users across LATAM and Middle East & South Africa.
The problem
Sell-out data arrived from twelve retailers in twelve formats across LATAM and Middle East & South Africa. Finance and sales argued over net revenue every month, and the close took nine days.
Our approach
- 1Landed retailer EPOS, distributor and SAP order feeds into ADLS Gen2 with Auto Loader and schema evolution.
- 2Built a medallion model in Delta Lake with a conformed product-and-customer hierarchy and Unity Catalog governance.
- 3Modelled gross-to-net: list price, trade promotions, rebates, returns and logistics deductions as auditable fact tables.
- 4Shipped a Power BI revenue cockpit with lineage back to source rows for finance sign-off.
Measurable outcomes
- 9 → 2 days
- Commercial close cycle
- 98.6%
- Gross-to-net reconciliation accuracy
- $4.1M
- Recovered promo leakage in year one
Architecture and workflow
- 01
Sources
12 retailer EPOS · distributor · SAP
- 02
Ingest
Auto Loader · ADF · schema evolution
- 03
Lakehouse
Delta bronze / silver / gold
- 04
Model
dbt gross-to-net facts
- 05
Consume
Power BI revenue cockpit
More work
Consumer app · San Francisco
Audience business review analytics
Data lake on S3 exposed to Athena via Glue Catalog, a single-source-of-truth table refreshed by Step Functions and Lambda, and a QuickSight CXO dashboard for MAU, DAU, trial-to-subscription and revenue trends.
Global BPO / ITeS · France
Operational insights for 400 contact centres
Performance tool exports auto-synced to Azure file storage, staged and loaded by Azure Data Factory into a Synapse warehouse, with Power BI dashboards for occupancy, AUX, handled volumes and shrinkage.
Healthcare ISV
Integrated healthcare and telemedicine platform
HIPAA-compliant AWS platform with IoT device integration, nutrition tracking and a conversational intelligence pipeline using Transcribe Medical and Comprehend Medical over Chime call recordings.
Want a build like this?
We start with a two-week diagnostic and leave you with an architecture and migration plan you own.
Talk to an architect