Lead Data Engineer - Mainframe - Remote

Lead Data Engineer - Mainframe - Remote

US-IL-Bloomington

Job ID:

2024-36563
Type:

Regular Full Time
# of Openings:

1
Category:

Technology and UX
Bloomington, IL

Overview

We are not just offering a job but a meaningful career! Come join our passionate team!
As a Fortune 50 company, we hire the best employees to serve our customers, making us a leader in the insurance and financial services industry. State Farm embraces diversity and inclusion to ensure a workforce that is engaged, builds on the strengths and talents of all associates, and creates a Good Neighbor culture.
We offer competitive benefits and pay with the potential for an annual financial award based on both individual and enterprise performance. Our employees have an opportunity to participate in volunteer events within the community and engage in a learning culture. We offer programs to assist with tuition reimbursement, professional designations, employee development, wellness initiatives, and more!
Visit our Careers page for more information on our , and of joining the State Farm team!
HUB LOCATIONS : Dunwoody, GA; Richardson, TX; Tempe, AZ or Bloomington, IL
HYBRID : Qualified candidates (in or near hub locations listed below) should plan to spend time working from home and some time working in the office as part of our hybrid work environment.
Hybrid work arrangement for Enterprise Technology is defined as residing with a 180-mile radius of the Hubs and Corporate.
REMOTE : Qualified candidates (outside of hub locations listed below) may be considered for 100% remote work arrangements based on where a candidate currently resides or is currently located.
SPONSORSHIP : Applicants are required to be eligible to lawfully work in the U.S. immediately; employer will not sponsor applicants for U.S. work authorization (e.g., H-1B visa) for this opportunity.
Responsibilities

Powering the Promise. Every day, thousands of P&C Claim associates use claim applications to keep the promise we have made to help customers recover from the unexpected. All these Claim applications leverage lots of data. We provide data services which are essential for enabling Claim associates to keep the State Farm promise.
We are a centralized data team, responsible for a broad data ecosystem and a significant amount of distributed data. Our team supports a wide range of technologies, from traditional mainframe to emerging cloud technologies. We also provide a wide range of services and therefore a variety of responsibilities and assignments in which to be involved.
We are enthusiastic professionals-enthusiastic about data and equally passionate about helping others. Join the Claims data team and help Power the Promise for State Farm!
Central Claims Data team is seeking an experienced Data Engineer to develop and maintain data applications. As part of the Central Claims Data team, you will:
Develop & deploy & support data model changes/conversions for host Db2.
Build & maintain Enterprise Claims System DBA mainframe tooling.
Monitor Db2 performance and support/troubleshoot claims data issues in Test and Production
Develop & support data deployment pipelines for Enterprise Claim System/AWS data flows.
Qualifications

Db2 z/OS knowledge, particularly experience in & affinity for performance tuning & troubleshooting
Familiarity with data replication concepts & host development tools, preferably REXX, QlikReplicate
AWS data services & scripting, preferred but not required -- RDS, Gitbash, Git pipelines, Terraform
***SPONSORSHIP:

Applicants are required to be eligible to lawfully work in the U.S. immediately; employer will not sponsor applicants for U.S. work authorization (e.g., H-1B visa) for this opportunity.***
SFARM
#LI-LP1
#LI-Hybrid
#LI-Remote
Please see job description

PI240192359

#J-18808-Ljbffr