Advanced Analytics Consultant

Health Care Service Corporation•Chicago, IL

1d•Hybrid

About The Position

The Health Economics Team (HET) is seeking a candidate to fill the Advanced Analytics Consultant position. The Advanced Consultant’s primary responsibility is to leverage strong technical skills (SQL, R, Python, and Tableau/PowerBI) and healthcare industry knowledge (payor, provider, pharmacy, public health, epidemiology, etc.) to support and enhance client-facing engagements with HCSC’s largest Commercial customers. This role is responsible for the analytic support and consultancy for HCSC’s largest Commercial Clients and advisory for internal senior-leader stakeholders related to population health and insurance. This position requires a background in healthcare consulting with an emphasis on an advanced-level understanding of medical claims and related datasets. As an Advanced Consultant member of the organization, the candidate will have the responsibility to be a thought leader in both external client engagements and internal team projects by holistically understanding the business problem at hand and how to efficiently work towards an end goal. This position requires communicating with and presenting to C-Suite stakeholders with the ultimate goal of elevating their understanding of plan cost and health drivers and collaborating internally to address them. Additionally, in partnership with management, this role will look to scale and help internally market impactful client engagements for broader impact. As a technical subject matter expert, it is expected that experience in designing and maintaining standard data layers, developing coding standards and documentation for organizational use cases, and troubleshooting challenges that arise during analytic development, is evident in prior work experience.

Requirements

Bachelor's degree and 5 years of experience in health care services, statistical analysis, insurance industry economics or related field OR Master’s degree in related field with 3 years of experience in health care services, statistical analysis, or insurance industry economics or related field OR 9 years of experience in health care services, statistical analysis, or insurance industry economics or related field
Understanding of and highly proficient at querying a wide variety of healthcare data and related population data (medical/pharmacy claims, behavioral health claims, health care management (HCM) records, electronic medical records (EMR), provider databases (AMA, NPI, DEA, etc.), member/patient demographic data, and publicly available databases (U.S. Census, Bureau of Labor Statistics, NIH, etc.).
Performance excellence in computer languages, such as SQL, R, Python.
Ability to create a dynamic and visually engaging dashboard leveraging data visualization tools such as Tableau or Power BI
High degree of business intelligence and understanding how to take a business case from inception to customer or partner execution.
Experience leading an analytic initiative to success.
Excellent communication and presentation skills.
Ability to work independently and as part of a team.
Performance excellence in championing initiatives and collaborating with multiple stakeholders to bring the initiative to life.

Nice To Haves

Masters and 3 years of experience in health care services, statistical analysis, or insurance industry economics including 1 year experience in analyzing medical claims data
Experience with Databricks.
Experience with project management methodologies.
Experience of Healthcare industry - payor, provider, pharmacy, public health, epidemiology, etc.
Experience with version control/collaborative tools.

Responsibilities

Leverage strong technical skills (SQL, R, Python, and Tableau/PowerBI) and healthcare industry knowledge to support and enhance client-facing engagements with HCSC’s largest Commercial customers.
Provide analytic support and consultancy for HCSC’s largest Commercial Clients.
Advise internal senior-leader stakeholders related to population health and insurance.
Be a thought leader in external client engagements and internal team projects by holistically understanding the business problem and efficiently working towards an end goal.
Communicate with and present to C-Suite stakeholders to elevate their understanding of plan cost and health drivers.
Collaborate internally to address plan cost and health drivers.
Scale and internally market impactful client engagements for broader impact.
Design and maintain standard data layers.
Develop coding standards and documentation for organizational use cases.
Troubleshoot challenges that arise during analytic development.