Top 37
Prep plan
Updated weekly · Last refresh Oct 17

Oscar Insurance Business Analyst Interview Questions

The questions to prepare for a Oscar Insurance Business Analyst interview. Questions from real interview reports rank first. Updated daily.

37questions
~5htotal time
Track your progressSign up free to work through all 37 questions and resume where you left off.
Start practicing free →
1
StrategyStart here. 4 questions · ~33 min
Tell Me About YourselfEasy

Craft a concise self-introduction that highlights fit, communication style, and relevance for an Account Executive role.

brand cultureBusiness AcumenCompetitive AnalysisOscar Insurance
Eliminating the Penny CaseHard

Evaluates your structured reasoning and ability to build an argument under ambiguity.

critical thinkingcase studyOscar Insurance
More Strategy questions with a free account
2
Execution3 questions · ~25 min
Process Improvement Under ConstraintsMedium

Evaluates your approach to diagnosing and improving a business process at Oscar Health.

process improvementProblem SolvingOscar Insurance
Managing Project Task DelaysMedium

Assesses accountability, planning, and follow-through in project execution.

time managementProject ManagementOscar Insurance
More Execution questions with a free account

Sign up to see every question

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

Get my prep plan
3
SQL & Data Manipulation7 questions + 2 drills · ~78 min
SQL With CTEs and JoinsHard

Tests your ability to write and reason about advanced SQL for analysis work.

sqlOscar Insurance
Live SQL Case InterviewHard

Evaluates your ability to think clearly and write correct SQL under real-time pressure.

sqlOscar Insurance
Top Spend Categories by RegionMedium
Practice

Rank the three highest-spending medical claim categories within each region using PostgreSQL aggregation and window functions.

Window FunctionsRankingdatabase queryingOscar Insurance
Optimizing Slow SQL QueriesHard
Practice
Practice drill

Optimize a PostgreSQL transaction query that filters, aggregates, ranks, and returns top merchants efficiently on large tables.

Performance Tuningdatabase optimizationlarge datasetsSprinter HealthSentiLinkAutodesk
Cohort Analysis SQLHard
Practice
Recently asked
Practice drill

Calculate monthly signup cohort retention for Initio Capital users using CTEs, joins, date functions, and distinct counts.

sqlCohort AnalysisIInitio CapitalOscar Insurance
More SQL & Data Manipulation questions with a free account
4
Behavioral & Leadership22 questions · ~183 min
More Behavioral & Leadership questions with a free account
5
More topics1 question · ~8 min
Metrics for Virtual Primary CareMedium

Tests KPI selection and analytical structure for product financial viability in healthcare.

financial datakpi hierarchypilot metricsOscar Insurance
The finish line: interview-readyComplete all 37 questions plus 2 hands-on drills to finish this plan.