Top 35
Prep plan
Updated weekly · Last refresh Aug 30

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 weekly.

35questions
~5htotal time
Track your progressSign up free to work through all 35 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
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
Data Modeling ConceptsEasy

Tests your ability to structure data models that support reporting and operational workflows.

Data WranglingData ModelingEvernorth Health Services
Core SQL ConceptsEasy

Tests your SQL fundamentals for querying and analyzing data used in healthcare operations.

sql basicsJoinsAggregationsEvernorth Health Services
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
Find Spending Variance Drivers by DepartmentHard
Practice
Practice drill

Use joins and LAG to isolate departments driving a large month-over-month spending variance.

JoinsData WranglingGroup ByState of CaliforniaUniversity of ChicagoThe Church of Jesus Christ of Latter-day Saints
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
Behavioral & Leadership25 questions · ~200 min
Handling a Difficult Requirements StakeholderMedium

Tests conflict resolution and stakeholder management while gathering requirements under friction, ambiguity, and changing expectations.

Conflict ResolutionStakeholder ManagementrequirementsEvernorth 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 ExperienceEasy

Tests your ability to summarize relevant experience and connect it to the Data Analyst role.

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