Advanced Analytics Consultant

Health Care Service Corporation; Chicago (IL); Hybrid; USD 70,600 - 149,600; Full time

Benefits offered by this job

Hybrid work policy (3 days in office)

Job summary

Health Care Service Corporation (HCSC) is seeking an Advanced Analytics Consultant to lead technical analytics efforts, build and validate client and employer group reporting solutions, and automate data workflows.

The role partners with account teams, vendors, and analytics groups, requiring strong SQL and Python skills, data visualization experience, and the ability to translate business needs into scalable self-service data solutions in a hybrid Chicago office.

Qualifications

• Bachelor’s degree or higher in health care services, statistics, or related field with substantial experience in analytics.
• Proficiency querying diverse data sources to derive meaningful insights.
• Strong SQL, Python, and data visualization capabilities.

Responsibilities

• Lead analytics initiatives and validate client and employer group reporting outputs.
• Collaborate with account executives, vendors, and analytics teams to gather requirements and perform UAT.
• Design and implement automated data workflows to improve accuracy and efficiency.

Skills

SQL

Python

Data visualization

Stakeholder comms

Leadership

Education

Bachelor’s degree in health care services, statistics, or related field

Master’s degree in related field (optional)

9+ years of relevant experience

Tools

Tableau

Power BI

GitHub

Alteryx

Job description

At HCSC, our employees are the cornerstone of our business and the foundation to our success. We empower employees with curated development plans that foster growth and promote rewarding, fulfilling careers.

Join HCSC and be part of a purpose-driven company that will invest in your professional development.

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.

Please note: Candidates who require current or future visa sponsorship (e.g., H-1B, TN, OPT, CPT, or other employment-based sponsorship) are not eligible for consideration for this position.

Required Job Qualifications

• 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 being highly proficient at 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.

Preferred Job Qualifications

• 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.

This position is expected to adhere to HCSC's hybrid FLEX policy of 3 days in office weekly at one of the listed locations.

Compensation: $70,600.00 - $149,600.00

Exact compensation may vary based on skills, experience, and location

We are an Equal Opportunity Employment employer dedicated to providing a welcoming environment where the unique differences of our employees are respected and valued. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, protected veteran status, or any other legally protected characteristics.