Technical Healthcare Analyst - SQL (financial risk arrangements)

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 PN Healthcare Analyst II will evaluate and assess medical data to identify trends and opportunities. Determine requirements, create standards and/or define metrics to ensure complete and accurate reporting. Provide insight and recommendations using quantitative analysis and/or statistical analysis coupled with explanatory and predictive modeling to drive focused decision making. Performs other duties as assigned.

Key Accountabilities

• Evaluate and assess membership and claim data to identify trends and variance opportunities that will lower cost, improve member outcomes and improve overall quality of care.
• Report findings and recommend areas to focus on to internal customers including physician and HR leadership.
• Manage multiple projects at one time with different stakeholders.
• Strategic analytic thought leadership to account and physician service departments as well as externally to client partners.
• Work independently and within a team to complete objectives.
• Independently investigate issues that may arise on multiple tasks or projects with limited involvement from others.
• Create customized reports and dashboards to visualize key metrics, including benchmarking data against industry standards, and communicate actionable insights to stakeholders at various organizational levels.
• Collaborate with business teams to translate data insights into actionable strategies that improve patient care and enhance financial performance.
• Stay updated on emerging data technologies and analytics tools to enhance analytical capabilities.
• Dig into varying requests on an ad hoc basis.

Required Qualifications

• Bachelor's Degree or equivalent experience in a related field
• 3 years of work experience beyond degree
• SQL and Excel proficiency

Preferred Qualifications

• Proficient use of SAS
• PowerBI, Snowflake a plus
• Demonstrated ability to present financial and healthcare data to business and finance leadership
• Healthcare industry experience

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, Omaha, NE, or St. Louis, MO.

The full salary grade for this position is $62,700 - $107,500. While the full salary grade is provided, the typical hiring salary range for this role is expected to be between $62,700 - $89,600. 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.