DB2 Data Jobs

1 job found

2mo ago

Lead Data Engineer/Data Engineer

State Farm Mutual Automobile Insurance Company Bloomington, IL

Bloomington, IL

2mo ago Closed

$97k - $160k/yr Full time Amazon Aurora Postgresql Cloud Operations COBOL

This position is no longer accepting applications (closed Jun 15, 2026).

Job Description

State Farm's Central Claims Data team is seeking a Lead Data Engineer / Data Engineer in Bloomington, IL (hybrid) to support IBM Db2 claims data and contribute to ECS modernization on AWS.

Responsibilities

Collaborate with peers to manage and support IBM Db2 claims data and the tooling, applications, and services used to administer the data, database, and tables in TEST and Production environments.
Serve as a bridge in the Enterprise Claim System (ECS) modernization effort between the current data environment and the target modernized environment.
Identify, develop, and support services, utilities, and tooling needed to manage and maintain claims data on Aurora Postgres.
Apply industry standard languages and frameworks across coding, testing, security, DevOps, DataOps, and data engineering practices.
Develop and maintain reusable, scalable, and compliant data solutions across multiple platforms and compute environments.
Establish business domain knowledge for existing State Farm data sources in ET P&C Claims.
Identify emerging technologies and core systems, including techniques, tools, data sources, and platforms in the data engineering field.
Demonstrate a DataOps mindset and leverage automation to deliver quality data solutions.
Prototype and experiment to validate technical direction and inform decision making.

Requirements

Thrive in new or uncertain environments; a self-starter with a bias toward leadership and action, able to chart a path forward.
Growth mindset with a passion for learning and expanding both business and technical acumen.
Outstanding communication skills; eager to form relationships, collaborate across teams, and influence others.
2-3 years of experience as a data engineer or in a related role.
Foundational understanding 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 Postgres.
Working knowledge of programming languages such as Python and version control tools (GitHub/GitLab).
Experience with Data DevOps, including automation of database management using Flyway or Liquibase.
Experience with version control, automated testing, and CI/CD pipelines to enable repeatable deployments of data schemas and infrastructure.
Experience with enterprise data migrations or modernization efforts is a plus.

Technologies

IBM Db2
Aurora Postgres
PostgreSQL
Python
GitHub
GitLab
Flyway
Liquibase
AWS
COBOL
JCL
SQL
Stored Procedures

Benefits

Salary range: USD 97,000 - 160,000 per year; starting salary based on skills, background, and experience; higher end reserved for substantial relevant experience.
Potential annual incentive pay up to 18% of base salary.
Health and wellbeing programs with State Farm paying most healthcare premiums; multiple plan options including high deductible; 100% coverage for in-network preventative care; access to vision, dental, telemedicine, 24/7 mental health professionals, and more.
Educational benefits including industry leading training programs, tuition assistance, employee resource groups, and mentoring.
Fertility/adoption assistance, college coaching, national financial workshops, free financial coaching, and access to savings accounts or the State Farm Federal Credit Union.
Generous time off and leave policies, including up to 20 days of initial paid time off, parental leave, paid holidays, life leave, bereavement leave, and community service/education support days.
Matching Gift Program, Good Neighbor Grant Program, and Employee Assistance Fund support for giving back.
401(k) plan with company contributions up to 7% of salary and access to free financial advisors for retirement planning.

Work Arrangements

Hybrid work arrangement: selected candidates will split time between an assigned facility and remote work; arrangements may evolve with business needs.

Sponsorship

Applicants must be eligible to work in the United States immediately; State Farm does not sponsor work visas for this role.

View full job page →

Get DB2 Data Jobs alerts

New DB2 Data Jobs, daily.