Actuarial Summer Intern: Pricing, Data & Modeling

Great American Insurance Group; Cincinnati (OH); On-site; USD 28,000 - 41,000; Part time

Job summary

Great American Insurance Group's Cincinnati headquarters is seeking motivated and analytical Actuarial Summer Interns for May/June 2027. You will work with Excel, SQL, Snowflake, R, and Python to analyze data, develop reports, maintain databases, and create visualizations supporting business decisions.

This internship targets students pursuing actuarial science, mathematics, statistics, or related fields, offering hands-on experience in pricing, reserving, predictive modeling, and reporting

Qualifications

• Excel experience: Intermediate to Advanced level.
• Passed at least one Actuarial Exam.
• Pursuing a Bachelor's or Master's degree in Actuarial Science, Mathematics, Statistics, or related field.
• GPA of 3.0 or higher required, 3.5 preferred.
• Beginner to Intermediate level with R, Python, or other Programming Languages.

Responsibilities

• Work may include developing and modifying R, Python, SQL and VBA automation tools.
• Developing and maintaining Microsoft Excel workbooks for ad-hoc analysis.
• Preparing and validating data, running projections, collecting result information and data, and producing analysis reports.
• Database maintenance – modify/create SQL and Snowflake queries, database cleansing and manipulation using R.
• Running existing queries following documented processes.
• Maintaining files and data for a number of activities and projects.
• Present and communicate findings to actuarial and business team members.
• Summarizing data and creating exhibits for various reports
• Data visualizations
• Other various computer-related projects and activities.

Skills

Excel proficiency

Actuarial exam

R/Python basics

Education

Bachelor’s or Master’s in Actuarial Science/Math/Stats

Tools

SQL

Snowflake

R

Python

VBA

Job description

Great American Insurance Group's Cincinnati headquarters is seeking motivated and analytical Actuarial Summer Interns for May/June 2027. You will work with Excel, SQL, Snowflake, R, and Python to analyze data, develop reports, maintain databases, and create visualizations supporting business decisions.

This internship targets students pursuing actuarial science, mathematics, statistics, or related fields, offering hands-on experience in pricing, reserving, predictive modeling, and reporting