PayPal·Data Scientist·Technical Phone Screen
Jul 2026
Got a take-home style SQL case for a Data Scientist role on PayPal's fraud side. The problem was dense, like genuinely one of the harder SQL prompts I've seen in an interview context, and it tested whether you actually understand window functions and time-based filtering or just know how to write basic joins.
- You're on a fraud detection team. Write a single SQL query that identifies candidate account takeover events in the last 7 days. A candidate event requires: the user's first successful login from a new device or new IP in the prior 30 days, followed within 2 hours by a transfer over $500 to a first-time recipient. Exclude users whose accounts are less than 7 days old at login time. If multiple transfers match the same login, keep only the earliest. Return specific output columns including a reason code, and at the end recommend indexes to support the query on a PostgreSQL-like warehouse.
“This one took me a while to decompose.” The rest of the author's notes on Data Scientist interview at PayPal, 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