Boston Consulting Group·Data Scientist·Technical Phone Screen
Apr 2026
BCG data scientist interview, one big SQL question that looked manageable until I actually tried to write it out. More of a technical screen vibe than a full onsite, and the problem had enough moving parts to trip you up if you're not careful with window functions and date filtering.
- Write a SQL query that computes, per car model, the total revenue for the current 7-day window and the prior 7-day window (completed orders only), identifies the top 3 customers by spend in the current window with their share of model revenue, and calculates week-over-week revenue growth. Ties in the top-3 ranking should be broken by the customer's earliest purchase date on that model across all history.
“This one took me longer to structure than I expected.” The rest of the author's notes on Data Scientist interview at Boston Consulting Group, 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