Great American Insurance Group logo

Catastrophe Modeling & Data Analytics Intern (Fall 2025)

Great American Insurance Group

Cincinnati, OH
Internship
Intern
about 2 months ago

Job Description

About the Role

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 diversity and recognize the benefits gained when people from different cultures, backgrounds and experiences work collaboratively to achieve business results. We are intentionally focused on fostering an inclusive culture and know valuing diversity is an essential leadership quality. 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. The internship is a full-time, Fall 2025 hybrid position based out of our downtown Cincinnati office.

Key Responsibilities

  • Collaborate with experienced modelers and analysts on projects.
  • Learn to use modeling software to evaluate catastrophe risk.
  • Explore how catastrophe models inform pricing, underwriting, and reinsurance decisions.
  • Build vulnerability maps across U.S. counties and Canadian geospatial grids.
  • 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.

Requirements

  • 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, PowerBI and Python.
  • Looking for someone who is detail-oriented, curious, and an effective communicator to join our collaborative team.

Nice to Have

  • Experience with modeling software for catastrophe risk evaluation.
  • Knowledge of geospatial analysis and mapping.

Qualifications

  • Proficiency in Excel.
  • Willingness to learn SQL, Tableau, PowerBI, and Python.

Benefits & Perks

  • Competitive Total Rewards package, including medical, dental, and vision plans starting on day one.
  • Paid time off (PTO) and holidays.
  • Commuter benefits.
  • Employee stock purchase plan.
  • Education reimbursement.
  • Paid parental leave and adoption assistance.
  • 401(k) plan with company match.

Working at Great American Insurance Group

We value diversity and recognize the benefits gained when people from different cultures, backgrounds and experiences work collaboratively to achieve business results. We are intentionally focused on fostering an inclusive culture and know valuing diversity is an essential leadership quality. Our goal is to create a workplace where all employees feel included, empowered and enabled to perform at their best.

Apply Now

Job Details

Posted AtJun 7, 2025
Job CategoryData Analytics
SalaryCompetitive salary
Job TypeInternship
Work ModeHybrid
ExperienceIntern

Job Skills

AI Insights

Key skills identified from this job posting

Sign upto access all insights for this job

About Great American Insurance Group

Website

greatamericaninsurancegroup.com

Company Size

5001-10000 employees

Location

Cincinnati, OH

Industry

Direct Insurance (except Life, Health, and Medical) Carriers

Get job alerts

Set up personalized alerts for your job search and get tailored job digests for close matches