Meta·Data Scientist·Technical Phone Screen
Jul 2026
SQL-heavy technical screen for a DS role on the ads measurement side at Meta. Two questions, both tied to the same schema, escalating from a basic share calculation to a full stakeholder-facing time series. Felt more like a take-home prompt than a live interview.
- Given tables for ad revenue and ad conversions broken out by destination (Facebook Shop vs. external website), write SQL to compute the daily share of revenue going to the Shop destination over the most recent 30 days.
- Using the same two tables, build a stakeholder-ready daily time series for the past 30 days that evaluates performance by destination. It should include revenue, conversions, revenue per conversion, and at least one share-style diagnostic showing whether volume is shifting toward Shop versus the website.
“Pretty standard pivot-and-divide problem.” 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