Actuarial Intern: Data Modeling & Forecasting (10 weeks)

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

Job summary

Health Care Service Corp. (HCSC) offers a 10-week paid internship in Chicago, IL or Richardson, TX. Interns work with management and actuarial students on data modeling, database design, and reporting, delivering a final presentation to leadership.

The role emphasizes developing Excel, SQL, and VBA skills with mentorship, cross‑functional collaboration, and exposure to real business decisions within a purpose‑driven health company.

Qualifications

• Pursuing a bachelor’s degree; rising senior in a quantitative field.
• Completion of or plans to complete 1 ASA exam by graduation.
• Graduation date between Dec 2027 and Jun 2028.
• Minimum GPA 3.0/4.0.
• Available for the full 10-week program.
• Unrestricted US work authorization; sponsorship not available.

Responsibilities

• Support management and actuarial students with data gathering, modeling and reporting.
• Design and maintain databases; produce internal and external reports.
• Model provider payments and discounts; redesign forecasting models.
• Convert reserve model to a new software package; prepare yearly financial statements.
• Own components of project work with mentor guidance; deliverables on time.
• Research, analyze data, and develop business‑driving recommendations.
• Collaborate with cross‑functional teams; support initiatives improving outcomes.

Skills

Excel

SQL

VBA

Education

Bachelor's degree (in progress) in actuarial science, mathematics, statistics, finance, computer science or economics

ASA exam (1) planned/completed by graduation

Tools

SQL tooling

Job description

Health Care Service Corp. (HCSC) offers a 10-week paid internship in Chicago, IL or Richardson, TX. Interns work with management and actuarial students on data modeling, database design, and reporting, delivering a final presentation to leadership.

The role emphasizes developing Excel, SQL, and VBA skills with mentorship, cross‑functional collaboration, and exposure to real business decisions within a purpose‑driven health company.