Advanced Analytics Consultant

HCSC•Chicago, IL

1d•Hybrid

About The Position

The Advanced Analytics Consultant serves as technical analytics lead focused on building, validating, and automating client and employer group reporting solutions. The AAC is responsible for ensuring the accuracy, reliability, and efficient delivery of data files and reports used by internal stakeholders, vendors, and account teams. The AAC partners closely with account executives, underwriting, vendors, and analytics teams to gather requirements, perform user acceptance testing (UAT), and validate data across multiple enterprise systems. A key focus of the role is leveraging SQL, Python, and other tools to compare datasets, troubleshoot discrepancies, and ensure reporting outputs meet business and client expectations. Additionally, this role drives process improvements by designing and implementing automation for file monitoring, data validation, and report generation. The position plays a critical role in simplifying complex reporting workflows while enabling stakeholders to self-service data when possible. Success in this role requires a blend of strong technical expertise, healthcare domain knowledge (particularly claims and enrollment), and the ability to translate business needs into scalable, automated data solutions that improve efficiency, accuracy, and client outcomes.

Requirements

Bachelor's degree and 5 years of experience in health care services, statistical analysis, or 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 and high proficiency in querying a wide variety of internal and external data sources to get meaningful insights.
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

Experience with project management methodologies.
Experience of Healthcare industry - payor, provider, pharmacy, public health, epidemiology, etc.
Experience with version control/collaborative tools, such as GitHub
Experience with automation tools, such as Alteryx.

Responsibilities

Serve as technical analytics lead focused on building, validating, and automating client and employer group reporting solutions.
Ensure the accuracy, reliability, and efficient delivery of data files and reports.
Partner with account executives, underwriting, vendors, and analytics teams to gather requirements, perform user acceptance testing (UAT), and validate data.
Leverage SQL, Python, and other tools to compare datasets, troubleshoot discrepancies, and ensure reporting outputs meet business and client expectations.
Drive process improvements by designing and implementing automation for file monitoring, data validation, and report generation.
Simplify complex reporting workflows while enabling stakeholders to self-service data when possible.