Intuit Data Scientist Interview Questions
Master your tech interview with our curated database of real questions from top companies.
Decide when to model courier ETA
Predicting Delivery ETA (Pickup → Drop-off): Case For or Against ML Context: You’re proposing an ETA model to predict the time from rider pickup to cu...
Explain a non-linear industry switch
Behavioral Interview Prompt — Transition from Semiconductor to SaaS Analytics You are in an HR screen for a Data Scientist role. The interviewer chall...
Design an idempotent churn ETL pipeline
You must build a daily pipeline that produces month-end churn metrics (logo churn, gross revenue churn, net revenue retention) from streaming subscrip...
Choose the right test for proportions
A/B Test on Delivery Completion Rate (Binary Outcome) Context: You are evaluating an A/B test on a binary metric (delivered_bool). Treat each order as...
Diagnose rising delivery cost precisely
Problem: Delivery Cost per Order Increased — Design an Analysis Plan Context A restaurant reports a significant increase in delivery cost per order in...
Compute churn and revenue churn in SQL
You receive monthly end-of-month subscription snapshots and must compute August-2025 churn metrics. Schema and sample data: Table: subscription_monthl...
Build 30-day retention cohort table
Monthly 30-Day Retention Cohort (PostgreSQL) Context You are given a table of companies with signup and (optional) termination dates. Define monthly c...
Compute paid subscriber YoY counts by month
Write a single SQL query (PostgreSQL) that returns calendar-month counts of new paid subscribers starting from 2019-06-01 (inclusive) through the late...
Build cohort 30-day retention from signup date
Task: Monthly Cohorted Retention (30-day, then 30/60/90-day curve) You are given a single table, company, with columns: - company_id (INT) - signup_da...
Exclude free subscribers via anti-join
Extend your previous monthly new-subscriber + YoY query to exclude companies that ever received a free subscription, using an anti-join against Free_S...
Compute monthly new subscribers and YoY deltas
Write a single SQL query that returns monthly counts of new subscribers starting at 2019-06, plus year-over-year (same-month prior year) comparisons. ...