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 benefits, locations and the process 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.

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.

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 passionate professionals—passionate 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. In this assignment, you will acquire and leverage your knowledge of claims data to deliver data services for product teams and business. You will also work on a variety of technologies (mainframe, Linux, cloud) and databases (zOS Db2, Postgres, Salesforce) in providing data support. You will work with others to research and resolve issues with production data. You will also understand data governance and ensure solutions comply with data standards for data access, data quality, sensitive data. You will also develop and maintain the team’s work intake tool and help to automate data tasks for the team.

A day in the life of a Lead Data Engineer in Central Claims Data team could include:

• Creating and deploying stored procedures for claims applications
• Monitoring daily jobs and application logs and fixing any issues encountered
• Discussing possible data concerns with business and finding & fixing data as needed 
• Creating or updating data jobs to enable cloud modernization

Qualifications

Competitive candidates will bring proficiency in:

• COBOL & JCL, mainframe development processes, stored procedures
• SQL, finding and fixing data (zOS DB2 and Postgres)
• SQL/PL, maintaining stored procedures
• Python 
• Data Governance (sensitive data, data access, data quality)

Preferred skills:

• Working knowledge of DB2 security
• Django
• CI/CI pipelines (Git & Jenkins)
• Vault integration
• Salesforce (APEX)

**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**

For Los Angeles candidates: Pursuant to the Los Angeles Fair Chance Initiative for Hiring, we will consider for employment qualified applicants with criminal histories.

For San Francisco candidates: Pursuant to the San Francisco Fair Chance Ordinance, we will consider for employment qualified applicants with arrest and conviction records.

For Colorado candidates:

Salary Range: $91,870 - $193,500
Competitive Benefits, including:
401k Plan
Health Insurance
Dental/Vision plans
Life Insurance
Paid Time Off
Annual Merit Increases
Tuition Reimbursement
Health Initiatives
For more details visit our benefits summary page

SFARM

JT18

#LI-LP1

#LI-Remote

#LI-Hybrid

PM22