Top 22
Prep plan
Updated weekly · Last refresh Oct 17

Optum Tech Data Analyst Interview Questions

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

22questions
~3htotal time
Track your progressSign up free to work through all 22 questions and resume where you left off.
Start practicing free →
1
SQL & Data ManipulationStart here. 6 questions + 3 drills · ~78 min
Optimizing Slow PostgreSQL Production QueriesHard

Explain how to diagnose slow PostgreSQL queries in production and choose effective indexing strategies.

Performance Tuningindexesquery optimizationOptum Tech
Handling Missing and Dirty SQL DataMedium

Explain how to profile, clean, and standardize missing or dirty data before analysis.

Data WranglingCase WhenQualityOptum Tech
SQL to Tableau for Business UsersHard

Assesses end-to-end analytics delivery from SQL extraction to Tableau communication.

sql queriesOptum Tech
Tableau vs Power BI for ExecsMedium

Assesses your understanding of BI tools and how you tailor dashboards for leadership.

data visualizationpower biOptum Tech
Complex SQL Joins and AggregationsMedium

Tests your ability to write complex SQL and translate results into business outcomes.

business problemcomplex queriessqlOptum Tech
Validating Report AccuracyMedium

Evaluates your quality checks and controls to ensure trustworthy analytics.

model validationstakeholder communicationOptum Tech
SQL Window Functions ExperienceMedium
Practice
Practice drill

Use SQL window functions to rank regions by average 2024 yield within each country.

Window FunctionsJoinsData ManipulationErnst & YoungKBRMaximus Tech
Nth Highest Salary QueryEasy
Practice
Practice drill

Find all active Freecharge employees at the third-highest distinct salary using DENSE_RANK and a department join.

sql querydatabase queryingFreechargeOptum TechUKG
SQL ExperienceMedium
Practice
Practice drill

Aggregate approved employee hours by department, including departments without qualifying records.

experienceJoinsCase WhenNational IndemnityDayforceAvalara

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 & Leadership16 questions · ~128 min
Responding to Tough Analytical FeedbackEasy

Tests how you handle criticism with maturity, communicate constructively, and turn feedback into better analytical work.

Conflict ResolutionCommunicationLeadershipOptum Tech
Critical Report Under Tight DeadlineMedium

Tests prioritization under pressure, ownership, and stakeholder communication when delivering a high-stakes report on a compressed timeline.

pressure handlingdeadline managementreportingOptum Tech
More Behavioral & Leadership questions with a free account
The finish line: interview-readyComplete all 22 questions plus 3 hands-on drills to finish this plan.