Data Engineer

About the role

Great American Insurance Group’s Predictive Analytics team is seeking a Data Engineer to join our Business Data and Analytics department. In this role, you’ll collaborate with claim and underwriting professionals, product managers, data scientists, actuaries, and IT professionals to transform structured and unstructured data into advanced analytics solutions. We’re looking for someone with strong technical expertise, keen attention to detail, and adaptability. The ideal candidate thrives in problem-solving, communicates effectively, and enjoys working in a collaborative, team-oriented environment.

To support our culture of connection, shared learning, and strong relationships, 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.

Responsibilities

• Design, develop, and maintain scalable data pipelines and data architectures, primarily leveraging cloud-based platforms such as Snowflake
• Build and optimize ETL/ELT processes to ingest, transform, and integrate data from internal systems and external data sources, ensuring data is readily available for analytics use cases
• Automate recurring operational reporting processes to improve efficiency, reliability, and reduce manual effort
• Support data engineering needs for predictive analytics and machine learning initiatives, including feature engineering, data preparation, and model enablement
• Assist in modernizing data platforms by supporting migration from legacy systems to cloud-based data architectures
• Identify and implement opportunities for process improvements, automation, and standardization
• Provide advanced technical support to end users and team members by resolving data-related issues in a timely manner
• Serve as a trusted advisor in the development of predictive analytics, AI, generative AI, and machine learning models
• Engage, as needed, with our AI Automation Hub, AI Innovation Lab, AI Champions, and delivery teams to develop and implement high-impact AI solutions
• Collaborate with data analysts, data scientists, and other stakeholders to understand data requirements and deliver solutions
• Perform other duties as assigned

Requirements

• Bachelor’s degree in Information Technology, Computer Science, Software Engineering, or a related field
• Demonstrates proficiency in multiple programming languages (Python, SQL, R, etc.)
• Experience with cloud platforms and modern development frameworks
• Hands-on experience with ETL/ELT tools (e.g., Informatica or similar technologies)
• Experience building and maintaining data pipelines for structured and semi-structured data
• Experience with Generative AI tools and agentic coding
• Maintain knowledge of industry trends and technologies to continuously improve data engineering solutions
• Understanding of machine learning concepts and their software engineering implications
• Knowledge of data modeling, data architecture, and data governance
• Analytical and problem-solving skills, with the ability to troubleshoot complex software issues
• Demonstrates knowledge of department policies and procedures, as well as the business and organization
• Ability to communicate, develop, and leverage strategic business relationships across the organization and externally

Preferred Qualifications

• Experience working with enterprise data systems or policy/insurance data platforms
• Familiarity with workflow orchestration tools (e.g., UC4 or similar schedulers)
• Data visualization development/design experience (Tableau preferred)

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 and adoption assistance
• Tuition reimbursement
• Paid Time Off and paid holidays
• 401(k) plan with company match
• Employee stock purchase plan
• Commuter benefits

Eligible part-time employees also enjoy Paid Time Off and paid holidays, a 401(k) plan with company match, and the employee stock purchase plan.

*Excludes seasonal employees and interns.

Pay

Compensation varies by role, level, and location and is influenced by skills, experience, and business needs. Your recruiter will provide details about specific compensation ranges during the hiring process.

Schedule

This role requires on-site presence four days a week (Tuesday–Thursday, plus one additional day determined by business needs) with the flexibility to work one day remotely.

Applicants must be authorized to work in the United States without the need for current or future sponsorship. This position is not eligible for employment visa sponsorship.