Catastrophe Modeling & Data Analytics Intern (Fall 2026)

Great American Insurance Group

Posted 4 days ago

Internship

Cincinnati, Ohio

Hybrid

Smart Summary

Responsibilities

The intern will collaborate on catastrophe risk evaluation, geospatial analysis, and the maintenance of SQL databases. They will also create visualization dashboards and use Python to automate data preparation and modeling processes.

Qualifications

You are pursuing a degree in a quantitative field such as Mathematics, Statistics, Data Science, or Risk Management. You are proficient in Excel and eager to learn SQL, Tableau, Power BI, and Python. You possess strong communication skills and a keen eye for detail, making you a valuable contributor to our collaborative team.

Must Have Skills for ATS

SQL

Python

Tableau

Power BI

Excel

Job Description

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.

Are you a data-driven problem solver looking to explore the world of catastrophe modeling?  Our Reinsurance Division is offering an exciting internship opportunity for individuals eager to learn and contribute to real-world projects in a supportive team environment. This internship offers hands-on experience with real-world projects that support our catastrophe modeling, data engineering, and visualization efforts.

What You’ll Work On

You’ll collaborate with experienced modelers and analysts on projects such as:

Modeling & Geospatial Analysis

  • Learn to use modeling software to evaluate catastrophe risk.

  • Run analyses and identify high-risk catastrophe regions.


SQL & Data Engineering

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


Visualization & Reporting

  • Create Tableau/Power BI dashboards.

  • Map wildfire, hurricane, convective storm, and earthquake events for visual insights.


Process Optimization

  • Help streamline repeatable modeling processes.

  • Learn and apply Python for automation and data prep tasks.

  • Collaborate with teams to share tools and insights.

What We’re Looking For

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

Business Unit:

Reinsurance

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.

Great American Insurance Group

For more than 150 years, customers have trusted us to protect what matters most to them. Great American Insurance Group’s roots go back to 1872 with the founding of its flagship company, Great American Insurance Company. Our innovative and specialized insurance solutions are designed to serve niche marketplaces that we know well. With our deep expertise and financial strength, we have laid a foundation of success that has stood the test of time. Based in Cincinnati, Ohio, the operations of Great American Insurance Group are engaged in property and casualty insurance. With more than 35 specialty property and casualty insurance businesses, we’re well-positioned to offer tailored insurance solutions to meet businesses’ unique needs. Great American Insurance Company has received an "A" (Excellent) or higher rating from the AM Best Company for 115 years (most recent rating evaluation of "A+" (Superior) affirmed December 11, 2025). The members of Great American Insurance Group are subsidiaries of American Financial Group, Inc. (AFG), also based in Cincinnati, Ohio.
Runway Icon
Boost Your Interview Chances

With Runway

See Your Fit for This Role

1-5 min

Your Score

?

Top Applicants

90%

Your Job Search Advantage

Key Gaps & Next Steps:

Address these in your resume & Interview

Top Strengths For This Role

Highlight these in your cover letter & interview

Your Interview Guide

A Personalized Interview Strategy

Freshest Opportunities

Never Miss a Good Fit

Get notified when jobs mach your criteria