Moloco·Data Scientist·Technical Phone Screen
Apr 2026
SQL-heavy screen for a data scientist role at Molocoads. Two questions, both involving multi-table joins and window functions. Nothing behavioral, just pure query writing under time pressure.
- Given a table of daily ad spend by advertiser, find the top 3 spending advertisers for each day. Handle ties so that advertisers tied within rank 3 are all included. Return the date, advertiser ID, their total daily spend, and their rank.
- For each campaign goal type, calculate the total spend, total KPI conversions, and cost per KPI. Only include spend and conversions that occurred on or after the campaign's launch date. Return NULL for cost per KPI if there were zero conversions.
“This is a DENSE_RANK vs ROW_NUMBER question in disguise.” The rest of the author's notes on Data Scientist interview at Moloco, 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