Spotify Analytics Engineer Interview Questions

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

26questions

~4htotal time

Track your progressSign up free to work through all 26 questions and resume where you left off.

SQL & Data ManipulationStart here. 9 questions + 1 drill · ~90 min

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

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 FunctionsAggregations

Spotify

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

More SQL & Data Manipulation questions with a free account

Metrics5 questions · ~45 min

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

Investigate User Engagement DeclineMedium

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

RetentionDiagnosisEngagement Metrics

Spotify

More Metrics questions with a free account

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

Pipelines7 questions · ~62 min

Data Quality in ETL PipelinesEasy

Approach for maintaining data quality and integrity across ETL pipelines.

IdempotencyData ModelingQuality

Spotify

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

Behavioral & Leadership3 questions · ~27 min

More Behavioral & Leadership questions with a free account