Data Engineer

Summit Consulting; Cincinnati (OH); On-site; USD 110,000 - 150,000; Full time

Benefits offered by this job

Medical coverage

Dental coverage

Vision coverage

Wellness plans

Parental leave

Tuition reimbursement

Paid time off

Paid holidays

401(k) match

Employee stock purchase plan

Commuter benefits

Job summary

Great American Insurance Group is seeking a Data Engineer to join the Business Data and Analytics team in Cincinnati. You will transform structured and unstructured data into advanced analytics solutions and collaborate with cross-functional teams to deliver scalable pipelines and AI-enabled insights.

On-site four days a week with one remote day, you will contribute to modernizing data platforms, improve data governance, and support predictive analytics initiatives in a collaborative,

Qualifications

• Bachelor’s degree in IT, CS, or related field.
• Proficiency in Python, SQL, and R.
• Experience with cloud platforms and ETL/ELT tools.
• Experience with Generative AI tools.
• Knowledge of data modeling and governance.
• Strong communication and problem-solving skills.

Responsibilities

• Design, develop, and maintain scalable data pipelines and data architectures (Snowflake).
• Build and optimize ETL/ELT processes to ingest and transform data for analytics use cases.
• Automate recurring operational reporting and improve efficiency.
• Support data engineering needs for predictive analytics and ML initiatives.
• Assist in migrating legacy systems to cloud-based data architectures and standardize processes.

Skills

Python

SQL

R

Cloud platforms

ETL/ELT

Generative AI tools

Data modeling

Data governance

Tableau

Education

Bachelor’s degree in IT/CS/SE

Tools

Informatica

Snowflake

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.

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

Predictive Analytics 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.

Great American’s culture is built on connection, shared learning, and strong relationships.

To support this, 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.

Essential Job Functions and 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

Job Requirements

Education: Bachelor’s degree in Information Technology, Computer Science, Software Engineering, or a related field.

Scope of Job/Qualifications:

• 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
• Maintain an understanding of machine learning concepts and their software engineering implications
• Knowledge of data modeling, data architecture, and data governance
• Provide technical expertise across a range of applications, systems, and technologies
• 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
• Experience working with enterprise data systems or policy/insurance data platforms is a plus
• Familiarity with workflow orchestration tools (e.g., UC4 or similar schedulers) is a plus
• Data visualization development/design experience (Tableau Preferred) is a plus

Business Unit: Business Data and Analytics

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

*Excludes seasonal employees and interns.

Your recruiter will provide details about benefits and specific compensation ranges during the hiring process. Learn more at http://www.gaig.com/careers.

Great American Insurance Group understands the importance of choosing a financially strong company. We are an organization built for the long term and are committed to giving you that strength. Why can you trust Great American Insurance Group? For nearly 150 years, Americans have trusted us to protect them. Our innovative insurance solutions and specialization serves niche marketplaces that we know well. This expertise gives us a successful foundation that spans generations. You never know where a career in insurance will take you. Whether you are starting your career or are looking for a company to grow your experience, at Great American Insurance Group, you can join our more than 8,500 employees to "Be Here. Be GREAT!" To learn more, visit our Career Page