Claims Data & Tech Intern

Great American Insurance Company

Cincinnati (OH)

Hybrid

USD 21,000 - 28,000

Full time

6 days ago
Be an early applicant

Get a reply from this employer

Your resume and cover letter, tailored to exactly what they’re hiring for.

Get past ATS filters

Benefits offered by this job

Tuition reimbursement
Paid time off
401(k) with company match
Commuter benefits

Job summary

Great American Insurance Group is seeking a summer 2027 intern for the Claims Management/Data teams within the P&C IT Services group in Cincinnati. You will support data flows from legacy systems, Snowflake, and Guidewire ClaimCenter, while helping with data warehouse processes and ETL tasks.

Responsibilities include documenting user stories, updating mappings, testing applications, and analyzing data workflows. Office presence required at least three days per week.

Qualifications

  • Ability to read/decipher data models/schema.
  • Ability to read and write SQL queries.
  • Experience with application testing.
  • Proficiency in Microsoft Office suite.
  • Effective oral, written, and interpersonal communication skills.
  • Ability to work independently and collaboratively.

Responsibilities

  • Creating and maintaining documentation such as user stories, process flows, and requirements.
  • Update integration mapping documents.
  • Analyze Non-Prod Sonic and Recycle errors.
  • Assist with Data correction on Claim Payloads.
  • Work on ERB request for downstream mapping.
  • Assist with application testing.
  • Ability to work independently and collaboratively.
  • Ability to read/decipher data models/schema.
  • Ability to read and write SQL queries.

Education

Pursuing a degree in Data Analytics or related

Tools

SQL
Microsoft Office

Job description

Great American Insurance Group is seeking a summer 2027 intern for the Claims Management/Data teams within the P&C IT Services group in Cincinnati. You will support data flows from legacy systems, Snowflake, and Guidewire ClaimCenter, while helping with data warehouse processes and ETL tasks.

Responsibilities include documenting user stories, updating mappings, testing applications, and analyzing data workflows. Office presence required at least three days per week.

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Claims Tech Intern: Data & Analytics (Summer 2027)
Claims Tech Intern: Data & Analytics (Summer 2027)

Kalepa • Cincinnati (OH)

Hybrid
USD 21,000 - 34,000
Claims Tech & Data Intern – Hybrid (Summer 2027)
Claims Tech & Data Intern – Hybrid (Summer 2027)

Great American Insurance Company • United States

Hybrid
USD 20,000 - 31,000
Medical, dental, and vision coverage
Tuition reimbursement
Paid time off and holidays
+2
Claims Technical Analyst Intern - Summer 2027
Claims Technical Analyst Intern - Summer 2027

Kalepa • Cincinnati (OH)

Hybrid
USD 21,000 - 34,000
Claims Technical Intern
Claims Technical Intern

Great American Insurance Company • Cincinnati (OH)

Hybrid
USD 21,000 - 28,000
Tuition reimbursement
Paid time off
401(k) with company match
+1
Claims Technical Intern - Summer 2027
Claims Technical Intern - Summer 2027

GAIC Great American Insurance Company • United States

Hybrid
USD 20,000 - 31,000
Medical, dental, and vision coverage
Tuition reimbursement
Paid time off and holidays
+2
Insurance Claims Intern — Hybrid & Project-Focused
Insurance Claims Intern — Hybrid & Project-Focused

Great American Insurance Group • Cincinnati (OH)

Hybrid
USD 21,000 - 28,000
Medical insurance
Dental insurance
Vision insurance
+2
Business Analytics Intern — AI-Driven, Hybrid (Summer 2027)
Business Analytics Intern — AI-Driven, Hybrid (Summer 2027)

Great American Insurance Company • Cincinnati (OH)

Hybrid
USD 21,000 - 30,000
Medical coverage
Dental coverage
Vision coverage
+4
Claims Operations Intern - Hybrid (Spring 2027)
Claims Operations Intern - Hybrid (Spring 2027)

Great American Insurance Group • Ohio

Hybrid
USD 21,000 - 30,000
IT Intern: AI, Data Analytics & Billing Systems (Hybrid)
IT Intern: AI, Data Analytics & Billing Systems (Hybrid)

Great American Insurance Group • Cincinnati (OH)

Hybrid
USD 25,000 - 39,000
Tuition reimbursement
Paid time off
401(k) plan with company match
+1
Data ITSM Analyst Intern - Hybrid, Summer 2027
Data ITSM Analyst Intern - Hybrid, Summer 2027

Great American Insurance Company • Cincinnati (OH)

Hybrid
USD 28,000 - 34,000
Medical, dental, and vision coverage
Wellness plans
Paid time off and holidays
+3