Lead Healthcare Analyst, Trend Analytics

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.

The Lead Healthcare Analyst will serve as a strategic analytics partner within Medica's Trend Analytics team, supporting Medica's Joint Venture with SSM Health across medical and pharmacy domains. This highly visible role is responsible for delivering end-to-end analytics-from data extraction and analysis to insight generation and executive-level storytelling. The Lead Healthcare Analyst will work closely with internal and external cross-functional teams to develop and present actionable insights that drive health plan performance.

Key Accountabilities

• Lead end-to-end analytics efforts: extract and analyze membership and claims data to uncover trends, variance opportunities, and performance drivers that impact health plan performance.
• Create and maintain the health system-specific trend reporting package, including cost, utilization, and other key metrics.
• Develop customized dashboards and reports using SQL and visualization tools (QlikSense, Power BI) to benchmark performance and communicate insights across organizational levels.
• Translate complex healthcare data into compelling, audience-specific stories, shared with executive leaders, that connect metrics to strategic business outcomes.
• Provide strategic analytic thought leadership to internal stakeholders and external client partners.
• Manage multiple projects simultaneously, navigating diverse stakeholder needs and shifting priorities.
• Work independently and collaboratively to meet objectives, proactively investigating issues and resolving data challenges.
• Respond to ad hoc requests, connecting trend metrics to business impact.
• Stay current on emerging data technologies and analytics tools to continuously enhance analytical capabilities.

Required Qualifications

• Bachelor's degree in healthcare analytics, mathematics, statistics, or analytic related degree, or equivalent working experience
• 7 years of related work experience beyond degree in healthcare analytics or data roles within the healthcare or insurance industries with a focus on employer group or client stakeholders

Preferred Qualifications

• 3+ years' experience using SQL, SAS or Snowflake programming experience.
• Strong proficiently in data analysis tools and visualization techniques/software (e.g. QlikSense, Power BI, Tableau).
• Comfortable presenting to executive level stakeholders.
• Proficiency in MS office specifically MS Excel.
• 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.
• Experience working both independently and collaboratively in cross functional teams, engaging with individuals from diverse professional backgrounds.

Skills and Abilities

• John Hopkins ACG Grouper, Milliman HCG Grouper, Symmetry ETG Grouper
• Experience working with claims data
• Demonstrated capability to present key findings of an analysis effectively to a non-technical audience both written and verbal
• Demonstrated problem solving skills
• An internal drive to understand root cause and an inherent curiosity to dig into data
• Ability to function in a fast-paced, dynamic culture is important for success in this role

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: Madison, WI, Minnetonka, MN, St. Louis MO, and Omaha, NE.

The full salary grade for this position is $100,200 - $171,700. While the full salary grade is provided, the typical hiring salary range for this role is expected to be between $100,200 - $135,945. Annual salary range placement will depend on a variety of factors including, but not limited to, education, work experience, applicable certifications and/or licensure, the position's scope and responsibility, internal pay equity and external market salary data. In addition to compensation, Medica offers a generous total rewards package that includes competitive medical, dental, vision, PTO, Holidays, paid volunteer time off, 401K contributions, caregiver services and many other benefits to support our employees.

The compensation and benefits information is provided as of the date of this posting. Medica's compensation and benefits are subject to change at any time, with or without notice, subject to applicable law.

We are an Equal Opportunity employer, where all qualified candidates receive consideration for employment indiscriminate of race, religion, ethnicity, national origin, citizenship, gender, gender identity, sexual orientation, age, veteran status, disability, genetic information, or any other protected characteristic