Lead Data Engineer/Data Engineer

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. Come join a #1 team and do some good!

Responsibilities

Job Overview

The 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 environments Engaging in the Enterprise Claim System (ECS) modernization effort, serving as a bridge between the existing data environment and the modernized environment being developed Contributing to the identification, development, and support of services, utilities, and tooling required to manage and maintain claims data on Aurora Postgres Utilizing industry-adopted languages and frameworks in coding, testing, security, DevOps, DataOps and data engineering practices Developing and maintaining reusable, scalable, and compliant data solutions across multiple platforms and compute environments Establishing business domain knowledge for existing State Farm data sources – specifically those in ET P&C Claims Identifying and consulting on emerging technologies and critical core systems, including techniques, tools, data sources, and platforms in the data engineering field Exhibiting a DataOps mindset and leveraging automation to deliver quality data solutions Experimenting and prototyping solutions to aid in validating and informing technical direction

Qualifications

We 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 forward Demonstrate a growth mindset…you have a desire and passion for learning, and a willingness to enhance both your business and technical acumen Possess outstanding communication skills…you are eager to form new relationships, enjoy collaborating across teams, departments, and locations, and can influence others Previous experience (2-3 years) working as a data engineer or in a related role General 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 Postgres Working 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 management Experience with version control, automated testing, and CI/CD pipelines to enable repeatable and efficient deployment of changes to data schemas and infrastructure Experience with enterprise data migrations/ modernization efforts would be a plus