Dataford
Top 26
Prep plan
Updated weekly · Last refresh Aug 30

Spotify Analytics Engineer Interview Questions

The questions to prepare for a Spotify Analytics Engineer interview. Questions from real interview reports rank first. Updated weekly.

26questions
~4htotal time
Track your progressSign up free to work through all 26 questions and resume where you left off.
Start practicing free →
1
SQL & Data ManipulationStart here. 9 questions + 1 drill · ~90 min
Popular Songs by RegionMedium
Practice

Rank Spotify songs in a region by 30-day streams using joins, aggregation, date filtering, and RANK().

sql querySpotify
Calculate 30-Day User RetentionHard
Practice

Use CTEs, joins, and date filtering to calculate 30-day retention by signup cohort from login and feature usage data.

Window FunctionsDate FunctionsAggregationsSpotify
7-Day Rolling Active UsersMedium
Practice
Recently asked
Practice drill

Compute daily active users and a 7-day rolling average using a CTE, distinct counts, and window functions.

Window FunctionsDate FunctionsRunning TotalsMetaSpotifyMeta IT
More SQL & Data Manipulation questions with a free account
2
Pipelines7 questions · ~62 min
Data Quality in ETL PipelinesEasy

Approach for maintaining data quality and integrity across ETL pipelines.

IdempotencyData ModelingQualitySpotify
Partner With Product and Scale DataMedium

Evaluates collaboration with PMs and your approach to scaling data reliability with tests.

Spotify
More Pipelines 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
Metrics5 questions · ~45 min
Investigate User Engagement DeclineMedium

Investigate a 15% engagement decline by decomposing the metric, isolating root causes, and proposing actions.

RetentionDiagnosisEngagement MetricsSpotify
Define Success for a New FeatureEasy

Define the right metrics to judge whether a new product feature is successful.

KPIsConversion RateLeading IndicatorsSpotify
More Metrics questions with a free account
4
Behavioral & Leadership3 questions · ~27 min
More Behavioral & Leadership questions with a free account
5
More topics2 questions · ~18 min
Design Playlist Photo Upload ServiceHard

Assesses system design thinking for a core Spotify media workflow.

system designleetcodesqlSpotify
Pandas Condition UpdateMedium

Tests your practical pandas skills for conditional transformations in analytics pipelines.

pandassqlSpotify
The finish line: interview-readyComplete all 26 questions plus 1 hands-on drill to finish this plan.