Upstart·Data Scientist·Technical Phone Screen
Jul 2026
SQL-heavy technical screen for a Data Scientist role at Upstart. Three prompts all built around the same two-table schema, escalating from aggregation to attribution to a filtered count. The edge cases were the real test, not the queries themselves.
- Given a table of marketing touches, compute for each calendar month the average number of touches per company, where the denominator is only companies that had at least one touch in that month (not all companies in the dataset).
- For each company that converted, find the last marketing touch at or before the conversion timestamp. Return the company, conversion time, last touch time, channel, campaign, and a flag for whether the touch and conversion happened in the same calendar month. Exclude companies with no prior touches.
- Count the distinct companies where the last touch and conversion fall in the same calendar month. As a follow-up, also produce a version that additionally requires the gap between conversion and last touch to be 45 days or fewer.
“The denominator scoping is where people slip up.” The rest of the author's notes on Data Scientist interview at Upstart, 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