Top 13
Prep plan
Updated weekly · Last refresh Nov 5

Stanford School of Medicine Data Scientist Interview Questions

The questions to prepare for a Stanford School of Medicine Data Scientist interview. Questions from real interview reports rank first. Updated daily.

13questions
~2htotal time
Track your progressSign up free to work through all 13 questions and resume where you left off.
Start practicing free →
1
SQL & Data ManipulationStart here. 3 questions + 1 drill · ~40 min
Rolling 7-Day Average with Window FunctionsMedium
Practice

Calculate patient rolling 7-day averages and rank patients within each Medpace research site using layered window functions.

Window FunctionsRankingRunning TotalsStanford School of Medicine
SQL Ranking FunctionsMedium
Practice

Compare RANK, DENSE_RANK, and ROW_NUMBER by applying each to ordered employee scores.

Data ManipulationRankingdatabase queryingStanford School of Medicine
Analyzing Missing Values in Clinical DataMedium

Explain how to profile, quantify, and handle missing values in joined clinical datasets using SQL.

Data WranglingCase WhenAggregationsStanford School of Medicine
Use Window FunctionsMedium
Practice
Practice drill

Demonstrate window functions by ranking active employees by salary within each department.

Window FunctionsData ManipulationRankingJohnson & JohnsonAvidXchangeCRIF
2
Product Sense4 questions · ~39 min
Balancing Outcomes and EngagementHard

Explain how to prioritize long-term clinical outcomes when short-term engagement metrics point in a different direction.

MetricsFeature Prioritizationuser valueStanford School of Medicine
Diagnosing a Daily Active User DropHard

Diagnose a 5% drop in Intercom daily active users, separating data quality issues from real changes in user behavior.

product analysisMetricsData AnalysisStanford School of Medicine
More Product Sense questions with a free account

Sign up to see every question

Create a free account to unlock this list and practice real interview questions.

Get my prep plan
3
Behavioral & Leadership3 questions · ~30 min
More Behavioral & Leadership questions with a free account
4
More topics3 questions · ~30 min
Investigate Metric DropMedium

Diagnose a below-expectations product metric drop using decomposition, guardrails, and experiment checks.

metric selectionDiagnosiskpi hierarchyStanford School of Medicine
Compute A/B Test Sample SizeHard

Determine the sample size needed to detect a meaningful A/B test effect at a chosen significance level and power.

experiment designMDEStatistical SignificanceStanford School of Medicine
Design Test for New FeatureMedium

Design an A/B test for a new platform feature, including success metrics, power, guardrails, and a clear ship decision.

experiment designfeature evaluationA/B TestingStanford School of Medicine
The finish line: interview-readyComplete all 13 questions plus 1 hands-on drill to finish this plan.