Business Connectivity Consultant

The Business Connectivity Consultant will serve as a strategic analytics partner for Medica's Joint Venture partnership with SSM Health, supporting both medical and pharmacy analytics. The Business Connectivity Consultant will be an integral partner to the Joint Venture business and market leaders and will be asked to routinely interface with internal and external strategic partners. This role is responsible for leading the development and delivery of analytics across all lines of business - including reporting packages (trend, insights, and others as requested), conducting benchmarking and ad hoc analyses, and presenting insights to executive stakeholders. The analyst will act as a subject matter expert on analytics and guide internal teams with data-driven insights that influence client strategies, affordability initiatives and operational performance. Perform other duties as assigned.

Key Accountabilities:

Strategic Analytics Leadership

• Act as a subject matter expert on healthcare analytics, providing advanced guidance on the interpretation and application of complex medical and pharmacy data.
• Lead the development of analytic frameworks that support client strategies, affordability initiatives and tracking, and operational performance improvement.
• Collaborate with internal stakeholders to translate business questions into analytic approaches, ensuring insights are aligned with SSM's strategic goals.
• Proactively identify emerging trends and opportunities through data exploration and advise leadership on implications and recommended actions.
• Serve as a key liaison between analytics and business teams, ensuring that insights are actionable, relevant, and integrated into decision-making processes.

Trend Reporting and Insights

• Lead the design, enhancement, and delivery of SSM's trend reporting package across medical and pharmacy data.
• Develop and maintain SSM-specific reporting solutions tailored to internal stakeholder needs and strategic goals.
• Analyze cost, utilization, and quality trends to identify key drivers and emerging patterns.
• Translate complex data into actionable insights that support strategic decision-making.

Benchmarking and Comparative Analysis

• Conduct internal and external benchmarking to contextualize SSM performance.
• Apply industry best practices to identify opportunities for improvement and innovation.

Executive-Level Communication

• Present findings to executive leaders, tailoring insights to strategic priorities.
• Construct compelling data narratives that connect trends to business outcomes.

Required Qualifications:

• Bachelor's degree or equivalent experience in related field
• 7 years of work experience beyond degree

Skills and Abilities:

• Health plan experience
• Strong proficiency in SQL
• Deep understanding of healthcare data, including medical and pharmacy claims
• Ability to translate complex data into clear, actionable insights
• Skilled in trend analysis, benchmarking, and ad hoc reporting
• Experience presenting to executive stakeholders
• Strong collaboration and communication skills across technical and non-technical teams
• Familiarity with data visualization tools (e.g., Tableau, Power BI) preferred

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 and Minnetonka, MN

The full salary range for this position is $100,200 - $171,700. 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.