Spotify data interview guide
Listening behaviour — streams, playlists and retention.
typical interview loop
- 1.Recruiter screen
- 2.Technical screen: 2–3 SQL questions in a shared editor (~45 min)
- 3.Onsite: SQL / Python coding, product-sense metrics case, behavioral
- › Sessionisation and top-N tracks per user come up.
most-tested topics
JOIN
2
ratios
1
Window functions
1
ranking
1
datetime
1
pivot_table
1
Based on 5 reconstructed Spotify-style questions.
practice path
0 free · 5 Pro- 1Completion rate per tracksqlMedium
- 2Each user's most played artistsqlHard
- 3Monthly listening hours per artistpandasMedium
- 4Plays per genresqlEasy
- 5Skip rate per userpandasHard
Unlock all 5 Spotify questions with Pro.
upgrade