Dataford
Dataford
Top 14
Prep plan
Updated weekly · Last refresh Oct 17

Spotify Data Analyst Interview Questions

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

14questions
~2htotal time
Track your progressSign up free to work through all 14 questions and resume where you left off.
Start practicing free →
1
SQL & Data ManipulationStart here. 3 questions + 2 drills · ~47 min
7-Day Rolling Active UsersMedium
Practice

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

Window FunctionsDate FunctionsRunning TotalsSpotify
Left Join vs Inner JoinEasy

Tests SQL join semantics and correct interpretation for Spotify funnel-style analyses.

Joinsmany-to-onedata integritySpotify
Window Functions for Listening DataMedium
Practice
Practice drill

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

Window FunctionsJoinsData ManipulationSpotify
Calculate 30-Day User RetentionHard
Practice
Practice drill

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

Window FunctionsDate FunctionsAggregationsCurefitIndeedTikTok
More SQL & Data Manipulation questions with a free account
2
Pipelines3 questions · ~27 min
Real-Time Dashboard Data PipelineMedium

Design a streaming pipeline that keeps dashboard data fresh and accurate for operational reporting.

InfrastructureStream ProcessingOrchestrationSpotify
Ad Interaction Data ModelHard

Tests data modeling skills for end-to-end ad attribution in Spotify analytics.

fact tablesdimensionsData ModelingSpotify
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
Behavioral & Leadership4 questions · ~35 min
More Behavioral & Leadership questions with a free account
4
More topics4 questions · ~35 min
Diagnose Client Engagement DropMedium

Diagnose a sharp decline in client engagement and break it down into cohorts, funnel steps, and likely business drivers.

Leading IndicatorsDiagnosisEngagement MetricsSpotify
A/B Test for Spotify Home UIMedium

Tests experiment design, instrumentation, and evaluation planning for changes to Spotify UX.

Hypothesis TestingGuardrail MetricsA/B TestingSpotify
Power and Sample Size for TestsMedium

Tests understanding of statistical power and practical sample size planning for Spotify experiments.

Statistical SignificancePower AnalysisSample SizeSpotify
Podcast Recommendation Engine MetricsMedium

Tests metric selection and KPI design for Spotify recommendation systems.

product metricsKPIEngagement MetricsSpotify
The finish line: interview-readyComplete all 14 questions plus 2 hands-on drills to finish this plan.