Data Automation Intern - Summer 2027

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

Benefits offered by this job

Medical coverage

Dental coverage

Vision coverage

Parental leave

Tuition reimbursement

401(k) with match

Paid time off

Job summary

Great American Insurance Group is seeking a Data Automation Intern for summer 2027 in Cincinnati, OH. The role focuses on building Python-based automation, leveraging AI-assisted tools, and collaborating with Data Engineering and DevOps teams to streamline data workflows.

You will gain hands-on experience in modern development practices, CI/CD, and documentation while delivering practical automation solutions with business impact.

Qualifications

• Basic programming experience, preferably Python.
• Foundational understanding of software development concepts.
• Interest in AI, automation, data engineering or DevOps.
• Willingness to learn modern development and data technologies.
• Strong problem-solving and analytical skills.
• Good verbal and written communication.

Responsibilities

• Develop automation solutions and utilities using Python.
• Use AI development tools like GitHub Copilot, OpenSpec and Claude to assist with coding, testing, documentation, code review, and automation.
• Help automate data workflows, pipelines, monitoring, alerting, validation, and repetitive engineering tasks.
• Work with Data Engineering and other technology teams to understand processes and identify automation opportunities.
• Participate in the design, development, testing, and documentation of automation solutions.
• Learn and apply software development, DevOps, and automation best practices.
• Participate in team discussions, demonstrations, and knowledge sharing.

Skills

Python

Problem-solving

Communication

Teamwork

Analytical thinking

Curiosity

Education

CS / Data Science / AI (or related)

Tools

GitHub Copilot

OpenSpec

Claude

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 Data Auto-Magicians team is seeking a Data Automation Intern for summer 2027. This team is focused on advancing automation across the Data organization. The team works across Platform Automation and DevOps and uses technologies including Python, GitHub, Azure, Snowflake, and Informatica.

The Data Automation Intern will work alongside experienced engineers to identify manual or repetitive processes and help develop practical automation solutions. A key focus of the internship will be using Python and AI-assisted development tools to automate data engineering and operational workflows. The intern will gain hands-on experience applying modern development and AI technologies to real-world data and engineering problems.

Responsibilities:

• Develop automation solutions and utilities using Python.
• Use AI development tools like Github Copilot, OpenSpec and Claude to assist with coding, testing, documentation, code review, and automation.
• Help automate data workflows, pipelines, monitoring, alerting, validation, and repetitive engineering tasks.
• Work with Data Engineering and other technology teams to understand processes and identify automation opportunities.
• Participate in the design, development, testing, and documentation of automation solutions.
• Learn and apply software development, DevOps, and automation best practices.
• Participate in team discussions, demonstrations, and knowledge sharing.

The team's current work already includes AI-assisted code review, CI/CD and deployment automation, code validation, monitoring, security scanning, Python applications, and AI skills/prompts for engineering tasks.

Expected outcomes may include:

• A working Python-based automation solution or enhancement.
• Automation of one or more manual data-engineering or operational processes.
• Documentation explaining the solution and how it can be supported or extended.
• Testing and demonstration of completed work.
• A final presentation or demonstration highlighting the problem, solution, technology used, and business/technical value delivered.

Requirements:

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

Education:

• Pursuing a degree in Computer Science, Data Science, Artificial Intelligence / Machine Learning or related
• 2028 or 2029 graduation year

Experience/skills:

• Basic programming experience, preferably Python.
• Foundational understanding of software development concepts.
• Interest in AI, automation, data engineering or DevOps.
• Willingness to learn modern development and data technologies.Willingness to learn modern development and data technologies.
• Strong problem-solving and analytical skills.
• Good verbal and written communication.
• Ability to work collaboratively with engineers and other technology teams.
• Curiosity and willingness to learn new technologies.
• Ability to take a problem from initial understanding through a working solution.

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.