OpenAI·Data Scientist·Technical Phone Screen
- Write a SQL query to compute the intent-to-treat paid conversion rate within 60 days of first exposure, broken down by variant (control vs. trial), for users first exposed between June 1 and June 30, 2025. Each user should be counted once using only their first exposure, and users who had any payment before their first exposure must be excluded. Return variant, exposed user count, converters within 60 days, conversion rate, and 95% Wald confidence intervals.
- Write a second SQL query for a triggered analysis, restricting to users in the trial variant who actually started a trial, and compute their paid conversion rate within 60 days of first exposure.
- Write a data quality SQL query that flags the following anomalies: users who have a trial record but no prior exposure, users with multiple exposures on the same calendar day, exposure timestamps that come after trial_started_at, and duplicate user_ids in the users table.
“The leakage exclusion is where I got tripped up first.”