Lead Data Engineer

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

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.

Responsibilities

State Farm (Bloomington, IL) seeks a Lead Data Engineer to help migrate, build, and service Analytics environments with a particular concentration on cloud based environments as well as other emerging technologies and capabilities. Specific duties include: apply skills, tools, security processes, applications, environments and programming language(s) to complete complex assignments; apply advanced engineering practices to design data solutions using industry-adopted languages and frameworks; diagnose and resolve complex problems/issues; maintain advanced understanding in software engineering topics, including classes, functions, security, containers, version control, CI/CD, and unit tests; maintain advanced understanding in programming, and database and data storage functionality and apply that understanding to build reusable data solutions; maintain advanced understanding in compute environments, including but not limited to Linux, Public Cloud, and containers; maintain advanced understanding in data engineering topics, including ETL (Extract, Transform, Load), data integration, reusable data pipelines, data management, data analytics, data visualization, and data science; maintain advanced business domain expertise for data sources and applies in recommendations, designs, and execution of data solutions; apply advanced understanding regarding data and technology trends/changes, best practices, and processes to complete assignments and influence the direction of product solutions; apply advanced understanding of product design, data design and movement and test to ensure quality outcomes; leverage an advanced understanding of the State Farm organizational structure to navigate the organization; provide mentorship, technical guidance, training, and may delegate work to others; possibly take on several simultaneous work stories or focus on a single complex story; understand, support, and help define the vision and direction for the product development; and possibly have membership and engage with technical groups in the organization; leverage inner source best practices to encourage code discoverability and collaboration across the enterprise. Option for hybrid work environment, allowing work from home with required travel to local office at least once per quarter. Required to live within 180 miles of local office and within the United States.

Qualifications

Position requires a Bachelor’s degree, or foreign equivalent, in Computer Science, Information Systems Security, or a closely related field of study, plus 5 years of experience in the job offered, or as a Software Developer, Associate – Projects, or similar technical architectural position. Specific experience must include: gaining enterprise data domain knowledge, including rating, underwriting, and/or claims, rapidly; working with programming languages, including Java, Python, Spark, Terraform, Angular 7, React JS, JavaScript, and jQuery; working with AWS services, including (AWS Glue, Lambda, SQS, SNS, Cloud Watch, S3, Event Bridge, RDS, EC2); working with various databases, including AWS Redshift, S3, AWS DynamoDB, DB2, Postgres, Oracle, MS SQL, and MongoDB; developing solutions on AWS Redshift and S3; working with version control, including GitHub, GitLab, Jenkins, Docker, IDE like PyCharm, STS, eclipse, vs code); learning and adopting new technologies and languages; and using critical thinking skills to challenge current thinking and applying the right technology to solve problems. Option for hybrid work environment, allowing work from home with required travel to local office at least once per quarter. Required to live within 180 miles of local office and within the United States. Salary: $150,592/yr.

Our Benefits

Because work-life balance is a priority at State Farm, compensation is based on our standard 38:45-hour work week!

At State Farm, we offer more than just a paycheck. Check out our suite of benefits designed to give you the flexibility you need to take care of you and your family!

• Get Paid! On top of our competitive pay, you are eligible for an annual raise and bonus.
• Stay Well! Focus on you and your family’s health with our robust health and wellbeing programs. State Farm pays most of your healthcare premium, and we offer multiple healthcare plan options, including a high deductible plan. All medical plans provide 100% coverage for in-network preventative care, AND you and your family have access to vision, dental, telemedicine, 24/7 mental health professionals, and much more!
• Develop and Grow! Take advantage of educational benefits like industry leading training programs, top-notch tuition assistance programs, employee resource groups, and mentoring.
• Plan Ahead! Plan for those big moments in life with benefits like fertility/IVF/adoption assistance, college coaching, national discount programs, interactive monthly financial workshops, free financial coaching, and more. You can also start a savings account or consider financing through our State Farm Federal Credit Union!
• Take a Little “You” Time! You will have access to our generous time off policies designed so you can plan around holidays, family events, volunteering, or just to take a relaxing day off. With the opportunity to initially earn up to 20 days annually plus parental leave, paid holidays, celebration day, life leave (40 hours/year), bereavement leave, and community service/education support days, there will be plenty of time for you!
• Give Back! We offer several ways to give back through our Matching Gift Program, Good Neighbor Grant Program, and the Employee Assistance Fund.
• Finish Strong! Plan for retirement using free financial advisors and a 401(k) plan with company contributions of up to 7% of your salary.

Visit our State Farm Careers page for more information on our benefits, locations, and the hiring process of joining the State Farm team!

#LI-DNI