Sr. Analyst, Health Plan Analytics
New
H
Hopscotch Primary CareHealthcare
RemoteFull-TimeSenior
Salary$110,000 – $120,000 annually
Apply NowOpens the employer's application page
Job Details
- Experience
- 3+ years
- Required Skills
- SQLMicrosoft Power BIMicrosoft ExcelData modelingEHR
Requirements
- Bachelor's in Economics, Finance, Statistics, Mathematics, Health Informatics, Actuarial Science, or a related quantitative field.
- 3+ years of experience in healthcare analytics or medical economics (payer, provider, health system, ACO, or VBC).
- High proficiency in SQL, Power BI, and Excel.
- Hands-on experience with healthcare claims data, and combining data sources (claims, eligibility, EHR, risk adjustment).
- Familiarity with healthcare financial and utilization concepts (e.g., PMPM, MLR, utilization per 1,000, trend, risk adjustment).
- Experience with maturing data models and identifying improvement opportunities.
- Experience presenting and communicating data-driven insights to functional leaders.
Responsibilities
- Support the in-house build of Hopscotch’s cost categorization capability.
- Own the ongoing maintenance, enhancements, governance, change control, and documentation for payer data and cost categorization capabilities.
- Build and maintain the medical economics reporting suite (e.g., SQL, PBI, Excel) and support IBNR estimation, cohort forecasting, and paid-risk pacing.
- Review monthly outputs to surface cost drivers and emerging trends, distinguishing real movement from statistical noise.
- Analyze medical cost trend across factors such as unit cost, utilization, and mix.
- Enrich claims with EHR, eligibility, provider, and risk adjustment data to explain population-level trends and financial performance.
- Partner across Clinical, Operations, and Finance to translate business questions into analyses and build repeatable analytic processes.
View Full Description & ApplyYou'll be redirected to the employer's site