Robinhood·Data Scientist·Technical Phone Screen
Jun 2026
Robinhood fraud/risk analytics round for a Data Scientist role. Three SQL questions, all revolving around a transactions table, and they got progressively nastier toward the end. Not a vibe-check round at all, they wanted you to actually write the queries.
- Write a SQL query to find the top 3 users with the highest total declined transaction amount within the last 7 days.
- For each user and day, flag whether they had more than two transactions where the amount is NULL or greater than 500 within any 24-hour rolling window. Return user_id, window_start, and a risky_flag column.
- Add a risk_level column to the transactions table using conditional logic: label amounts above 800 as high, amounts between 500 and 800 as medium, and everything else as low. Return 10 sample rows ordered by most recent timestamp.
“Pretty approachable as a warmup.” The rest of the author's notes on Data Scientist interview at Robinhood, 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