Lead Healthcare Analyst

Description 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. Key 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. Required Qualifications 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 Skills and Abilities 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. 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. The full salary grade for this position is $102,100 - $175,100 . While the full salary grade is provided, the typical hiring salary range for this role is expected to be between $102,100 - $138,605 . 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. Eligibility to work in the US: Medica does not offer work visa sponsorship for this role. All candidates must be legally authorized to work in the United States at the time of application. Employment is contingent on verification of identity and eligibility to work in the United States. 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. Equal Opportunity Employer/Protected Veterans/Individuals with Disabilities This employer is required to notify all applicants of their rights pursuant to federal employment laws. For further information, please review the Know Your Rights notice from the Department of Labor.