Meta·Data Scientist·Technical Phone Screen
Jul 2026
SQL-heavy technical screen for a DS role on an ads platform. Two questions, both multi-part, both requiring you to actually think about the data model rather than just write a join and call it a day. Left feeling okay about Q1 but Q2 had a wrinkle that tripped me up a bit.
- Given an ads platform schema with advertisers, ads, and daily spend tables, identify advertisers whose total 2023 spend exceeded $1,000. Then, for that cohort, calculate what percentage of total 2024 platform spend came from them. Return the eligible advertiser count, cohort 2024 spend, total 2024 platform spend, and the cohort share.
- Write a query returning monthly 2024 spend broken down by ad creation source, excluding certain advertiser types. Also include, within each month, the spend from advertisers where AI-assisted ad spend went up year-over-year while their manual ad spend went down, to surface potential cannibalization between creation sources.
“The cohort definition part is pretty clean, just a subquery or CTE filtering on 2023 spend.” 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