Catastrophe Modeling, Data Analytics Intern

Great American Insurance Group

. Learn to use modeling software to evaluate catastrophe risk .

Posted 9/17/2026part-timeCincinnati • Ohio • United StatesEntry LevelWebsite

Core Competencies

Role fit

Core Competencies

Use this summary to align your resume positioning with the role.

Proficient in data analysis and visualization, with hands-on experience in SQL, Python, Tableau, and Power BI. Strong analytical skills with a focus on catastrophe risk modeling and data engineering.

Highest-signal resume keywords

SQL Database ManagementPython Data EngineeringTableau Dashboard CreationPower BI VisualizationCatastrophe Risk Analysis

ATS Keywords

Tailor your resume

Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills

SQLPythonExcelData AnalysisData PreparationModeling SoftwareData CleaningDatabase ManagementStatistical AnalysisRisk Management

Soft Skills

Detail-OrientedCuriousEffective Communicator

Tools & Technologies

TableauPower BIModeling Software

Industry Keywords

Catastrophe RiskData EngineeringVisualizationWildfire MappingHurricane AnalysisConvective Storm AnalysisEarthquake Events

Tech Stack

Tools & technologies

PythonSQLTableau

About the role

Key responsibilities & impact

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 and 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 preparation tasks
Collaborate with experienced modelers, analysts, and teams to share tools and insights
Gain hands-on experience supporting catastrophe modeling, data engineering, and visualization efforts

Requirements

What you’ll need

Currently pursuing a degree in Mathematics, Statistics, Data Science, Risk Management, or a related field
Proficient with Excel
Willingness to learn SQL, Tableau, Power BI, and Python
Detail-oriented
Curious
Effective communicator
Must be authorized to work in the United States without the need for current or future employment visa sponsorship

Benefits

Comp & perks

Competitive benefits packages for full-time and part-time employees (excluding seasonal employees and interns)
Full-time employees: medical, dental, and vision coverage
Wellness plans
Parental leave
Adoption assistance
Tuition reimbursement
Paid Time Off for full-time and eligible part-time employees
Paid holidays for full-time and eligible part-time employees
401(k) plan with company match for full-time and eligible part-time employees
Employee stock purchase plan for full-time and eligible part-time employees
Commuter benefits for full-time and eligible part-time employees