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.
Job SummaryThe 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.
Are you being referred to one of our roles? If so, ask your connection at HCSC about our Employee Referral process!
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.
HCSC 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.
Base Pay Range$70,600.00 - $149,600.00Exact compensation may vary based on skills, experience, and location.
Skills Required
- Bachelor's degree plus 5 years experience OR Master's degree plus 3 years experience OR 9 years experience in healthcare services, statistical analysis, insurance economics, or related field
- Proficiency querying a wide variety of internal and external data sources to derive insights
- Proficiency in SQL, R, and Python
- Ability to create dynamic, visually engaging dashboards using Tableau or Power BI
- Strong business intelligence skills and ability to translate business cases into executable solutions
- Experience leading analytic initiatives to successful delivery
- Excellent communication and presentation skills
- Ability to work independently and collaboratively as part of a team
- Experience collaborating with multiple stakeholders, vendors, and account teams
- Healthcare domain knowledge, particularly claims and enrollment
- Experience with user acceptance testing (UAT) and data validation processes
- Drive process improvements and implement automation for file monitoring, data validation, and report generation
- Adhere to hybrid work policy (3 days in office weekly at listed locations)
- Experience with project management methodologies
- Experience in healthcare industry roles (payor, provider, pharmacy, public health, epidemiology)
- Experience with version control/collaborative tools such as GitHub
- Experience with automation tools such as Alteryx
Health Care Service Corporation Compensation & Benefits Highlights
The following summarizes recurring compensation and benefits themes identified from responses generated by popular LLMs to common candidate questions about Health Care Service Corporation and has not been reviewed or approved by Health Care Service Corporation.
-
Retirement Support — A pension plan alongside a matching 401(k) is offered, an uncommon combination in the private sector. This combination is described as a standout element that helps retain employees.
-
Healthcare Strength — Healthcare options are broad, with multiple medical, dental, and vision choices, wellness incentives, and access to resources like on-site fitness centers and an EAP. These offerings add meaningful value beyond base pay.
-
Parental & Family Support — Paid parental leave (up to six weeks at full pay after one year), adoption assistance, and mothers’ rooms are available. These supports reinforce family needs alongside work commitments.
Health Care Service Corporation Insights
What We Do
Imagine Something New, Something Different. Health Care Service Corporation, a Mutual Legal Reserve Company (HCSC), is the largest customer-owned health insurer in the nation and the fourth largest overall. Operating through our Blue Cross and Blue Shield Plans in Illinois, Montana, New Mexico, Oklahoma and Texas (as well as a variety of affiliates and subsidiaries,) we are expanding access to high-quality, cost-effective health care. We are equipping members with information and tools so they can make the best health care decisions for themselves and their families. HCSC is continuously recognized as an employer committed to community, diversity and inclusion, training and development. HCSC is committed to pioneering the health care space in ways as effective as they are creative. If you are passionate about the impact you want to have through your work, with a desire to apply innovative thinking to new and emerging challenges, we encourage you to learn more about HCSC. Learn about what we stand for, how we work and the difference we’re making in the lives of our 15 million members. Join HCSC and discover what new ways of thinking can mean for you, your community, our customers and our organization. Divisions of Health Care Service Corporation, a Mutual Legal Reserve Company, an Independent Licensee of the Blue Cross and Blue Shield Association.
