Roblox·Data Scientist·Technical Phone Screen
Jul 2026
SQL-heavy technical screen for a DS role at Roblox. Two questions, both around a social graph schema with users, posts, engagement events, and follows. Nothing behavioral, just pure query writing the whole time.
- Given a social product schema with users, posts, engagement events, and follows tables, write a SQL query that computes each user's influence score, defined as the total number of engagement events their posts received plus their total follower count.
- Using the same schema, write a SQL query that computes monthly follower growth per user, including new followers gained each month, the previous month's new follower count via LAG, a month-over-month growth rate with divide-by-zero handling, and a cumulative running total of followers.
“My first instinct was to do both aggregations in one big join and i immediately tangled myself up with duplicate counts.” The rest of the author's notes on Data Scientist interview at Roblox, 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