Top 34
Prep plan
Updated weekly · Last refresh Oct 17

Evernorth Health Services Business Analyst Interview Questions

The questions to prepare for a Evernorth Health Services Business Analyst interview. Questions from real interview reports rank first. Updated daily.

34questions
~5htotal time
Track your progressSign up free to work through all 34 questions and resume where you left off.
Start practicing free →
1
SQL & Data ManipulationStart here. 8 questions + 3 drills · ~94 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 ByEvernorth Health Services
Salesforce Platform CoverageHard

Assesses breadth of Salesforce capabilities and how you deliver features end to end.

Evernorth Health Services
HashMap and String LogicMedium

Tests your reasoning with core data structures and string manipulation techniques.

Data StructuresEvernorth Health Services
SQL Joins and Basic ManipulationEasy

Tests your ability to work with joins and core SQL operations for healthcare data analysis.

JoinsData WranglingEvernorth Health Services
SQL Join for Prescription FrequencyMedium

Tests your ability to write correct SQL joins and aggregations for healthcare analytics use cases.

JoinstransactionsAggregationsEvernorth Health Services
Visits Per Patient Ranking QueryMedium
Practice
Practice drill

Count visits for every patient and rank patients by visit volume, preserving patients with no visits.

JoinsRankingGroup ByEvernorth Health Services
Top 10 Patients by VisitsMedium
Practice
Practice drill

Use a CTE and LEFT JOIN to find the 10 Massachusetts General Hospital patients with the most non-cancelled 2025 visits.

RankingGroup ByAggregationsMassachusetts General HospitalAdventHealth Sports Med & Rehab OrlandoEvernorth Health Services
SQL Duplicate Record DetectionEasy
Practice
Practice drill

Find duplicate American Institutes for Research assessment submissions using a CTE, GROUP BY, HAVING, and joins.

deduplicationsqldata integrityAmerican Institutes for ResearchPublix Super MarketsMacy's
More SQL & Data Manipulation questions with a free account
2
Behavioral & Leadership24 questions · ~192 min
Deep Dive on a Resume ProjectEasy

Tests ownership, communication, and technical depth by asking you to explain one resume project with clear decisions, impact, and reflection.

Stakeholder ManagementCommunicationOwnershipEvernorth Health Services
More Behavioral & Leadership questions with a free account
3
More topics2 questions · ~16 min
Tableau Dashboard Metric PrioritizationMedium

Tests your ability to translate stakeholder needs into effective dashboard metrics and visualizations.

Stakeholder ManagementMetricsdashboard designEvernorth Health Services
Tell Me About Your Past ExperienceMedium

Describe a past project you delivered, including your role, planning approach, stakeholder coordination, and results.

Success CriteriaExecutiondelivery managementEvernorth Health Services

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