The Panel and the Set-Top Boxes
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 measure TV viewership for every major network and streaming service in the US. We collect second-by-second viewing data from a 40,000-household panel and set-top box data from 45 million devices, and our clients - the networks, advertisers, and agencies - depend on our overnight ratings reports. Design a pipeline that processes this data, applies the panel weighting to project national estimates, and reliably delivers reports to clients by 10am every morning.
Summary
Set-top boxes tell you who watched. Projection tells you how many.
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