Healthcare Analyst IV

About the role

Medica is a nonprofit health plan with more than a million members that serves communities in Minnesota, Nebraska, Wisconsin, Missouri, and beyond. We deliver personalized health care experiences and partner closely with providers to ensure members are genuinely cared for. We're a team that owns our work with accountability, makes data-driven decisions, embraces continuous learning, and celebrates collaboration — because success is a team sport. It's our mission to be there in the moments that matter most for our members and employees. Join us in creating a community of connected care, where coordinated, quality service is the norm and every member feels valued.

Medica’s Lead Analyst, Healthcare Analytics provides reporting and analytical support to strategic employer group partners. This role serves as a subject matter expert in healthcare claims, cost and utilization analytics, population health, and employer reporting. The Lead Healthcare Analyst combines deep technical expertise with strong business acumen to deliver actionable insights that inform decision-making and drive value for employer group clients and internal stakeholders. This position requires advanced analytical skills, extensive experience working with medical and pharmacy claims data, and the ability to communicate complex findings effectively to both technical and non-technical audiences.

Responsibilities

• Perform deep-dive analyses to support employer group reporting, client consultations, and business initiatives.
• Design, develop, and optimize advanced analytic solutions using SQL, Snowflake, SAS, and other healthcare analytics tools.
• Build and maintain complex reporting datasets, automated processes, dashboards, and data visualization solutions.
• Serve as a technical resource for the team by providing guidance on data architecture, analytical methodologies, and best practices.
• Partner with business stakeholders to translate reporting and analytical needs into scalable data solutions and actionable insights.
• Ensure data integrity, accuracy, and consistency across analytical deliverables.
• Identify opportunities to improve reporting efficiency and scalability through automation and process enhancements.
• Mentor analysts and contribute to the development of analytical capabilities within the team.

Requirements

• Bachelor's degree in healthcare analytics, mathematics, statistics, or analytic related degree
• 7+ years of healthcare analytics, business intelligence, or healthcare reporting experience.
• 5+ years’ experience using SQL, SAS or Snowflake programming experience.
• Experience working with healthcare claims, eligibility, provider, and utilization data.
• Experience developing dashboards and visualizations using tools such as Power BI, Tableau, or QlikSense.
• Demonstrated ability to design, evaluate, and interpret complex data sets, with strong analytical and problem-solving skills.
• Excellent written and verbal communication skills, capable of conveying complex information clearly and concisely to diverse audiences.
• Proven ability to work independently while effectively collaborating across cross-functional teams and business partners.
• Experience managing multiple priorities and delivering high-quality work in a fast-paced environment.

Preferred qualifications

• Experience with healthcare grouping and risk adjustment methodologies such as John Hopkins ACG Grouper, Milliman HCG Grouper, Symmetry ETG Grouper, or similar models.
• Demonstrated ability to present analytical findings and recommendations to both technical and non-technical audiences.
• Prior experience mentoring analysts, leading projects, or serving as a technical lead.
• Strong intellectual curiosity with a passion for identifying root causes, uncovering insights, and solving complex business problems.
• Ability to thrive in a collaborative, fast-paced, and evolving environment.

Schedule

This position is an Office role, which requires an employee to work onsite, on average, 3 days per week. We are open to candidates located near one of the following office locations: Minnetonka, MN, Madison, WI.

Pay

The full salary grade for this position is $102,100 - $175,100