Actuarial Intern - Summer 2027

Summit Consulting; Cincinnati (OH); Hybrid; USD 18,000 - 23,000; Part time

Job summary

Great American Insurance Group invites motivated actuarial students for a Summer 2027 internship at our Cincinnati headquarters. You will work with pricing, reserving, and analytics teams, applying Excel, SQL, Python, and R to real-world data projects.

Ideal candidates are pursuing actuarial science, mathematics, or statistics, with at least one exam passed and a GPA of 3.0 or higher. This hybrid internship provides hands-on experience in property & casualty analytics and data visualization.

Qualifications

• Excel proficiency at an intermediate to advanced level.
• Passed at least one actuarial exam.
• Pursuing a Bachelor's or Master's in Actuarial Science, Mathematics, Statistics, or related field.

Responsibilities

• Assist actuarial teams with pricing and reserving tasks.
• Develop and maintain data analyses and reports using Excel, SQL, Python, or R.
• Create data visualizations and summaries for stakeholder reviews.
• Support data cleaning and database queries in Snowflake.

Skills

Excel

SQL

Python

R

VBA

Education

Actuarial Science/Math/Statistics degree

Tools

Snowflake

Job description

## Actuarial Intern - Summer 2027Applyremote type: Hybridlocations: Cincinnati, OH (USA)posted on: Posted Todayjob requisition id: R9332**Be Here. Be Great.** Working for a leader in the insurance industry means opportunity for you. Great American Insurance Group's member companies are subsidiaries of American Financial Group. We combine a "small company" culture where your ideas will be heard with "big company" expertise to help you succeed. With over 30 specialty and property and casualty operations, there are always opportunities here to learn and grow.At Great American, we value and recognize the benefits derived when people with different backgrounds and experiences work together to achieve business results. Our goal is to create a workplace where all employees feel included, empowered, and enabled to perform at their best.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.**Business Unit:**Property & Casualty Finance**Benefits:**We offer competitive benefits packages for full-time and part-time employees\*. Full-time employees have access to medical, dental, and vision coverage, wellness plans, parental leave, adoption assistance, and tuition reimbursement. Full-time and eligible part-time employees also enjoy Paid Time Off and paid holidays, a 401(k) plan with company match, an employee stock purchase plan, and commuter benefits. Compensation varies by role, level, and location and is influenced by skills, experience, and business needs. Your recruiter will provide details about benefits and specific compensation ranges during the hiring process. Learn more at http://www.gaig.com/careers. **\*Excludes seasonal employees and interns.**