Sr. Analyst, Health Plan Analytics

Hopscotch Primary Care; Chicago (IL); On-site; USD 110,000 - 120,000; Full time

Benefits offered by this job

Paid holidays + PTO

Medical, dental, and vision insurance

Disability insurance

Life insurance

401k with 4% company match

Health Savings Account contributions

Job summary

Hopscotch Primary Care seeks a Sr. Analyst, Health Plan Analytics to turn claims and clinical data into actionable insights supporting value-based care performance.

You will mature the data foundation, maintain the claims model, and build reporting infrastructure for financial close, clinical review, and performance management. You will be strong at building infrastructure, interrogating outputs, and delivering transparent, data-driven analyses for stakeholders across Clinical, Operations, and

Qualifications

• Bachelor's degree in a quantitative field and 3+ years in healthcare analytics.
• Strong SQL, Power BI and Excel proficiency with healthcare data.
• Experience with claims data, multi-source data integration, and risk adjustment concepts.

Responsibilities

• Build and maintain Hopscotch's cost categorization capability, including customizations and mappings.
• Maintain governance and documentation for payer data and cost categorization capabilities.
• Develop and sustain the medical economics reporting suite (SQL, Power BI, Excel) and support IBNR estimation, cohort forecasting, and paid-risk pacing.
• Review monthly outputs to surface cost drivers and trends, distinguishing real movement from incomplete data and noise.
• Analyze medical cost trends across unit cost, utilization, mix; enrich claims with EHR, eligibility, provider, and risk data to explain population trends.
• Collaborate with medical economics and finance leadership to deliver high-impact analyses including pro forma and ROI for cost initiatives.
• Partner with Clinical, Operations, and Finance to translate business questions into analyses and ensure results feed management reporting.

Skills

SQL

Power BI

Excel

Claims data

Data modeling

Risk adjustment

Education

Bachelor's in Economics, Finance, Statistics, Mathematics, Health Informatics, Actuarial Science, or related field

Tools

Palantir Foundry

Job description

About Hopscotch Primary Care

At Hopscotch Primary Care, we believe great healthcare should be accessible to all people across all communities. Today, almost 20% of Americans live in a rural community, yet only 11% of physicians practice in those same communities. We are on a mission to transform healthcare in rural America. We provide high-quality primary care tailored to meet the needs of our patients through our robust care model and comprehensive care team, delivering care in our clinics, and across settings, and wrapping resources around the patients who need them most.

About Hopscotch Primary Care

At Hopscotch Primary Care, we believe great healthcare should be accessible to all people across all communities. Today, almost 20% of Americans live in a rural community, yet only 11% of physicians practice in those same communities. We are on a mission to transform healthcare in rural America. We provide high-quality primary care tailored to meet the needs of our patients through our robust care model and comprehensive care team, delivering care in our clinics, and across settings, and wrapping resources around the patients who need them most.

Our patients and the care teams who serve them sit at the center of everything we do at Hopscotch. Hopscotch Primary Care takes a team approach to serve patient needs and provide the best care possible. Our goal is to provide the care each of us would want for ourselves or for our family members, in the right setting, and at the right time.

Today, we are serving thousands of patients in our value-based care model and the number is growing every day. If you want to bring your experience, skill and passion to make a lasting impact in healthcare, we'd like to meet you.

Role Description

The Sr. Analyst, Health Plan Analytics operates at the intersection of FP&A, analytics, and population health, turning claims and clinical data into the insight that drives Hopscotch's value-based care performance. Working on top of our engineering governed data foundation, this person will mature and maintain the standard claims model and the reporting infrastructure that underpins financial close, clinical review, and performance management. We're looking for someone equally strong at building the infrastructure and interrogating what comes out of it - technically excellent, with the judgement to know when a number is wrong and why.

Key Responsibilities

• Support the in-house build of Hopscotch's cost categorization capability – including customizations, updates for new code and mappings, and change management.
• Own the ongoing maintenance, enhancements, governance, change control, and documentation for Hopscotch's 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 the impact of incomplete claims and statistical noise.
• Analyze medical cost trend across factors such as unit cost, utilization, mix; and enrich claims with EHR, eligibility, provider, and risk adjustment data to explain population-level trends and financial performance.
• Work with medical economics and finance leadership to identify and complete high-impact analyses, including pro forma and ROI for medical cost initiatives.
• Partner across Clinical, Operations, and Finance to translate business questions into analyses, ensure results flow accurately into management reporting, and build repeatable analytic processes that scale across programs.

About You

• You build and you interrogate – you can stand up a clean dataset and tell when the output doesn't pass the smell test or is logically inconsistent.
• You exercise critical thinking and understand the conceptual framework and database relationships that underly healthcare data.
• You are comfortable with ambiguous problems and immature data and take pride in acknowledging what's unknown while taking steps to fill the gaps.
• You form a point of view; you don't just produce the number, you explain what's driving it and why it matters.
• You document as you build, so your definitions are transparent and others can rely on them.
• You're a self-starter with an ownership mindset, thrive in a fast-paced environment, and care about transforming rural healthcare.

Qualifications

• 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, identifying improvement opportunities while still generating value from nascent datasets.
• Experience presenting and communicating data-driven insights to functional leaders.

Preferred / Bonus Qualifications

• Direct value-based care / medical-economics analytics experience, and familiarity with key considerations and leading methodologies for claims cost categorization.
• Experience with Palantir Foundry or a comparable enterprise data platform.
• Comfort using AI-assisted tooling to accelerate build and analysis.
• Statistical methods (regression, difference-in-differences, propensity score matching).
• Experience leading technical/analytical projects with combined teams of functional and technical stakeholders.

In accordance with the Illinois Pay Transparency Act, we're providing the full salary range for this position. Actual compensation will be determined based on location, relevant experience and qualifications. Most offers will fall within a portion of the listed range. This position has a salary range of $110,000 – $120,000 annually, based on location, relevant experience and qualifications. In addition to base salary, we offer a comprehensive benefits package that includes:

• Paid holidays + PTO
• Company sponsored medical, dental, and vision insurance for you + your family
• FREE short-term and long-term disability insurance
• FREE $100k life insurance policy
• 401k plan with 4% company match + no vesting period
• $720 - $1,000 added to employee Health Savings Account annually for eligible health plans
• And more!

At Hopscotch Primary Care, we embrace diversity, invest in a culture of inclusion and positivity and encourage all to apply to join our team. You will receive consideration for employment without regard to race, color, religion, gender, gender identity or expression, sexual orientation, national origin, genetics, disability, age, or veteran status.