Staff Data Engineer Elite Architecture
MetaWho Is Churning and Why
We run a SaaS subscription platform with monthly and annual plans across multiple product tiers. The finance and growth teams need a unified analytics layer that can answer: which cohorts churn fastest, what is monthly recurring revenue by tier, and which accounts are at risk of non-renewal. Right now subscription data lives in the application database and no one can query it for analytics without hitting production. Design the pipeline and data model.
Ask the interviewer clarifying questions to understand the requirements and constraints before designing.
When you're ready, click Ready to Design to start building.
Who Is Churning and Why
A medium 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
- medium
- Seniority
- staff
Interview Prompt
We run a SaaS subscription platform with monthly and annual plans across multiple product tiers. The finance and growth teams need a unified analytics layer that can answer: which cohorts churn fastest, what is monthly recurring revenue by tier, and which accounts are at risk of non-renewal. Right now subscription data lives in the application database and no one can query it for analytics without hitting production. Design the pipeline and data model.
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