Employer Group Consulting Analyst

Founded in 1934, Medical Mutual is the oldest and one of the largest health insurance

companies based in Ohio. We provide peace of mind to more than 1.2 million members

through our high-quality health, life, disability, dental, vision and indemnity plans. We offer

fully insured and self-funded group coverage, including stop loss, as well as Medicare

Advantage, Medicare Supplement, and individual plans.

Sr. Employer Group Consulting Analyst

Job Summary:

• Design and execute analyses and reports for clients and their representatives that identify actionable opportunities to improve appropriate use of care, lower total costs of care, and increase receipt of high quality, evidence-based care. Primary responsibilities include, but are not limited to:
• Examining and identifying distributions and drivers of population health, and health care utilization, costs and quality both within a population and across similar populations
• Collaborating with Sales and Account Management, and clients and their representatives, to design, create and deliver analytic results that drive strategic decision making and demonstrate the value provided by products and services purchased
• Synthesizing and communicating, in writing and verbally to technical and non-technical audiences, analytic results and conclusions including the business impacts of various courses of action
• Tracking and prioritizing projects through coordination and negotiation with team and division leadership, Sales and Account Management staff, and clients and their representatives
• Developing and maintaining relationships with key stakeholders
• Contributing to the development of new analytic deliverables and enhancements to existing analyses and reports
• Assuring all analyses and reports are reliable, valid and credible by performing quality checks of one's own work and serving as a reviewer of peers' deliverables
• Formally coaching and mentoring junior team members
• Developing and leading initiatives to address opportunities to improve efficiency and/or effectiveness of deliverables
• Serving as a subject matter expert and trusted advisor to internal and external stakeholders
  
  

Responsibilities:

• Analyzes data, creates reports, and presents results to clients and their representatives to inform strategic decision making. Directs stakeholders to appropriate analyses and value-added information beyond what is requested. Assesses population health status and illness burden, use of care, plan spend, and receipt of high-quality care consistent with evidence-based medicine guidelines. Ensures analytic results are insightful and actionable.
• Collaborates with team and department leadership and internal stakeholders to gather, document, and execute analytic and reporting requirements. Explains technical details, relevance, and implications of analytic results to diverse audiences. Incorporates feedback to improve content and format of deliverables. Leads projects and may be dedicated to specific customers or customer segments. Develops relationships with clients and representatives.
• Manages multiple projects with competing deadlines. Works with team and department leadership to prioritize deliverables. Coordinates with teammates to ensure deliverables are created efficiently. Tracks work and provide regular progress updates to team and department leadership, and internal and external stakeholders.
• Contributes to development and enhancement of analytic deliverables. Actively participates in department and team meetings. Completes trainings to maintain and enhance knowledge, skills and abilities.
• Performs other duties as assigned.
  
  

Qualifications:

Education and Experience:

• Bachelor’s degree in epidemiology, biostatistics, economics, public health, healthcare administration, nursing, or a related quantitative field.
• Minimum of five (5) years of experience conducting analyses and delivering analytic results in a client-facing role with a health care insurance, consulting or delivery organization.
• Master’s degree preferred.
  
  

Professional Certification(s):

• NA
  
  

Technical Skills And Knowledge:

• Advanced experience and expertise in data extraction and analytical programming languages (SAS, SQL, Databricks, Python, R), and data visualization tools (PowerBI, Tableau, Looker), and the ability to perform queries and retrieve data from multilple tables and/or sources.
• Track record of success with analyzing clinical, claims, pharmacy, program and other administrative data.
• Intermediate to advanced knowledge of health insurance products and industry, including trends and drivers of population health status, utilization, costs, and quality.
• Strong conceptual and hands-on knowledge of how data are captured, structured, and stored.
• Advanced to expert knowledge of health plan operations, data sources, and data structures, including trends and drivers of quality, utilization, and costs. Comprehensive understanding of claim submissions and payment processes, reporting structures, database management, and financial concepts.
• Demonstrated long-term success with communicating in writing, verbally and with delivering presentations.
• Project management experience and expertise, a well-developed business sense, the ability to perform in a fast-paced environment, and comfort interacting with internal and external senior leaders are critical to success in the role.
• Proven ability to assist with informally leading the work of others, influencing internal and external stakeholders, negotiating deliverables, and coaching teammates as a peer.
• Work with minimal direction, initiate projects, and demonstrate significant flexibility to coordinate complex activities that are often subject to rapid or extensive changes.
• Ability to lead conceptualization, development and execution of new deliverables and enhancements to existing deliverables.
  
  

