Savings United – BI Data Engineering for a Coupon Platform
Four years as a senior data engineer on the BI team of Savings United, a Hamburg-based coupon partner for media brands in 12 countries.
- Client
- Savings United (Hamburg, Germany)
- Industry
- E-commerce / affiliate marketing
- Period
- Apr 2020 – Jul 2024
- Engagement
- Embedded senior data engineer
Key Results
Four years of affiliate-revenue QA, pipeline documentation and warehouse work for a BI team serving 12 markets
The Challenge
Savings United runs coupon portals for media brands in 12 countries and earns commission through affiliate networks such as CJ, Awin, eBay, Impact and Tradedoubler. Payout data from every network has to be reconciled with the data warehouse before reporting can be trusted.
Our Solution
Joining the BI team in April 2020, we automated QA that compares affiliate-network data with the warehouse, starting with CJ and Awin and later covering CJ, eBay and Impact payouts. We documented the Tradedoubler payout pipeline from raw data through staging and the warehouse to Looker, upgraded the Python ETL jobs, and shared the warehouse's weekend on-call rotation. In 2024 we validated the migration of the cost fact table from SQL Server to Google BigQuery.
The Outcome
The engagement ran from April 2020 to July 2024, covering both the SQL Server era and the start of the move to BigQuery.
Highlights
- Automated affiliate-payout QA against the warehouse
- End-to-end documentation of payout pipelines
- Python ETL upgrades and weekend on-call
- SQL Server to BigQuery migration validation
Related Projects
EdgeHunters – Real-Time Odds Data Platform
Scrapers, normalization and quality checks that feed live odds from dozens of sportsbooks into a betting-analytics product for US and Canadian users.
Tribute Technology – Funeral Home Data Migration Platform
A self-service platform that converts funeral homes' legacy data into Tribute's format, so new customers can move to CRäKN (now Tribute Management Software) without one-off manual imports.
AI Exercise Program Generator for a Sports Physiotherapy Clinic
A web app that drafts individualized strength and rehab programs from an athlete's test data, so physiotherapists start from a sound plan instead of a blank page.
Interested in Data & AI Services?
Learn more about our data & ai capabilities and see how we can help with your project.
Explore Data & AI ServicesHave a Project in Mind?
Let's discuss how we can bring your vision to life with a custom solution.
Start Your Project