Top 21
Prep plan
Updated weekly · Last refresh Oct 17

Aetna Data Analyst Interview Questions

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

21questions
~3htotal time
Track your progressSign up free to work through all 21 questions and resume where you left off.
Start practicing free →
1
SQL & Data ManipulationStart here. 6 questions + 1 drill · ~65 min
Handling Duplicates and Nulls in SQLEasy

Explain practical SQL approaches for identifying, removing, and preventing duplicates and NULL-related data quality issues.

Data WranglingGroup ByCase WhenAetna
SQL Querying With JoinsMedium

Evaluates practical SQL skills for transforming and aggregating data for analysis.

Data AnalysissqlAetna
Optimize Slow Claims AggregationHard

Tests query optimization techniques for large-scale analytics workloads.

Performance TuningsqlAggregationsAetna
Top-Decile Utilization SQLHard
Practice
Practice drill

Identify members in the highest utilization decile using CTEs and ranking window functions.

RankingCTEssqlAetna
More SQL & Data Manipulation questions with a free account
2
Metrics3 questions · ~27 min
Measure ROI of Bilingual InitiativeMedium

Tests KPI selection, causal thinking, and ROI measurement for program evaluation.

roiKPIpilot metricsAetna
Investigate Enrollment Drop Root CauseMedium

Tests structured troubleshooting and data-driven root cause analysis for business impact.

Funnel AnalysisKPIDiagnosisAetna
KPIs for Field Analyst WorkloadEasy

Tests ability to define actionable KPIs aligned to operational efficiency and capacity.

deliveryKPIproject healthAetna
3
Behavioral & Leadership11 questions · ~101 min
Owning a Submitted Analysis ErrorEasy

Tests ownership, self-awareness, and communication when a candidate finds a mistake in their own completed analysis.

failureOwnershipaccountabilityAetna
More Behavioral & Leadership questions with a free account
4
More topics1 question · ~9 min
US Highway Miles EstimationHard

Assesses estimation reasoning and ability to structure ambiguous quantitative problems.

EstimationAetna

Sign up to see every question

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

Get my prep plan
The finish line: interview-readyComplete all 21 questions plus 1 hands-on drill to finish this plan.