Top 22
Prep plan
Updated weekly · Last refresh Oct 17

Memorial Sloan Kettering Cancer Center Data Analyst Interview Questions

The questions to prepare for a Memorial Sloan Kettering Cancer Center Data Analyst interview. Questions from real interview reports rank first. Updated daily.

22questions
~3htotal time
Track your progressSign up free to work through all 22 questions and resume where you left off.
Start practicing free →
1
SQL & Data ManipulationStart here. 11 questions + 2 drills · ~114 min
Customer Orders: LEFT vs INNER JOINEasy

Explain how INNER JOIN and LEFT JOIN differ, and when to use each for matched-only versus all-left-row analysis.

JoinsData WranglingGroup ByMemorial Sloan Kettering Cancer Center
Top Departments by AdmissionsMedium
Practice

Write a SQL query to find the top three departments by patient admission volume over the last quarter. Use the provided department and admission data. Tre...

Date FunctionsJoinsRankingMemorial Sloan Kettering Cancer Center
Efficient SQL for Large DatabasesMedium

Tests ability to craft performant SQL for large-scale analytics workloads.

Window FunctionsJoinsAggregationsMemorial Sloan Kettering Cancer Center
Top Customers by Net SalesMedium
Practice
Practice drill

Compute top 10 customers by net sales using joins and aggregations, ordering by revenue with deterministic tie-breaking.

SubqueriesJoinsData WranglingGain DigitalTCSZest AI
Unify CRM and Google Analytics ViewHard
Practice
Practice drill

Merge CRM orders with GA events via an identity map to build a customer-level view using joins, window functions, and monthly rollups.

SubqueriesJoinsData WranglingArtefact
More SQL & Data Manipulation questions with a free account
2
Metrics7 questions · ~60 min
Success Metrics for TrialsEasy

Tests ability to translate objectives into measurable KPIs for clinical or departmental performance.

KPIsLeading IndicatorsMemorial Sloan Kettering Cancer Center
Root Cause of Discharge DelaysMedium

Tests diagnostic thinking using operational and clinical data to explain a KPI spike.

KPIsLeading IndicatorsDiagnosisMemorial Sloan Kettering Cancer Center
Discharge Time Root Cause DataMedium

Tests ability to select relevant features and datasets for diagnosing discharge-time changes.

KPIsLeading IndicatorsDiagnosisMemorial Sloan Kettering Cancer Center
More Metrics 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
More topics4 questions · ~34 min
Design Basic ETL WorkflowMedium

Tests ability to plan extraction, transformation, and loading steps for healthcare analytics reporting.

ETLData ModelingQualityMemorial Sloan Kettering Cancer Center
Predictive Analytics for AdmissionsHard

Tests ability to build and validate predictive models for healthcare operations using statistical methods.

RegressionCorrelationCausal InferenceMemorial Sloan Kettering Cancer Center
More questions with a free account
The finish line: interview-readyComplete all 22 questions plus 2 hands-on drills to finish this plan.