Meta·Data Scientist·Technical Phone Screen
Apr 2026
Meta DS technical screen, one SQL question that looked manageable until I actually started writing it. Two separate metrics in one query, timezone conversion, and a 7-day rolling window all at once.
- Given a users table and a calls table for a voice-calling product, write SQL to compute two metrics per report date: (1) the percentage of callers who made at least 20 calls in the past 7 days out of all callers active in that window, and (2) the percentage of Great Britain daily active users who had 50 or more total call participations (as caller or recipient) on that date. Return one row per report date with both percentages.
“The timezone piece got me first.” The rest of the author's notes on Data Scientist interview at Meta, Technical Phone Screen round, covers how they worked through the question, what the panel pushed back on, and what they would do differently.
View Post