Lead Data Engineer – Cloud, Analytics & Mentorship

State Farm; Bloomington (IL); Hybrid; USD 140,000 - 170,000; Full time

Benefits offered by this job

Annual raise & bonus

Healthcare & wellness programs

Tuition assistance

Job summary

State Farm in Bloomington, IL is seeking a Lead Data Engineer to design and migrate analytics environments in cloud-based platforms. You will build, service, and optimize data solutions, apply engineering best practices, and mentor junior engineers in a hybrid work model with quarterly travel.

The role requires a Bachelor's in CS or related field with 5+ years of experience, strong Java/Python/Spark, AWS services, and data warehouse expertise across Redshift, DynamoDB, and SQL databases.

Qualifications

• Bachelor’s degree in Computer Science, Information Systems Security, or a closely related field, plus 5 years of experience in software development or data engineering.
• Proficient with Java, Python, Spark, Terraform, Angular 7, React JS, JavaScript, and jQuery.
• Experience with AWS services (Glue, Lambda, SQS, SNS, CloudWatch, S3, EventBridge, RDS, EC2) and databases (Redshift, DynamoDB, DB2, Postgres, Oracle, MS SQL, MongoDB).
• Knowledge of version control (GitHub, GitLab), CI/CD (Jenkins), and containers (Docker).
• Ability to learn new technologies, think critically, and apply the right tool for complex data problems.

Responsibilities

• Migrate, build, and service analytics environments with a focus on cloud platforms and emerging technologies.
• Design data solutions using industry-standard languages and frameworks; diagnose and resolve complex issues.
• Maintain and improve data engineering concepts including ETL, data integration, data pipelines, and data storage.
• Provide mentorship, technical guidance, and training; support multiple work stories and product direction.
• Hybrid work option with quarterly travel to local office; reside within 180 miles of the local office.

Skills

Java

Python

Spark

Angular 7

React JS

JavaScript

jQuery

Terraform

Education

Bachelor's degree in Computer Science or related field

Tools

AWS Glue

Lambda

SQS

SNS

CloudWatch

S3

EventBridge

RDS

EC2

Redshift

DynamoDB

DB2

Postgres

Oracle

MS SQL

MongoDB

GitHub

GitLab

Jenkins

Docker

PyCharm

STS

Eclipse

VS Code

Git

Job description

State Farm in Bloomington, IL is seeking a Lead Data Engineer to design and migrate analytics environments in cloud-based platforms. You will build, service, and optimize data solutions, apply engineering best practices, and mentor junior engineers in a hybrid work model with quarterly travel.

The role requires a Bachelor's in CS or related field with 5+ years of experience, strong Java/Python/Spark, AWS services, and data warehouse expertise across Redshift, DynamoDB, and SQL databases.