Dataford
Dataford
Top 17
Prep plan
Updated weekly · Last refresh Oct 17

Zelis Healthcare Data Analyst Interview Questions

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

17questions
~2htotal time
Track your progressSign up free to work through all 17 questions and resume where you left off.
Start practicing free →
1
SQL & Data ManipulationStart here. 5 questions + 2 drills · ~64 min
Explain SQL Join TypesEasy

Explain INNER, LEFT, RIGHT, FULL OUTER, CROSS, and SELF JOINs with examples and when to use each.

JoinsData WranglingGroup ByZelis Healthcare
Window Ranking in Ticket QueuesMedium

Explain SQL window functions and when to use ROW_NUMBER() versus DENSE_RANK() for ranked ticket analysis.

Window FunctionsRankingrow_numberZelis Healthcare
Second-Highest Claims AmountMedium
Practice

Identify the second-highest distinct transaction amount in claims data, including duplicate amount handling.

SubqueriesRankingsqlZelis Healthcare
Top-N Per Department with Window FunctionsMedium
Practice
Practice drill

Use DENSE_RANK to identify the three highest-paid UKG employees in each department, including salary ties.

Window FunctionsJoinsRankingUKGDeloitte
Second-Highest Subscriber PaymentMedium
Practice
Practice drill

Find the second-highest distinct subscriber payment from billing records using aggregation and a scalar subquery.

Subqueriesnull handlingRankingSpectrum
More SQL & Data Manipulation questions with a free account
2
Behavioral & Leadership7 questions · ~61 min
More Behavioral & Leadership questions with a free account
3
More topics5 questions · ~44 min
Diagnose a Customer Satisfaction DropMedium

Investigate a sudden drop in customer satisfaction and separate leading signals from the final NPS readout.

NPSLeading IndicatorsDiagnosisZelis Healthcare
Detect Anomalous Data PointsMedium

Tests your ability to spot anomalies and justify conclusions from data trends.

Biasanomaly detectionZelis Healthcare
Dashboard for Provider OnboardingMedium

Tests your product thinking and ability to define metrics and visuals for Zelis provider onboarding.

onboardinguser valuedashboardingZelis Healthcare
Sentiment from Support TranscriptsMedium

Tests your approach to NLP/pipelines for turning text data into structured sentiment signals.

Data QualityData WranglingZelis Healthcare
KPIs for Automated BillingMedium

Tests your ability to translate billing workflows into measurable KPIs and tracking plans.

project healthkpi hierarchyZelis Healthcare

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 17 questions plus 2 hands-on drills to finish this plan.