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

Optumrx Business Analyst Interview Questions

The questions to prepare for a Optumrx Business 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. 3 questions + 3 drills · ~54 min
Excel Lookup FunctionsMedium

Assesses practical Excel skills and data validation for reliable analysis.

excel functionsOptumrx
Merging Data With IntegrityMedium

Tests your data quality practices for reliable dataset merging across Optumrx operational systems.

Data WranglingReconciliationdata integrityOptumrx
Excel for Large DatasetsEasy

Tests your hands-on Excel skills for analysis and reporting in a BA workflow.

Data WranglingperformanceExcelOptumrx
SQL With Complex Joins and AggregationsHard
Practice
Practice drill

Combine OptumRx claims, prescriptions, pharmacies, and members to calculate utilization metrics with CTEs and window functions.

JoinsGroup ByAggregationsModernaOptumrxFlatiron Health
Total Prescriptions Per MemberMedium
Practice
Practice drill

Given a table of prescription transactions and a table of members, write a query to find the total prescriptions per member for the last 30 days. Return e...

Date FunctionsJoinsAggregationsOptumrx
Excel Reconciliation With DataMedium
Practice
Practice drill

Reconcile weekly Adobe transaction totals against control totals and identify missing or mismatched records.

large datasetsData WranglingReconciliationAdobe

Sign up to see every question

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

Get my prep plan
2
Behavioral & Leadership18 questions · ~144 min
Unexpected Data Trend PivotMedium

Tests data-driven leadership: spotting a surprising signal, validating it, and influencing stakeholders to pivot strategy.

Decision Makingimpactbusiness strategyOptumrx
Shifting Requirements During a SprintMedium

Tests how you handle ambiguity and re-prioritize mid-execution while aligning stakeholders and maintaining delivery momentum.

AgileadaptabilityDealing With AmbiguityOptumrx
Handling a Difficult Requirements StakeholderMedium

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

Conflict ResolutionStakeholder ManagementrequirementsOptumrx
Prioritizing Competing Growth RequestsEasy

Tests prioritization under pressure, stakeholder management, and ownership when multiple important initiatives compete for limited time.

Stakeholder ManagementOwnershipPrioritizationOptumrx
Owning a Project MistakeMedium

Tests ownership after a project mistake, especially how you communicate bad news, recover trust, and drive a concrete resolution.

Conflict ResolutionCommunicationOwnershipOptumrx
More Behavioral & Leadership questions with a free account
The finish line: interview-readyComplete all 21 questions plus 3 hands-on drills to finish this plan.