Intuit Data Scientist Interview Questions
Intuit Data Scientist interview questions commonly converge on three things: applied technical craft, product-minded problem solving, and clear communication. What’s distinctive about interviewing at Intuit is the customer-first lens — expect case-study style prompts and a short take‑home or presentation that ask you to connect models and analyses to measurable customer impact. The process typically evaluates coding and SQL fluency, statistical reasoning and experiment design, modeling tradeoffs, and your ability to tell a concise data story to cross‑functional partners. For interview preparation focus on three threads: polish concise, resume‑based stories that show ownership and measurable outcomes; rehearse end‑to‑end analytics work (SQL queries, exploratory analysis, model choices and evaluation) and a short presentation of results; and practice behavioral and collaboration examples that show how you influence product decisions. Mock the take‑home and craft presentation under time pressure, review fundamentals in Python/SQL/statistics, and be ready to explain assumptions, tradeoffs, and how your solution would move customer metrics.
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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 ...
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...
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...
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. ...