Hiring: Actuarial Analyst Company: Lockton Location: Chicago, IL Job Posted Time: 2026-09-10 11:27:46 Employment Type: Internship Target Skills & Keywords : Microsoft Excel, Python, SQL About the job Experience: •2+ years of health benefits experience at a brokerage/consulting firm or insurance carrier preferred. Required Skills: •ESSENTIAL JOB DUTIES AND RESPONSIBILITIES •Work collaboratively with client service and actuarial/financial teams to collect, validate, and reconcile data for accuracy and consistency. •Integrate data from multiple sources into actuarial and financial client reports and deliverables. •Prepare routine financial and actuarial reports for self‑funded clients including ongoing claim reporting, rate setting, contribution development and plan design modeling; partner with client service teams to review findings and trends. •Assist in delivery of comprehensive financial reporting and insights to clients related to their health benefit plans. •Build and maintain basic to moderately complex actuarial models to analyze, illustrate, and project medical/Rx loss trends and client plan performance. •Prepare spreadsheets, graphs, charts, and other visualization tools to clearly communicate healthcare-related insights to clients. •Utilize actuarial and financial modeling tools to estimate the potential impact of health plan design changes, regulatory changes, and health reform on client costs. Qualifications: •Bachelor’s degree in actuarial science, mathematics, statistics, finance, economics, or related quantitative field. •Completion of actuarial exams preferred; candidates with 2 or more exams encouraged to apply. •Strong analytical and quantitative skills with an interest in actuarial career progression (including pursuit of at least ASA designation). •Excellent communication and customer service skills with the ability to support multiple client team relationships. •Solid functional working knowledge of employee benefits, health insurance, and/or risk concepts preferred (job, school coursework and internship experience all accepted). •Strong computer skills, including proficiency in Microsoft suite, especially Excel (pivot tables, formulas, data manipulation); experience with VBA, SQL, Python, or similar programming language is a plus. •Excellent organizational skills and attention to detail. •Legal right to work in the United States. Interested candidates, please apply directly through the job posting on company's career page or try via AI auto apply on this platform. Don't miss this opportunity to join a forward-thinking team!