Sr Analytics Consultant - Pharmacy Data Steward

Health Care Service Corp.; Chicago (IL); Hybrid; USD 84,000 - 152,000; Full time

Job summary

Health Care Service Corporation (HCSC) is seeking a Senior Consultant to apply advanced analytics and governance to support Pharmacy Business and Analytics teams. You will bridge Business and IT/BDS, delivering timely Rx insights and agile ETL solutions using tools like Alteryx, SAS, or similar platforms.

You will work with clinical and business stakeholders, leading analytics initiatives, communicating findings to senior leadership, and ensuring high-quality outputs under tight timelines in a

Qualifications

• Bachelor’s degree with 6 years of relevant experience.
• Master’s degree with 4 years of relevant experience.
• PhD with 2 years of relevant experience.
• 10 years of experience in health care services, statistics, or insurance economics or related field.
• Proficiency at querying a wide variety of internal and external data sources to derive insights.
• Strong analytical skills and proficiency in SQL, Python, R, etc.

Responsibilities

• Support clinical and business stakeholders with analytics.
• Develop agile, interim ETL solutions—using Alteryx, SAS, or similar platforms.
• Serve as strategic liaison between Business and IT/BDS teams.

Skills

SQL

Python

R

Data visualization

Communication

Independent work

Team collaboration

BI/analytics

Analytics leadership

Stakeholder management

Education

Bachelor's degree

Master's degree

PhD

Tools

Alteryx

SAS

Tableau

Power BI

SQL

Job description

Job Summary

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 Senior Consultant leverages advanced technical expertise and healthcare industry knowledge to support clinical and business stakeholders. This role functions as a critical data development and governance champion and serves as the strategic liaison between Business and IT/BDS teams. You will be accountable for Rx analytical support and the development of agile, interim solutions—utilizing tools such as Alteryx, SAS, or other ETL platforms—to meet the immediate needs of Pharmacy Business and Analytics teams.

Required Job Qualifications

• Bachelor’s degree and 6 years of experience in health care services, statistical analysis, or insurance industry economics or related field.
• Master’s degree with 4 years of experience in health care services, statistical analysis, or insurance industry economics or related field.
• PhD with 2 years of experience in health care services, statistical analysis, or insurance industry economics or related field.
• 10 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.
• Strong analytical skills and proficiency in computer languages, such as SQL, Python, R, etc.
• 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.
• Ability to work under pressure and delivery high quality output to senior leadership to decision making within short timeline.

Preferred Job Qualifications

• Deep expertise in the Healthcare industry (Payor, Provider, Pharmacy or Epidemiology).
• Experience with cloud-based data warehouses such as Snowflake, Azure Synapse, or WES Redshift to support the transition from legacy systems to modern architectures.
• Familiarity with data cataloging and metadata management platforms like Collibra, Alation, or Informatica to operationalize data stewardship and lineage.
• Knowledge of project management methodologies.

This is a Flex (Hybrid) role: 3 days in office; 2 days work from home.

Pay Transparency Statement

At Health Care Service Corporation, you will be part of an organization committed to offering meaningful benefits to our employees to support their life outside of work. From health and wellness benefits, 401(k) savings plan, pension plan, paid time off, paid parental leave, disability insurance, supplemental life insurance, employee assistance program, paid holidays, tuition reimbursement, plus other incentives, we offer a robust total rewards package for employees. Learn more about our benefit offerings by visiting https://careers.hcsc.com/totalrewards. The compensation offered will vary depending on your job-related skills, education, knowledge, and experience. This role aligns with an annual incentive bonus plan subject to the terms and the conditions of the plan.

Employment Statement

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.

If you are an individual with a disability or a disabled veteran and need an accommodation or assistance in either using the Careers website or completing the application process, you can call us at 1-866-977-7378 to request reasonable accommodations.

Base Pay Range

$84,400.00 - $152,300.00 (Exact compensation may vary based on skills, experience, and location).