Top 27
Prep plan
Updated weekly · Last refresh Oct 17

Spotify Business Analyst Interview Questions

The questions to prepare for a Spotify Business Analyst interview. Questions from real interview reports rank first. Updated daily.

27questions
~4htotal time
Track your progressSign up free to work through all 27 questions and resume where you left off.
Start practicing free →
1
SQL & Data ManipulationStart here. 7 questions + 2 drills · ~79 min
Refactor SQL to Reduce DebtHard

Tests your ability to improve SQL quality, readability, and maintainability.

technical debtSpotify
Optimizing a Slow Join QueryHard

Tests performance troubleshooting and query optimization strategies for large-scale Spotify datasets.

Performance TuningJoinsindexesSpotify
Top Artists Per User QueryMedium
Practice

Rank each user's three most-played Spotify artists during the latest 30-day period.

Window FunctionsDate FunctionsRankingSpotify
SQL Coding With Joins and AggregatesMedium
Practice
Practice drill

Join streaming tables, aggregate monthly streams, and return artists ranked within each genre after listener filtering.

CodingpandasJoinsSpotify
Window Functions for Listening DataMedium
Practice
Practice drill

Calculate chronological listening totals and duration-based ranks for each Spotify user.

Window FunctionsJoinsData ManipulationSpotify
More SQL & Data Manipulation questions with a free account
2
Strategy4 questions · ~34 min
Spotify Ticketing Market EntryHard

Evaluates strategic thinking and ability to structure a market entry analysis for Spotify.

presentationSpotify
Financial Model for Royalty ChangesHard

Tests financial modeling skills and ability to quantify impact of royalty policy changes on Spotify economics.

profitabilityFinancial ModelingSpotify
Analyzing Spotify Strategy for ChurnHard

Tests structured root-cause analysis and data-driven solutioning for Spotify subscription churn.

root causerisk analysisChurnSpotify
More Strategy questions with a free account

Sign up to see every question

Create a free account to unlock this list and practice real interview questions.

Get my prep plan
3
Behavioral & Leadership14 questions · ~118 min
More Behavioral & Leadership questions with a free account
4
More topics2 questions · ~17 min
Success Metrics for Playlist PersonalizationMedium

Tests KPI selection and measurement design for product outcomes at Spotify.

kpi hierarchyActivationEngagement MetricsSpotify
Segmenting Users for Ad TargetingMedium

Tests data segmentation approach and ability to translate user behavior into actionable targeting at Spotify.

User SegmentsUser NeedsSpotify
The finish line: interview-readyComplete all 27 questions plus 2 hands-on drills to finish this plan.