Lead Data Engineer/Data Engineer

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.