The Analyst Who Saw the Salary Data
A hard Pipeline Design mock interview question on DataDriven, with an AI interviewer who asks follow-up questions and a hire or no-hire decision at the end.
- Domain
- Pipeline Design
- Difficulty
- hard
- Seniority
- L5
Interview Prompt
Five business units of very different sensitivity share one flat lake store behind a single reader role, and the platform lead just learned an analyst read another unit's files directly. Redesign the lake so each unit gets its own isolated store, while about 300 analysts and the few pre-approved cross-unit reads keep working.
Summary
Two incidents. One shared lake. The access model was never designed, just assumed.
How This Interview Works
- Read the vague prompt (just like a real interview)
- Ask clarifying questions to the AI interviewer
- Draw your pipeline on the design canvas: sources, transforms, storage and checks
- Answer the interviewer's follow-up questions, then get a hire or no-hire decision