Lead Data Engineer - AWS & DB2 Modernization (Hybrid)

State-Farm-319b4913; Bloomington (IL); Hybrid; USD 86,000 - 124,000; Full time

Benefits offered by this job

Annual raise & bonus

Healthcare coverage

Tuition assistance

401(k) plan with company contributions

Generous time off

Job summary

State Farm is seeking a Data Engineer/Lead Data Engineer in Bloomington, IL for a hybrid role blending in-office and remote work. The team focuses on modernizing Property & Casualty data and building scalable data pipelines on AWS, shifting workloads from legacy Mainframe to cloud platforms.

You will design and implement reliable data pipelines, collaborate with cross-functional teams, and drive data quality, security, and performance in a fast-paced enterprise environment.

Qualifications

• Minimum data engineering experience with data pipelines and cloud migrations.
• Experience with AWS data services and ETL tooling.
• Strong SQL and data modeling skills.
• Ability to work cross-functionally and in a fast-paced environment.

Responsibilities

• Build and maintain reliable data pipelines from legacy systems to AWS.
• Collaborate across teams to deliver scalable data lake solutions.
• Support data modernization and reduce technical debt.
• Ensure data security, compliance, and operational reliability.

Skills

Python/Scala/Java

SQL/ETL

AWS data services

Data pipeline design

Security & compliance

Tools

Glue

EMR Serverless

S3

Athena

Redshift

Iceberg

OpenTofu (Terraform)

Job description

State Farm is seeking a Data Engineer/Lead Data Engineer in Bloomington, IL for a hybrid role blending in-office and remote work. The team focuses on modernizing Property & Casualty data and building scalable data pipelines on AWS, shifting workloads from legacy Mainframe to cloud platforms.

You will design and implement reliable data pipelines, collaborate with cross-functional teams, and drive data quality, security, and performance in a fast-paced enterprise environment.