Lead Data Engineer — Hybrid, AWS & Data Lakes

ITSMF; 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

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,