Top 16
Prep plan
Updated weekly · Last refresh Oct 17

Lyra Health Data Analyst Interview Questions

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

16questions
~3htotal time
Track your progressSign up free to work through all 16 questions and resume where you left off.
Start practicing free →
1
SQL & Data ManipulationStart here. 8 questions + 1 drill · ~86 min
WHERE vs HAVING in SQLMedium

Tests understanding of SQL filtering semantics for rows versus grouped results.

sqlLyra Health
Week-over-Week Clinical Change QueryMedium
Practice

Calculate each member's week-over-week clinical improvement change while handling missing prior weeks and NULL scores.

Lag/LeadDate Functionsnull handlingLyra Health
Tableau LOD for Different GranularityMedium

Tests Tableau proficiency with LOD expressions and understanding of aggregation granularity.

MetricsData ModelingLyra Health
Star Schema for Member OutcomesHard

Tests data modeling skills for building an analytics-ready star schema across enrollment, sessions, and outcomes.

fact tablesstar schemaData ModelingLyra Health
SQL for Provider Onboarding PerformanceMedium
Practice
Practice drill

Calculate weekly Lyra provider onboarding metrics and compare counts and duration averages with the prior week.

Window FunctionsLag/LeadDate FunctionsLyra Health
More SQL & Data Manipulation questions with a free account
2
Behavioral & Leadership5 questions · ~48 min
Owning a Submitted Analysis ErrorEasy

Tests ownership, self-awareness, and communication when a candidate finds a mistake in their own completed analysis.

failureOwnershipaccountabilityLyra Health
More Behavioral & Leadership questions with a free account
3
More topics3 questions · ~29 min
Investigate Retention Drop-OffsMedium

Tests causal investigation and metrics selection for diagnosing retention changes in therapy journeys.

RetentionDiagnosisCohort AnalysisLyra Health
Analytical Framework for New ProgramHard

Tests end-to-end analytics design for adoption, outcomes, and ROI for Lyra Health enterprise programs.

MetricsUser NeedsProduct VisionLyra Health
Provider Shortage Impact on EngagementMedium

Tests analytical design for linking geographic provider capacity to engagement outcomes.

User SegmentsDiagnosisEngagement MetricsLyra Health

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 16 questions plus 1 hands-on drill to finish this plan.