Jobs › Health Care Service Corporation

Analytics and Reporting Consultant

Health Care Service Corporation · Chicago, IL · Remote available · $84,400–$152,300 a year · Full time

Posted Oct 2, 2026 · We last checked this listing on Oct 6, 2026

Apply at Health Care Service Corporation

Likely interview questions for this role

Written from this job description, not a generic list. Each one notes what the interviewer is really checking.

About your past

Walk me through a time you found a trend in data that changed what decision makers did.

What they are checking: Ability to move from producing numbers to providing insight with business impact.

Tell me about a cross-functional team you led to solve a data problem.

What they are checking: Leadership experience the posting mentions, including keeping people with other priorities engaged.

How do you build relationships with the business users who depend on your reports?

What they are checking: Customer focus, since the posting asks them to work closely with customers and understand their needs.

What would you do

A business leader asks for a report but cannot clearly say what decision it will support. How do you write the specification?

What they are checking: Whether they dig for the real question before building, so reports end up actionable rather than unused.

You are the link between the business and the divisional data team. How do you handle it when they disagree on what is feasible?

What they are checking: Ability to translate needs and constraints between groups and find a workable middle path.

Two reports from different teams show different numbers for the same metric. How do you sort it out?

What they are checking: Whether they track down definitions and sources rather than picking the number they like.

How do you explain the limits of an analysis to a leader who wants a firm answer?

What they are checking: Honesty about uncertainty without making the analysis useless to the person deciding.

About the work

How do you validate a dataset before you build a report on it?

What they are checking: Data quality habits like checking counts, duplicates and reconciling totals to known sources.

What SQL would you write to find members whose claims costs rose sharply year over year?

What they are checking: Hands-on query skill, including joins, aggregation and comparing periods.

Which reporting or visualization tools have you used, and how do you decide what goes on a dashboard?

What they are checking: Tool experience and the judgment to show only what helps users act.

Practice this interview out loud.

Offer builds a real interview for this exact role at Health Care Service Corporation from your resume and this job description, asks the questions one at a time, and tells you what landed. The first one is free.

Practice this out loud

The full job description

As published by Health Care Service Corporation.

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 Summary This position is responsible for creating reports, insights and analytics in support of the division; creating specifications for reports and analysis based on business needs; possibly providing consultation to users and leading cross functional teams to address the divisions issues; producing datasets and reports for analysis using system reporting tools; possibly performing research and assisting in analyzing data related to the divisions strategic initiatives and broader research needs; interfacing between the business and divisional data teams to generate tools to be leveraged in building analysis and reports which are actionable within the business environment; working closely with customers to build relationships; and continuously gaining a deeper understanding of the division's data in order to meet business needs; analyzing complex business problems and issues using data from internal and external sources to provide insight to decision makers; identifying and interpreting trends and patterns in datasets to locate influences. Required Job Qualifications: • Bachelor degree and 4 years of analytical experience in relationship management or driving analytics insights into action OR 9 years of analytical experience in relationship management or driving analytics insights into action. • Experience gathering and document business requirements in support of information-related strategies. • Experience solving complex problems; Experience taking a new perspective using existing solutions. • Knowledge of various software development processes, including SDLC, Agile methodologies, and tools and technologies. • Experience creating and conducting presentations to inform and influence. • Experience in leading functional teams and projects. • Experience with SAS, SPSS, R, MATLAB, SQL, Python etc. • Clear and concise verbal and written communication skills. • PC proficiency with Microsoft applications including Access, Excel, Word and Power Point. Preferred Job Qualifications: • Bachelor degree in business, engineering or mathematics. • Master degree. • Healthcare experience in business development, business analytics, or innovation management This is a work from home position Sponsorship is not available. 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. This position may be performed remotely from anywhere within the continental United States, excluding California, New York, Alaska, and Hawaii . 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. We are a drug-free and smoke-free workplace. Employment may be contingent upon successful completion of drug screening in accordance with applicable law. Base Pay Range $84,400.00 - $152,300.00 Exact compensation may vary based on skills, experience, and location.

Apply at Health Care Service Corporation