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

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

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
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
SQL to Tableau for Business UsersHard

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

sql queriesOptum Tech
Validating Report AccuracyMedium

Evaluates your quality checks and controls to ensure trustworthy analytics.

model validationstakeholder communicationOptum 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 queryingFreechargeBrillioOptum Tech
Normalize Messy CRM Contact DataHard
Practice
Practice drill

Clean inconsistent CRM contacts by joining source tables, standardizing values, and flagging bad records.

Data WranglingCase WhenQualityAlphaSense
Validate Monthly Revenue Data QualityHard
Practice
Practice drill

Use joins, a CTE, and CASE logic to flag messy monthly order data and produce cleaned revenue by month.

Data WranglingCase WhenQualityLiterati

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
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
Explaining a Technical Concept ClearlyEasy
Recently asked

Tests communication, ownership, and stakeholder management when translating technical complexity into actionable business understanding.

Problem SolvingData Structurestechnical fundamentalsOptum 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.