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

Optum Data Analyst Interview Questions

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

33questions
~4htotal time
Track your progressSign up free to work through all 33 questions and resume where you left off.
Start practicing free →
1
SQL & Data ManipulationStart here. 11 questions + 3 drills · ~118 min
GROUP BY vs OVERMedium

Tests your ability to distinguish aggregation vs windowed calculations in SQL.

Window FunctionsRankingGroup ByOptum
DAX Year-Over-Year ComparisonMedium

Tests your DAX and Power BI skills for time-based comparisons.

Date FunctionsAggregationsOptum
Self-Join Hierarchy QueryMedium

Tests your SQL ability to model hierarchies using self-joins.

JoinsSelf-JoinsOptum
Normalized vs Denormalized ModelsMedium

Evaluates your data modeling tradeoffs for performance, maintainability, and analytics.

CloudOptum
SQL Join Types With ExamplesMedium

Tests your understanding of join semantics and when to use each join type in SQL.

JoinssqlOptum
Deduplicate Data in SQLMedium

Assesses your approach to removing duplicates using SQL patterns like window functions or grouping.

data cleaningsqlOptum
Finding Duplicate RecordsEasy
Practice
Practice drill

Find duplicate customer emails using GROUP BY and HAVING in PostgreSQL.

Group ByHavingAggregationsWestern DigitalBismartUniversity of Kansas Medical Center
Second Highest Trader SalaryEasy
Practice
Practice drill

Find the second highest distinct salary from a single table using basic PostgreSQL ordering and limiting.

SubqueriesRankingSortingeClinicalWorksInformaticaSpectraforce Technologies
SQL Name Formatting QueryEasy
Practice
Practice drill

Use PostgreSQL string functions to convert full names into a Last, First display format.

sql queryOptum
More SQL & Data Manipulation questions with a free account
2
Behavioral & Leadership21 questions · ~168 min
Handling Stakeholder Pushback on FindingsMedium
Recently asked

Tests conflict resolution and influence when a non-technical stakeholder challenges analytical findings.

Conflict ResolutionStakeholder ManagementCommunicationOptum
More Behavioral & Leadership questions with a free account
3
More topics1 question · ~8 min
Understanding P-ValuesMedium

Evaluates your understanding of statistical significance and hypothesis testing concepts.

Optum

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