Flatiron Health Business Analyst Interview Questions
The questions to prepare for a Flatiron Health Business Analyst interview. Questions from real interview reports rank first. Updated weekly.
Explain how to profile, quantify, and handle missing values in joined clinical datasets using SQL.
Flatiron HealthTests SQL aggregation, windowing/partitioning, and cohort segmentation by age group.
Flatiron HealthTests data modeling for longitudinal oncology treatment timelines with overlapping events.
Flatiron HealthRank the top 3 completed rides per vehicle per day using joins, a CTE, and ROW_NUMBER.
WaymoCompute per-vehicle daily autonomous vs manual seconds from state-change logs using LEAD and conditional aggregation.
Compute top 10 customers by net sales using joins and aggregations, ordering by revenue with deterministic tie-breaking.
Gain Digital
TCS
Zest AITests preparation, composure under pressure, and learning agility for live SQL and Python coding assessments.
Flatiron HealthTests your product sense and ability to model entities and relationships for analytics.
Flatiron HealthAssesses your statistical reasoning and how you apply it to real data problems.
Flatiron HealthTests your metric definition and analysis approach for comparing treatment outcomes.
Flatiron HealthAssesses your ability to define metrics and translate them into a data query.
Flatiron HealthSign up to see every question
Create a free account to unlock this list and practice real interview questions.