Catastrophe Modeling & Data Analytics Intern (Spring 2027)

Great American Insurance Group

Hours: Part time
Where: Cincinnati, OH (USA)
Posted: Sep 17

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.

This position is not eligible for employment visa sponsorship.

What you'd do

Learn to use modeling software to evaluate catastrophe risk.
Run analyses and identify high-risk catastrophe regions.
Update and maintain databases, tables, queries and processes in SQL.
Review, update and maintain data engineering code in Python.
Consolidate and clean up redundant reference tables across multiple databases.
Create Tableau/Power BI dashboards.
Map wildfire, hurricane, convective storm, and earthquake events for visual insights.
Help streamline repeatable modeling processes.
Learn and apply Python for automation and data prep tasks.
Collaborate with teams to share tools and insights.

What they want

Currently pursuing a degree in Mathematics, Statistics, Data Science, Risk Management, or a related field.
Proficient with Excel and a willingness to learn SQL, Tableau, Power BI and Python.
Looking for someone who is detail-oriented, curious, and an effective communicator to join our collaborative team.

Starts: 2026-09-17