In progressTechnical Screen

Four Retention SQL Questions in a 45-Minute Screen

MixpanelData Scientist · Technical Screen · Sep 2026

Straight to the useful stuff. My Mixpanel Data Scientist phone interview was a SQL screen, around 45 minutes, with someone from the DS team. Table structures, restated as I understood them, roughly like this: users: user_id, signup_date, plan_type, ... events: user_id, event_ts, ... There were four questions, each building on the previous one, all about retention analysis. Q1: How many users had…

Shared by a candidate · reported Sep 2026. Interview formats change; use it as a guide, not a script.