Spotify Business Analyst Interview Questions
The questions to prepare for a Spotify Business Analyst interview. Questions from real interview reports rank first. Updated weekly.
Tests strategic thinking, market assumptions, and decision criteria for Spotify subscription product changes.
SpotifyTests financial modeling skills and ability to quantify impact of royalty policy changes on Spotify economics.
SpotifyTests structured root-cause analysis and data-driven solutioning for Spotify subscription churn.
SpotifyTests performance troubleshooting and query optimization strategies for large-scale Spotify datasets.
SpotifyTests SQL join understanding and correct application to subscription funnel analysis at Spotify.
SpotifyTests window function knowledge and ability to implement rolling metrics for Spotify engagement analysis.
SpotifyUse CTEs, joins, and date filtering to calculate 30-day retention by signup cohort from login and feature usage data.
Curefit
ReachMobi
IndeedCompute daily active users and a 7-day rolling average using a CTE, distinct counts, and window functions.
MetaSpotify
Meta ITRank Spotify songs in a region by 30-day streams using joins, aggregation, date filtering, and RANK().
SpotifyTests KPI selection and measurement design for product outcomes at Spotify.
SpotifyTests data segmentation approach and ability to translate user behavior into actionable targeting at Spotify.
SpotifySign up to see every question
Create a free account to unlock this list and practice real interview questions.