Dataford
Top 50
Company roadmap
Updated weekly · Last refresh Aug 30

Oak St. Health Interview Questions

The questions to prepare for Oak St. Health interviews, across all roles. Questions from real interview reports rank first. Updated weekly.

50questions
~7htotal time
Track your progressSign up free to work through all 50 questions and resume where you left off.
Start practicing free →
1
PipelinesStart here. 8 questions · ~65 min
Data Quality and Schema EvolutionMedium

Approach for handling schema changes and data quality checks in a high-volume data lake pipeline.

schema evolutionData ModelingQualityOak St. Health
More Pipelines questions with a free account
2
SQL & Data Manipulation6 questions + 3 drills · ~79 min
Optimize Slow PostgreSQL Reporting QueriesEasy

Explain how to diagnose and optimize a slow PostgreSQL query using execution plans, indexing, and query rewrites.

JoinsData WranglingAggregationsOak St. Health
Top Customers by Net SalesMedium
Practice
Practice drill

Compute top 10 customers by net sales using joins and aggregations, ordering by revenue with deterministic tie-breaking.

SubqueriesJoinsData WranglingGain DigitalTCSZest AI
Monthly Campaign Performance SummaryEasy
Practice
Practice drill

Aggregate January 2024 campaign data by channel using GROUP BY, filtering, and ordering by total clicks.

JoinsData WranglingAggregationsDNVEversanaDiscord
Employees Per Department QueryEasy
Practice
Practice drill

Use a LEFT JOIN and GROUP BY to count employees in every Auto-Owners Insurance department, including departments with zero employees.

JoinsData WranglingAggregationsAuto-Owners InsuranceSynchrony Financial
More SQL & Data Manipulation questions with a free account
3
Coding8 questions · ~65 min
Flatten Nested JSON to ParquetMedium

Tests your PySpark skills for schema handling, transformation, and efficient Parquet partitioning.

parquetjson parsingpythonOak St. Health
More Coding questions with a free account
4
Behavioral & Leadership19 questions · ~155 min
More Behavioral & Leadership questions with a free account
5
More topics9 questions · ~73 min
Reduce Patient Wait TimesMedium

Analyze patient flow to find bottlenecks and improve throughput while protecting care quality and operational stability.

process improvementthroughputbottlenecksOak St. Health
Guiding Product Design FeedbackMedium

Assesses product sense and the ability to translate user and business context into actionable design direction.

feedbackdesignOak St. Health
Measuring Outreach CampaignMedium

Tests your ability to translate outreach goals into measurable KPIs for patient engagement and outcomes.

RetentionKPIEngagement MetricsOak St. Health
Weekend and Field AvailabilityMedium

Evaluates your readiness for the field-based recruiting and scheduling needs of the role.

availabilityOak St. Health
Quantitative Analysis ExperienceMedium

Evaluates your ability to use quantitative methods to inform business decisions.

Oak St. Health
More 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
The finish line: interview-readyComplete all 50 questions plus 3 hands-on drills to finish this plan.