Lead Decision Support Consultant

3M HEALTHCARE; Pennsylvania; Hybrid; USD 58,038 - 92,285; Full time

Job summary

3M HEALTHCARE is seeking a data analytics professional to support financial, operational, and clinical performance through analytics-ready datasets and insightful reporting. The role partners with stakeholders in the Decision Support team and Finance to deliver Tableau dashboards and data sources, guiding junior analysts through mentorship and coaching.

The ideal candidate will have strong SQL, data manipulation skills, and a proven ability to translate business needs into technical

Qualifications

• Bachelor’s degree in Business Administration, Computer Science, Statistics, or related field or 6 years of relevant experience.
• 5 years of Decision Support and Data Analysis experience.
• Proficient in Microsoft Office (Excel, PowerPoint, etc.).
• Advanced SQL skill.
• Ability to extract, transform, or manipulate large quantities of data to support business needs.
• Ability to design and deliver reporting or other data visualizations that provide valuable, actionable, intuitive, and timely insights.
• Ability to translate vague or ambiguous business needs into specific technical requirements that meet the customer’s needs.
• Self-starter who takes initiative and drives progress on major projects without being asked or with minimal supervision.

Responsibilities

• Responds to ad-hoc requests for data and reporting from leadership or other partners.
• Gathers requirements and leads development of new Tableau dashboards that meet customer needs.
• Gathers requirements and leads development of new data sources, structures, and processes to support Decision Support and Finance.
• Leverages automation tools to improve reliability and reduce manual intervention.
• Engages IT and other partners to advocate for new or improved technologies and processes.
• Serves as an internal consultant to the Finance organization by understanding business needs and recommending solutions.
• Other duties as assigned or requested.

Skills

SQL

Excel

Tableau

Data visualization

Data analysis

Requirements gathering

Education

Bachelor’s degree in Business Administration, Computer Science, Statistics, or related field

Tools

Alteryx

Python

R

ETL tools

Job description

General Overview

This position is responsible for a wide range of analytics and reporting related to the organization’s financial, operational, and clinical performance. The analyst partners with customers within the Decision Support team and the broader finance organization to provide technical and data support on major initiatives. The incumbent aggregates detailed patient account or procedure‑level data into analytics‑ready datasets that are accessible to non‑technical end users. The analyst also assists with the growth and development of junior analysts through teaching, coaching, and mentoring.

Essential Responsibilities

• Responds to ad‑hoc requests for data and reporting from Highmark/AHN/Finance leadership or other partners (10%).
• Gathers requirements and leads development of new Tableau dashboards that meet customer needs and enhance business understanding (35%).
• Gathers requirements and leads development of new data sources, structures, and processes to support the needs of the Decision Support team and Finance organization (35%).
• Leverages automation tools and techniques to improve reliability and reduce/eliminate the need for manual intervention (10%).
• Engages IT and other key partners to advocate for new or improved technologies, tools, resources, processes, etc. (5%).
• Serves as an internal consultant to the AHN Finance organization by understanding business needs, evaluating alternatives, and recommending a solution (5%).
• Other duties as assigned or requested.

Qualifications

• Minimum bachelor’s degree in Business Administration, Computer Science, Statistics, or related field OR 6 years of related and progressive experience in lieu of a bachelor’s degree.
• 5 years of Decision Support and Data Analysis experience.
• Proficient in Microsoft Office (Excel, PowerPoint, etc.).
• Advanced SQL skill.
• Ability to extract, transform, or otherwise manipulate large quantities of data to support business needs.
• Ability to design and deliver reporting or other data visualizations that provide valuable, actionable, intuitive, and timely insights.
• Ability to translate vague or ambiguous business needs into specific technical requirements that meet the customer’s needs.
• Constant desire to improve existing technical tools/processes to realize gains in reliability, performance, or user‑friendliness.
• Ability to juggle multiple projects at once and manage time effectively to meet established deadlines.
• Strong communication and interpersonal skills with the ability to develop partnerships across the organization.
• Self‑starter who takes initiative and drives progress on major projects without being asked or with minimal supervision.

Preferred Qualifications

• Tableau or other data visualization tools.
• Master’s degree in Business Administration, Information Systems or related field.
• 1 year with Project Management.
• Relevant technical certifications (SQL, Tableau, Alteryx, etc.).
• Alteryx or other data wrangling/ETL tools.
• R, Python, or other statistical/programming tools.
• 5 years in a clinical setting or general understanding of hospital/physician practice operations.
• 5 years in the Healthcare industry, particularly as it relates to hospitals or other providers.

Pay Range

Minimum: $42.13 per hour. Maximum: $66.99 per hour. Base pay is determined by a variety of factors including a candidate’s qualifications, experience, and expected contributions, as well as internal peer equity, market, and business considerations. The displayed salary range does not reflect any geographic differential Highmark may apply for certain locations based upon comparative markets.

Legal & Compliance

All employees must comply with the Health Insurance Portability Accountability Act, the Company’s Code of Business Conduct, and other applicable federal, state, and local laws. Employees may have access to covered information, cardholder data, or other confidential customer information that must be protected at all times. All employees must comply with the company’s Privacy Policies, Information Security Policy, and related guidelines.