Catastrophe Modeling & Data Analytics Intern (Spring 2027)
Great American Insurance Company•Cincinnati, OH
•Hybrid
About The Position
This internship offers hands-on experience with real-world projects that support our catastrophe modeling, data engineering, and visualization efforts. Great American’s culture is built on connection, shared learning, and strong relationships. To support this, employees in this role are expected to be on‑site four days a week, with the flexibility to work one day remotely. Core in‑office days are Tuesday–Thursday, with the fourth day determined by business needs.
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, Power BI and Python.
- Looking for someone who is detail-oriented, curious, and an effective communicator to join our collaborative team.
Responsibilities
- 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.
Benefits
- medical, dental, and vision coverage
- wellness plans
- parental leave
- adoption assistance
- tuition reimbursement
- Paid Time Off
- paid holidays
- 401(k) plan with company match
- employee stock purchase plan
- commuter benefits
Stand Out From the Crowd
Upload your resume and get instant feedback on how well it matches this job.
Upload and Match Resume
What This Job Offers
Career Level
Intern
Education Level
Associate degree
