About this role
Sr. Health Plan Operations Analyst
Remote, United States
Strategic Payer Partnerships – Payer Solutions / Remote
Describe a project where you analyzed patient-level from health plans or payers (e.g., Aetna, Humana, BCBS). How did you query and structure this data to drive operational or clinical outcomes? What data challenges did you solve? If applicable, highlight any work with care gaps or medication adherence data.
Describe a complex SQL query you recently built or modified in Snowflake (or a similar data warehouse). What specific problem were you trying to solve and what SQL concepts did you use?
Walk us through a time you identified a critical discrepancy or data error in a large dataset (e.g., loaded vs. expected patient numbers across data streams). What steps did you take to triage and fix the issue?