Intuit Data Scientist Interview Questions
Practice the exact questions companies are asking right now.
Compute monthly signups, conversion, and YoY growth
You work at a subscription company and are given a user-level table. Table company_users - id (INT, PK) — user/customer id - signup_date (DATE) — date...
Design an experiment for pricing page redesign
A product team is redesigning a pricing tier page. Historically the page only offered a monthly plan; the redesign adds an annual plan option. You are...
Pivot daily users and revenue by platform
You are given transaction-level data and need daily aggregates by platform. Input (Pandas DataFrame) df with columns: - file_date (DATE or string pars...
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. ...
Diagnose KPI anomaly and evaluate promotion/A-B test
You are a Data Scientist supporting a TurboTax product team. You are asked to handle three related analytics tasks. 1) KPI anomaly investigation A das...
Build a predictive model from TurboTax sample data
You receive a TurboTax sample dataset (user-level and/or session-level) and are asked to build a predictive model. Task 1. Pick a concrete prediction ...
Implement nth Fibonacci number
Problem Write a function that returns the n-th Fibonacci number. The Fibonacci sequence is defined as: - \(F(0)=0\) - \(F(1)=1\) - \(F(n)=F(n-1)+F(n-2...