Lead Employer Group Consulting Analyst

Job Summary:

Lead the design and execution of analyses and reports for clients and their representatives that identify actionable opportunities to improve appropriate use of care, lower total costs of care, and increase receipt of high quality, evidence-based care. Examining and identifying distributions and drivers of population health, and health care utilization, costs and quality both within a population and across similar populations. Serving as a collaborative and consultative partner with Sales and Account Management, and clients and their representatives, to design, create and deliver analytic results that drive strategic decision making and demonstrate the value provided by products and services purchased. Synthesizing and communicating, in writing and verbally to technical and non-technical audiences, analytic results and conclusions including the business impacts of various courses of action. Tracking and prioritizing projects through coordination and negotiation with team and division leadership, Sales and Account Management staff, and clients and their representatives. Developing and maintaining relationships with key stakeholders. Contributing to the development of new analytic deliverables and enhancements to existing analyses and reports. Assuring all analyses and reports are reliable, valid and credible by performing quality checks of one's own work and by leading peer review of others' deliverables. Formally coaching and mentoring junior team members. Conceptualizing, developing and leading initiatives to address opportunities to improve efficiency and/or effectiveness of deliverables.

Responsibilities:

• Analyzes data, creates reports, and presents results to clients and their representatives to inform strategic decision making. Anticipates needs of clients and internal stakeholders and directs stakeholders to appropriate analyses and value-added information beyond what is requested. Assesses population health status and illness burden, use of care, plan spend, and receipt of high-quality care consistent with evidence-based medicine guidelines. Ensures analytic results are insightful and actionable. Brings expertise and experience to bear.
• Collaborates with team and department leadership and internal stakeholders to gather, document and execute analytic and reporting requirements. Explains technical details, relevance and implications of analytic results to diverse audiences. Incorporates feedback to improve content and format of deliverables. Leads projects and is dedicated to specific customers and/or customer segments. Develops relationships with clients and representatives.
• Manages multiple projects with competing deadlines. Works with team and department leadership to prioritize deliverables. Coordinates with teammates to ensure deliverables are created efficiently. Tracks work and provides regular progress updates to team and department leadership, and internal and external stakeholders. Assists junior teammates with developing project management skills.
• Proposes and leads development and enhancement of analytic deliverables. Leads and actively participates in department and team meetings. Completes and leads trainings to maintain and enhance knowledge, skills and abilities.
• Performs other duties as assigned.
  
  

Education And Experience:

• Bachelor’s Degree in epidemiology, biostatistics, economics, public health, healthcare administration, nursing, or a related quantitative field.
• Seven (7) or more years of experience conducting analyses and delivering analytic results in a client-facing role with a health care insurance, consulting or delivery organization.
• Master’s degree preferred.
  
  

Technical Skills And Knowledge:

• Advanced experience and expertise in data extraction and analytical programming languages (SAS, SQL, Databricks, Python, R), and data visualization tools (PowerBI, Tableau, Looker), and the ability to perform queries and retrieve data from multiple tables and/or sources.
• Significant track record of success with analyzing clinical, claims, pharmacy, program and other administrative data.
• Advanced knowledge of health insurance products and industry, including trends and drivers of population health status, utilization, costs and quality, and application of that knowledge to drive strategic decision making.
• Strong conceptual and hands-on knowledge of how data are captured, structured, and stored.
• Advanced to expert knowledge of health plan operations, data sources, and data structures, including trends and drivers of quality, utilization, and costs. Comprehensive understanding of claim submissions and payment processes, reporting structures, database management, and financial concepts.
• Demonstrated long-term success with communicating in writing, verbally and with delivering presentations.
• Project management experience and expertise, a well-developed business sense, the ability to perform in a fast-paced environment, and comfort interacting with internal and external senior leaders are critical to success in the role.
• Proven ability to assist with informally leading the work of others, influencing internal and external stakeholders, negotiating deliverables, and coaching teammates as a peer.
• Work with minimal direction, initiate projects, and demonstrate significant flexibility to coordinate complex activities that are often subject to rapid or extensive changes.
• Ability to lead conceptualization, development and execution of new deliverables and enhancements to existing deliverables.