Data Analyst interview
at Spotify.

Tell-me-about-a-time stories on ownership, conflict, and impact — scored against this company's real values.

1. 01 Tell me about a time your analysis directly changed a product decision within your squad.
2. 02 Describe a situation where you had to deliver an insight quickly with incomplete data and a bias for action.
3. 03 Walk me through how you handled a stakeholder who disagreed with your interpretation of the numbers.
4. 04 Give an example of when you proactively surfaced a metric trend that no one had asked you to investigate.

The hard screen for the craft itself — talked through out loud, not whiteboarded in your head.

1. 01 Write a SQL query using window functions to find each user's first and most recent streamed track.
2. 02 How would you calculate monthly churn rate and retention curves for Premium subscribers from a subscriptions table?
3. 03 Given streaming logs, write SQL to identify the top 5 tracks per country by play count in the last 30 days.
4. 04 How would you investigate an unexpected drop in average session length using the data available to you?

Open-ended design of the systems this company actually runs, with the interviewer probing your tradeoffs.

1. 01 Design an executive dashboard that tracks DAU, stream counts, ARPU, and churn for the leadership team.
2. 02 Design the data model and tables you would use to analyze user engagement across music and podcast listening.
3. 03 Design a reporting pipeline that measures the lift of a marketing campaign on free-to-Premium conversions.
4. 04 Design an analytics framework to evaluate whether a new home-screen layout improved content discovery.