Unifying retail, inventory & e-commerce data into one warehouse
Challenge
Finance, merchandising, and marketing each had their own version of "revenue," and closing the books each month meant days of manual reconciliation across POS, e-commerce, and ad platforms.
Approach
- ▸Stood up a cloud warehouse and ingestion pipelines from POS, Shopify, and ad platform APIs
- ▸Built a dbt transformation layer with tested, documented metric definitions
- ▸Delivered exec, merchandising, and marketing dashboards on a shared semantic layer