Claims Technical Intern

Great American Insurance Company; Cincinnati (OH); Hybrid; USD 21,000 - 28,000; Full time

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

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 and recognize the benefits derived when people with different backgrounds and experiences work together to achieve business results. Our goal is to create a workplace where all employees feel included, empowered, and enabled to perform at their best.

P&C IT Services provides professional services to help our business units and corporate functions use technology to create, manage, and optimize information and business processes. IT Services can include a wide range of activities such as: software development, data management, Cloud services, IT security, network security, technical support, establishing and overseeing access rights, procuring and maintaining equipment or software, managing the infrastructure, and defining security procedures, The overall goal of IT Services is to provide technology solutions that increase efficiency, reduce costs, and give our company a competitive advantage over our competitors.

Great American’s culture is built on connection, shared learning, and strong relationships. This is a hybrid role that combines in-office and remote work. Employees are expected to maintain a meaningful on-site presence to support collaboration, relationship building, and business success.

The Claims Management team is seeking an intern for the summer 2027.

The intern will join a team of technical analysts, Data Push developers, and an intern who support a Claims system. The conversion team moves data from legacy systems, Snowflake, and other sources into Guidewire ClaimCenter, while the backend team is responsible for processing claims data into the Data Warehouse, Data Lake, and Snowflake.

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

Requirements:

Ability to work in the office at minimum three days a week.

Education:

• Pursuing a degree in Data Analytics or related
• 2028 or 2029 graduation year

Experience/skills:

• 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

Business Unit:

Property & Casualty IT Services

Benefits:

We offer competitive benefits packages for full-time and part-time employees*. Full-time employees have access to medical, dental, and vision coverage, wellness plans, parental leave, adoption assistance, and tuition reimbursement. Full-time and eligible part-time employees also enjoy Paid Time Off and paid holidays, a 401(k) plan with company match, an employee stock purchase plan, and commuter benefits.

Compensation varies by role, level, and location and is influenced by skills, experience, and business needs. Your recruiter will provide details about benefits and specific compensation ranges during the hiring process. Learn more at http://www.gaig.com/careers.

*Excludes seasonal employees and interns.