Claims Technical Analyst Intern

Great American Insurance Group

. Create and maintain documentation such as user stories, process flows, and requirements .

Posted 11/10/2026part-timeCincinnati • Ohio • United StatesEntry LevelWebsite

Core Competencies

Role fit

Core Competencies

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

Demonstrates strong capabilities in data analysis, SQL query writing, and application testing while effectively collaborating with technical teams to support claims processing and data integration efforts.

Highest-signal resume keywords

SQL Query WritingData AnalysisApplication TestingMicrosoft Office ProficiencyData Conversion

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

Data AnalysisSQL Query WritingApplication TestingData ConversionDocumentation CreationProcess Flow DevelopmentIntegration MappingData CorrectionClaims ProcessingData Modeling

Soft Skills

Effective CommunicationInterpersonal SkillsIndependent WorkCollaborative Work

Tools & Technologies

Microsoft Office SuiteGuidewire ClaimCenterSnowflakeData WarehouseData Lake

Industry Keywords

Claims SystemData AnalyticsLegacy SystemsData MappingData Push

Tech Stack

Tools & technologies

GuidewireSnowflakeSQL

About the role

Key responsibilities & impact

Create and maintain 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 requests for downstream mapping
Assist with application testing
Support the Claims system alongside technical analysts, Data Push developers, and another intern
Contribute to data conversion from legacy systems, Snowflake, and other sources into Guidewire ClaimCenter
Support processing claims data into the Data Warehouse, Data Lake, and Snowflake

Requirements

What you’ll need

Pursuing a degree in Data Analytics or related field
2028 or 2029 graduation year
Ability to work in the office at minimum three days a week
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

Benefits

Comp & perks

Medical, dental, and vision coverage (full-time employees)
Wellness plans (full-time employees)
Parental leave (full-time employees)
Adoption assistance (full-time employees)
Tuition reimbursement (full-time employees)
Paid Time Off (full-time and eligible part-time employees)
Paid holidays (full-time and eligible part-time employees)
401(k) plan with company match (full-time and eligible part-time employees)
Employee stock purchase plan (full-time and eligible part-time employees)
Commuter benefits (full-time and eligible part-time employees)