You are viewing a preview of this job. Log in or register to view more details about this job.

Actuarial Intern - Summer 2027

Great American Insurance Group
Email

Great American Insurance Group is seeking motivated and analytical Actuarial Summer Interns to join our Cincinnati headquarters in May/June of 2027. This internship provides hands-on experience supporting actuarial and analytics teams through meaningful projects involving pricing, reserving, predictive modeling, data analysis, and reporting. Interns will work with tools such as Excel, SQL, Snowflake, R, and Python to analyze data, develop reports, maintain databases, and create visualizations that support business decision-making. This opportunity is ideal for students pursuing a degree in actuarial science, mathematics, statistics, or a related field who are eager to apply classroom knowledge in a professional, collaborative environment while gaining exposure to the property and casualty insurance industry.

 

The following departments are seeking an intern:

Corporate P&C Actuarial – Pricing/Reserving

Business Data & Analytics – Predictive Analytics/Modeling

Great American Risk Solutions – Excess & Surplus Lines Division


Essential Job Functions & 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.


Job 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.