Lead Data Engineer/Data Engineer

MainframeMaster; Bloomington (IL); On-site; USD 97,000 - 160,000; Full time

Job summary

State Farm is hiring a Lead Data Engineer in Bloomington, Illinois, to support and modernize claims data management using AWS. The ideal candidate will have 2-3 years of data engineering experience, a strong knowledge of Db2, PostgreSQL, and programming languages like Python. The role emphasizes collaboration across teams and embracing emerging technologies in data solutions. Competitive salary range is offered, reflecting market standards.

Qualifications

• 2-3 years of experience as a data engineer or in a related role.
• General knowledge of mainframe and relational database concepts.
• Experience managing and supporting enterprise data on Db2/PostgreSQL.

Responsibilities

• Manage and support claims data on IBM Db2 and other databases.
• Engage in ECS modernization and data management solutions.
• Utilize industry-adopted languages for data engineering practices.

Skills

Data engineering

DB2

SQL

PostgreSQL

Python

Data DevOps

GitHub/GitLab

Tools

AWS

Flyway

Liquibase

Job description

# Lead Data Engineer/Data EngineerState FarmInternshipBloomington, United StatesUSD 97,000 - 160,0002 viewsPosted May 9, 2026## Job DescriptionJob DescriptionOverviewBeing 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. Come join a #1 team and do some good!ResponsibilitiesJob OverviewThe Central Claims Data product is seeking a motivated individual to join our team of experienced data engineers and designers/administrators. In addition to supporting and maintaining the claims data residing on the current platforms, this individual will have an opportunity to engage in a multi-year modernization effort focused on hosting the Enterprise Claims System (ECS) application and its associated database on the Amazon Web Services (**AWS**) platform. If your seeking challenging work and have a desire to research and build creative data services and solutions in support of our future direction, then please consider joining our team.As a Data Engineer on the team, your responsibilities will include:Collaborating with peers to manage and support the claims data residing on IBM **Db2** and the tooling, applications, and services leveraged to administer the data, database, and tables in the TEST and Production environmentsEngaging in the Enterprise Claim System (ECS) modernization effort, serving as a bridge between the existing data environment and the modernized environment being developedContributing to the identification, development, and support of services, utilities, and tooling required to manage and maintain claims data on Aurora PostgresUtilizing industry-adopted languages and frameworks in coding, testing, security, DevOps, DataOps and data engineering practicesDeveloping and maintaining reusable, scalable, and compliant data solutions across multiple platforms and compute environmentsEstablishing business domain knowledge for existing State Farm data sources – specifically those in ET P&C ClaimsIdentifying and consulting on emerging technologies and critical core systems, including techniques, tools, data sources, and platforms in the data engineering fieldExhibiting a DataOps mindset and leveraging automation to deliver quality data solutionsExperimenting and prototyping solutions to aid in validating and informing technical direction## Requirements & SkillsQualificationsWe are seeking individuals who...Thrive in new and/or uncertain environments...you are a self-starter with a bias towards leading and action, and capable of finding a path to move forwardDemonstrate a growth mindset...you have a desire and passion for learning, and a willingness to enhance both your business and technical acumenPossess outstanding communication skills...you are eager to form new relationships, enjoy collaborating across teams, departments, and locations, and can influence othersPrevious experience (2-3 years) working as a data engineer or in a related roleGeneral understanding and knowledge of mainframe and relational database concepts, database performance, **COBOL**, **JCL**, Stored Procedures, and **SQL**Experience managing and supporting enterprise data on **Db2**, **PostgreSQL**, and/or Aurora PostgresWorking knowledge of programming languages (i.e. **Python**) and version control tools (**GitHub**/**GitLab**)Experience with Data DevOps – utilizing scripts and products such as Flyway or Liquibase to automate aspects of database managementExperience with version control, automated testing, and CI/CD pipelines to enable repeatable and efficient deployment of changes to data schemas and infrastructureExperience with enterprise data migrations/ modernization efforts would be a plus## How to ApplyApply directly through the application link above