Which Promotion Is Actually Working
A hard Pipeline Design mock interview question on DataDriven. Practice with AI-powered feedback, real code execution, and a hire/no-hire decision.
- Domain
- Pipeline Design
- Difficulty
- hard
- Seniority
- L6
Interview Prompt
We're a consumer goods company running dozens of trade promotions at once across hundreds of retail partners, and the commercial team needs promotion ROI fresh enough to cut the ones that are wasting money. Shipment events stream out of our ERP in near-real time, retailer sell-through arrives as daily files, and third-party market data lands once a week, and all of it converges in an analytics warehouse where every sale is credited to the promotion that was running when it happened. The retailer files are messy (duplicate rows and bad product codes), so the bad rows have to be set aside for review rather than dropped, and before the ROI numbers go out they have to reconcile against ERP shipment totals. Design the ingestion and warehouse architecture, keeping each source on a cadence that matches how fresh its consumer needs it.
Summary
Was the promotion worth it? The data knows.
How This Interview Works
- Read the vague prompt (just like a real interview)
- Ask clarifying questions to the AI interviewer
- Write your pipeline design solution with real code execution
- Get instant feedback and a hire/no-hire decision