Mid-Level/Lead Data Engineer-AWS & DB2 (HYBRID)

Information Technology Senior Management Forum; Bloomington (IL); Hybrid; USD 110,000 - 160,000; Full time

Job summary

State Farm is seeking an experienced Data Engineer/Lead Data Engineer to join the Enterprise Technology Data team. The role focuses on building and maintaining data pipelines that extract data from legacy systems, modernize data workflows, and deliver enterprise data into AWS for analytics and downstream consumption.

You will collaborate across teams to design scalable data solutions, transition workloads from mainframe platforms to cloud architectures, and ensure data security, availability,

Qualifications

• Experience in data engineering practices and modern data architectures.
• Ability to design, deploy, support, and secure data assets for analytics.
• Experience with ETL, data integration, and data quality controls.
• Knowledge of cloud data platforms and enterprise data lake concepts.
• Ability to learn new technologies and languages and apply them.
• Experience with data movement from legacy environments to cloud.
• Strong collaboration across technical and business teams.

Responsibilities

• Engineer, maintain, and support reliable data pipelines from legacy systems to AWS.
• Support Data tool for z/OS platform and data modernization initiatives.
• Collaborate across teams to shape data solutions aligned to enterprise goals.
• Transition workloads from mainframe to cloud architectures while ensuring security and availability.
• Monitor daily processing, troubleshoot failures, perform root-cause analysis, and implement recovery procedures.
• Develop and support data movement from legacy environments into AWS, including daily delta processing.
• Apply continuous delivery practices and contribute to scalable, secure data architectures.

Skills

Data engineering

ETL

Cloud AWS

Data pipelines

Root-cause analysis

Cross-team collaboration

Agile

Tools

S3

Glue

Athena

Data Lake

Job description

Overview

Being good neighbors – helping people, investing in our communities, and making the world a better place – is who we are at State Farm. It is at the core of how we operate and the reason for our success. We're moving with urgency to become a Next Gen Good Neighbor, with technology that strengthens human connections and enhances the customer experience. As an employee, you'll spend less time navigating systems and more time applying judgment, empathy, and expertise in the moments that matter most.

Hybrid Work Arrangement:

A “Hybrid” position means selected candidates will be assigned to a facility and will spend some time working both in the office and from home. For Enterprise Technology, a hybrid work arrangement will require approximately 40% in‑office time each month, beginning in late 2027.

HUB LOCATION: Bloomington, IL, Richardson, TX

SPONSORSHIP:

Applicants for this position are required to be eligible to lawfully work in the U.S. immediately; employer will not sponsor applicants for U.S. work authorization (e.g. H-1B visa) for this opportunity.

Responsibilities

The Property & Casualty Data team is seeking an experienced Data Engineer/Lead Data Engineer to join us! The Data Engineer will support the Property & Casualty Data tool for z/OS platform and associated data modernization initiatives. This role is responsible for engineering, maintaining, and supporting reliable data pipelines that extract data from legacy systems, make it available through tools, and deliver enterprise data into AWS for analytics and downstream consumption.

This role plays an important part in the continued modernization of Property & Casualty data capabilities, helping transition critical data from legacy platforms to scalable cloud‑based solutions while maintaining data accuracy, availability, security, and operational reliability. This position sits within Enterprise Technology and offers the opportunity to work in a highly collaborative environment focused on delivering meaningful business impact. You will partner across teams, solve complex data challenges, and help shape modern data solutions aligned to enterprise goals. It is a strong fit for someone who wants to expand their technical skills, work on high‑visibility initiatives, and contribute in a fast‑moving, innovative setting.

This is a great opportunity to apply skills in S3, Glue, Athena, and enterprise data lake capabilities to create secure, scalable, and maintainable data solutions to simplify legacy processing, improve performance, automate operational activities, reduce technical debt, and transition appropriate workloads from Mainframe‑based solutions to modern cloud architectures.

What’s in It for You

• Opportunity to work with innovative technologies across multiple business areas
• Ability to contribute to new concepts and designs
• Being part of a self-empowered team
• Access to customizable skill‑level and personal development training
• Opportunity to research and influence the development of new and experimental products
• Influence solution designs with a focus on performance, risk mitigation, and supportability
• Flexible work schedules to support work‑life balance

Qualifications

We Are Seeking Candidates With:

• Utilizes industry‑adopted languages and frameworks in coding, testing, security and data engineering practices
• Collects and analyzes information to identify customers’ technical needs, suggest solutions and develop implementation and integration plans (e.g., technical proposals)
• Responsible for the analysis, design, deployment, support, and security of technology to ensure the organization is efficiently managing its technology and data‑related assets in accordance with market best‑practices and external regulations
• Applies a wide application of complex principles, theories, and concepts in computer science for data engineering solutions
• Ability to learn and adopt new technologies and languages.
• Responsible for the identification, acquisition, cleansing, profiling, and ETL (extracting, transformation, and loading) of data used in analytic discovery and production solution deployment across multiple platforms
• Identify opportunities to simplify legacy processing, improve performance, automate operational activities, reduce technical debt, and transition appropriate workloads from Mainframe‑based solutions to modern cloud architectures.
• Ability to identify and apply industry‑standard solutions to complex problems
• Monitor daily processing, troubleshoot failures, perform root‑cause analysis, implement recovery procedures, and develop long‑term solutions that reduce manual intervention and improve operational reliability.
• Develop and support data movement from legacy environments into AWS, including daily delta processing and cloud‑based data consolidation.
• Commitment and experience with continuous delivery practices
• Collaborative mindset to engage effectively with team members from diverse technical and business backgrounds
• Agility to quickly adapt to evolving environments