What the Script Remembers
A medium Data Modeling mock interview question on DataDriven. Practice with AI-powered feedback, real code execution, and a hire/no-hire decision.
- Domain
- Data Modeling
- Difficulty
- medium
- Seniority
- mid
Interview Prompt
Sanofi's commercial analytics team wants a warehouse for prescription fills across the US, where brand managers slice volume and revenue by therapeutic class and manufacturer while field teams roll the same numbers up through prescriber territory and region. Drug attributes like formulary status and packaging change over time, and an analyst pulling last quarter's numbers must see each fill against the attributes that were in effect on the day it was dispensed. Design the model that serves both the therapeutic-class rollups and that point-in-time accuracy.
How This Interview Works
- Read the vague prompt (just like a real interview)
- Ask clarifying questions to the AI interviewer
- Write your data modeling solution with real code execution
- Get instant feedback and a hire/no-hire decision