Top 19
Prep plan
Updated weekly · Last refresh Aug 30

Milliman Data Analyst Interview Questions

The questions to prepare for a Milliman Data Analyst interview. Questions from real interview reports rank first. Updated weekly.

19questions
~3htotal time
Track your progressSign up free to work through all 19 questions and resume where you left off.
Start practicing free →
1
SQL & Data ManipulationStart here. 6 questions + 3 drills · ~78 min
LEFT vs INNER JOIN for PatientsEasy

Tests join selection and correctness when combining healthcare datasets with different coverage.

JoinsData WranglingsqlMilliman
Explain and Optimize a JOINMedium

Tests understanding of JOIN logic and performance optimization in SQL for analytics work.

Performance TuningJoinssqlMilliman
Handle Nulls in SQL AggregatesEasy

Tests correct treatment of nulls in SQL aggregations to produce reliable metrics.

null handlingsqlAggregationsMilliman
Walk Through Dataset AnalysisMedium

Assesses your end-to-end approach to exploring, validating, and deriving insights from a dataset.

Data AnalysisMilliman
Excel and Programming AssessmentHard

Tests your practical workflow for combining Excel and code to analyze data reliably.

ExcelMilliman
Explain a SQL QueryMedium

Evaluates your ability to interpret SQL logic and communicate it clearly.

sqlMilliman
Longest Consecutive Login Streak per UserHard
Practice
Practice drill

Calculate the longest consecutive login streak for each user using window functions and date manipulations.

Window FunctionsJoinsAggregationsChimeECSSalesforce
Second Highest Without AggregatesHard
Practice
Practice drill

Find the second highest salary in each department without using aggregate functions.

SubqueriesRankingSelf-JoinsCredit GenieDevoteamCisco Restaurant + Bar
Weekly Service KPI by TeamMedium
Practice
Practice drill

Analyze weekly service delivery performance by team using joins, a CTE, date aggregation, and KPI calculations.

KPIJoinssqlDeloitteReputation
2
Behavioral & Leadership12 questions · ~96 min
Resume Project With Business ImpactEasy

Tests ownership and data-driven communication through a concrete example of analysis that led to measurable business impact.

impactresumesuccess storyMilliman
More Behavioral & Leadership questions with a free account
3
More topics1 question · ~8 min
The finish line: interview-readyComplete all 19 questions plus 3 hands-on drills to finish this plan.