Dataford
Top 21
Prep plan
Updated weekly · Last refresh Aug 30

Optumrx Business Analyst Interview Questions

The questions to prepare for a Optumrx Business Analyst interview. Questions from real interview reports rank first. Updated weekly.

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
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
Excel Lookup FunctionsMedium

Assesses practical Excel skills and data validation for reliable analysis.

excel functionsOptumrx
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 ByAggregationsModernaOptumrx
Unify Campaign Performance SourcesMedium
Practice
Practice drill

Use CTEs, joins, aggregations, and CASE logic to combine Salesforce, Marketo, and Google Analytics into one monthly campaign report.

Data WranglingperformanceReconciliationPalo Alto Networks
Clean Null Campaign MetricsEasy
Practice
Practice drill

Use CASE and COALESCE to standardize missing StackAdapt campaign metrics and count incomplete rows by campaign.

null handlingData WranglingReconciliationStackadaptCvent

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
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
Handling a Difficult Requirements StakeholderMedium

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

Conflict ResolutionStakeholder ManagementrequirementsOptumrx
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
Prioritizing Competing Growth RequestsEasy

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

Stakeholder ManagementOwnershipPrioritizationOptumrx
Leading a Deadline-Critical DeliveryMedium

Tests prioritization under pressure, ownership, and stakeholder alignment when leading a high-stakes project on a compressed timeline.

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