Actuarial Analyst

Lockton Companies; St. Louis (MO); On-site; USD 65,000 - 90,000; Full time

Job summary

Lockton Companies LLC in St. Louis, MO, is seeking an Associate to support data collection, validation, and reporting for self-funded health plans. You will integrate data from multiple sources into client reports, assist in rate setting and plan design modeling, and help deliver insights to clients.

The role emphasizes actuarial analysis, Excel-based data manipulation, and collaboration with client service teams, with opportunities for exams and career growth in health benefits analytics.

Qualifications

• Bachelor’s degree in actuarial science, mathematics, statistics, finance, economics, or related quantitative field.
• 2+ years of health benefits experience at a brokerage/consulting firm or insurance carrier preferred.
• 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.
• 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.

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.
• Support development of health plan reserve estimates for self-funded clients.
• Produce custom analytics and reporting for unique client requests, leveraging actuarial and benchmark data where appropriate.
• Serve as a developing Subject Matter Expert on financial and actuarial reporting, building expertise over time.
• Learn and apply internal systems, tools, and modeling platforms to improve efficiency and analytical accuracy.
• Stay current on insurance/benefits industry developments, emerging trends, and actuarial best practices.
• Contribute to a positive client experience through accuracy, responsiveness, and clear communication.
• Participate in internal team meetings and trainings, including actuarial skill development sessions.
• Perform other responsibilities as assigned.

Skills

Data analysis

Excel

SQL

Python

VBA

Communication

Attention to detail

Education

Bachelor’s degree in actuarial science, mathematics, statistics, finance, economics, or related quantitative field

Tools

Excel (Pivot tables)

VBA

SQL

Python

Job description

St. Louis, Missouri, United States of America

At Lockton, we’re passionate about helping our people achieve their ultimate potential. Our people are curious, action-oriented and always striving to make ourselves and those around us better. We’re active listeners working to ensure understanding and problem solvers developing innovative solutions. If you can see yourself delivering excellent service to clients, giving back to our communities and being a part of our caring culture, you belong here.

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.
• Support development of health plan reserve estimates for self-funded clients.
• Produce custom analytics and reporting for unique client requests, leveraging actuarial and benchmark data where appropriate.
• Serve as a developing Subject Matter Expert on financial and actuarial reporting, building expertise over time.
• Learn and apply internal systems, tools, and modeling platforms to improve efficiency and analytical accuracy.
• Stay current on insurance/benefits industry developments, emerging trends, and actuarial best practices.
• Contribute to a positive client experience through accuracy, responsiveness, and clear communication.
• Participate in internal team meetings and trainings, including actuarial skill development sessions.
• Perform other responsibilities as assigned.

Compensation and Benefits

Lockton Companies LLC is committed to offering competitive pay and benefits and complies with all relevant state/local pay transparency laws. The entry base salary offered for this opportunity may vary, and is contingent upon candidate education, skills, abilities, essential competencies, experience, professional designations, unique qualifications, and geographic location.

Performance Bonus: This role may be eligible for an annual performance bonus, based upon the financial performance of the organization and the individual contributions of the Associate.

Check out Lockton Benefits Offerings Here

Qualifications

EDUCATION, EXPERIENCE, AND SKILLS REQUIRED

• Bachelor’s degree in actuarial science, mathematics, statistics, finance, economics, or related quantitative field.
• 2+ years of health benefits experience at a brokerage/consulting firm or insurance carrier preferred.
• 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.
• 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.

Equal Opportunity Statement

Lockton Companies is proud to provide everyone an equal opportunity to grow and advance. We are committed to an inclusive culture and environment where our people, clients and communities are treated with respect and dignity.

At Lockton, supporting diversity, equity and inclusion is ingrained in our values, and we believe that we are at our best when we fully embrace everyone. We strive to cultivate a caring culture that learns from, celebrates and thrives because of our breadth of differences. As such, we recognize that recruiting, developing and retaining people with diverse backgrounds and experiences is vital and enabling our people to thrive personally and professionally is critical to our long‑term success.