Spotify Research Analyst Interview Questions
The questions to prepare for a Spotify Research Analyst interview. Questions from real interview reports rank first. Updated weekly.
Tests product intuition and ability to connect user behavior to product thinking for Spotify podcasts.
SpotifyTests research planning, hypothesis generation, and study design for improving Spotify podcast retention.
SpotifyTests product sense grounded in Spotify podcast usage and ability to translate observations into improvements.
SpotifyTests SQL skills for defining user activity cohorts using Spotify podcast listening behavior.
SpotifyTests metric selection and interpretation for diagnosing engagement decline in Spotify playlists.
SpotifyTests experimental design, causal inference, and metric selection for improving Spotify recommendations.
SpotifyTests metrics strategy and evaluation design for a creator-focused product change at Spotify.
SpotifyTests robustness in modeling with imperfect data and appropriate preprocessing for Spotify user segmentation.
SpotifySign up to see every question
Create a free account to unlock this list and practice real interview questions.
Compute daily active users and a 7-day rolling average using a CTE, distinct counts, and window functions.
Meta
Spotify
Meta ITUse CTEs, joins, and date filtering to calculate 30-day retention by signup cohort from login and feature usage data.
Curefit
ReachMobi
IndeedRank Spotify songs in a region by 30-day streams using joins, aggregation, date filtering, and RANK().
Spotify