Actuarial Intern P&C - Summer 2027

Farm Bureau Financial Services; West Des Moines (IA); On-site; USD 28,000 - 41,000; Full time

Job summary

Farm Bureau Financial Services in West Des Moines, IA seeks an Actuarial Intern P&C for Summer 2027, offering hands-on experience alongside actuarial staff and exposure to rating factors, automation, and internal reports.

You will develop rate revisions, profile data with SQL/Excel, and learn database structures while participating in our 80/10/10 internship program. Degree pursuing in data science or actuarial science is preferred; actuarial exam helpful.

Qualifications

• Be dependable and able to work full time (38.75 hours per week), on-site in West Des Moines during Summer.
• Pursuing a college degree in data science or actuarial science is preferred.
• Completion of an actuarial exam is preferred but not required.
• Significant experience with spreadsheets and using them to solve actuarial problems.
• Knowledge of programming or statistical software such as VBA, SQL, R, Python or SAS.
• Strong mathematical and analytical ability to analyze and resolve problems.
• Excellent written and spoken communication in English.
• Ability to work on-site at our West Des Moines, Iowa office.

Responsibilities

• Develop rate level and rating factor revisions for annual rate changes.
• Gain working knowledge of automation to validate rating factors and actuarial processes.
• Compile information on competitor rating and coverage.
• Work with our competitive rating tool and internal data to prepare reports and maps.
• Utilize SQL and Excel to profile data and support projects.
• Learn about database structures and related concepts.
• Participate in corporate internship activities to learn about our culture and operations.

Skills

Spreadsheet proficiency

Mathematical ability

Analytical thinking

Communication skills

English language

Education

Actuarial/Data Science degree (pursuing)

Tools

VBA

SQL

R

Python

SAS

Job description

Actuarial Intern P&C - Summer 2027

There are currently two internships available

Are you looking for real-world experience right now? If so, we have an internship for you! Gain valuable experience as a P&C Actuarial Intern. In this role, you will be providing support to actuarial staff and assisting in basic actuarial functions and insurance concepts. In addition, you will also develop a working knowledge of automation in relation to validating rating factors as well as actuarial processes, reports, and exhibits. Types of projects you can expect to be involved in may include:

• Developing rate level and rating factor revisions for annual line of business rate changes.
• Developing a working knowledge of automation to validate rating factors as well as actuarial processes, reports, and exhibits.
• Compiling information regarding competitor rating and coverage.
• Working with our competitive rating tool and internal data to compile reports and maps relating to competitive prices.
• Utilizing SQL and Excel to profile data.
• Learning about database structures.

As an intern, you will also participate in corporate activities designed to provide exposure to our industry, organization, and culture. Our internship program follows an 80/10/10 approach:

• 80% of your time will be spent performing meaningful work and project-based assignments within your department.
• 10% of your time will be dedicated to learning from and networking with employees in other areas of the organization.
• 10% of your time will be spent participating in shared internship experiences that provide insight into our culture, leadership, and business operations.

What will you bring to the team?

• Be dependable and able to work full time (38.75 hours per week), on-site in West Des Moines during Summer of 2026.
• Working toward a College degree in data science or actuarial science is preferred. Completion of an actuarial exam is preferred but not required.
• Have substantial experience with spreadsheets and be able to utilize spreadsheets to solve to actuarial related problems.
• Have knowledge of programming or statistical software packages such as VBA, SQL, R, Python or SAS.
• Have above average mathematical and analytical ability to be able to analyze and resolve difficult problems.
• Strong analytical, problem-solving and organizational skills required.
• Have professional oral and written communication skills
• Have the ability to read, write and speak the English language are also required.
• Ability to work in person from our office in West Des Moines, Iowa.

Work Authorization/Sponsorship:

At this time, we are not considering candidates that need any type of immigration sponsorship now or in the future, such as additional or permanent work authorization. Applicants must be currently authorized to work in the United States on a full-time, permanent basis. We are not able to sponsor now or in the future, or take over sponsorship of, an employment visa or work authorization for this role. For example, we are not considering candidates with OPT status.