Data Engineer

Location US-IL-Bloomington;US-GA-Dunwoody;US-TX-Richardson;US-AZ-Tempe

Job Category Technology and UX

Position Type Regular Full Time

Req ID 43614

Overvi

ew
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 go

od!

Responsibil

ities
Job Ov

erview
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 ou

r 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 envi
• ronmentsEngaging in the Enterprise Claim System (ECS) modernization effort, serving as a bridge between the existing data environment and the modernized environment being d
• evelopedContributing to the identification, development, and support of services, utilities, and tooling required to manage and maintain claims data on Aurora
• PostgresUtilizing industry-adopted languages and frameworks in coding, testing, security, DevOps, DataOps and data engineering p
• racticesDeveloping and maintaining reusable, scalable, and compliant data solutions across multiple platforms and compute envi
• ronmentsEstablishing business domain knowledge for existing State Farm data sources - specifically those in ET P&
• C ClaimsIdentifying and consulting on emerging technologies and critical core systems, including techniques, tools, data sources, and platforms in the data engineeri
• ng fieldExhibiting a DataOps mindset and leveraging automation to deliver quality data s
• olutionsExperimenting and prototyping solutions to aid in validating and informing technical d

irection

Qual

ifications
We are seeking individ

• uals 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 m
• ove forwardDemonstrate a growth mindset...you have a desire and passion for learning, and a willingness to enhance both your business and techn
• ical acumenPossess outstanding communication skills...you are eager to form new relationships, enjoy collaborating across teams, departments, and locations, and can influ
• ence othersPrevious experience (2-3 years) working as a data engineer or in a r
• elated roleGeneral understanding and knowledge of mainframe and relational database concepts, database performance, COBOL, JCL, Stored Procedur
• es, and SQLExperience managing and supporting enterprise data on Db2, PostgreSQL, and/or Auro
• ra PostgresWorking knowledge of programming languages (i.e. Python) and version control tools (Git
• Hub/GitLab)Experience with Data DevOps - utilizing scripts and products such as Flyway or Liquibase to automate aspects of database
• managementExperience with version control, automated testing, and CI/CD pipelines to enable repeatable and efficient deployment of changes to data schemas and inf
• rastructureExperience with enterprise data migrations/ modernization efforts woul

d be

a plus

SFAR

M#LI-HybridP

M22



Our Benefits
Because work-life balance is a priority at State Farm, compensation is based on our standard 3

• 8:45-hour work week!
  Potential starting salary rang
• e: $97,000 - $160,000Starting salary will be based on skills, backg
• round, and experienceHigh end of the range limited to applicants with significan
• t relevant experiencePotential yearly incentive pay up

to 18% of base sal

aryWork Arrangements:Hybrid Work Locations: Bloomington, IL-Corporate, Dunwoody, GA-Park Center, Richardson, TX-CityLine or Tempe, AZ-Marina H

• eights Hub locations.Hybrid Work arrangement: A "Hybrid" position means selected candidates will be assigned to a facility and will spend some time working both in the office and from their home. Work arrangements could change over time ba

sed on business need.SPONSORSHIP: Applicants for this position 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.
At State Farm, we offer more than just a paycheck. Check out our suite of benefits designed to give you the flexibility you need to take care o

• f you and your family!
  Get Paid! On top of our competitive pay, you are eligible for an
• annual raise and bonus.Stay Well! Focus on you and your family's health with our robust health and wellbeing programs. State Farm pays most of your healthcare premium, and we offer multiple healthcare plan options, including a high deductible plan. All medical plans provide 100% coverage for in-network preventative care, AND you and your family have access to vision, dental, telemedicine, 24/7 mental health profes
• sionals, and much more!Develop and Grow! Take advantage of educational benefits like industry leading training programs, top-notch tuition assistance programs, employee resource
• groups, and mentoring.Plan Ahead! Plan for those big moments in life with benefits like fertility/IVF/adoption assistance, college coaching, national discount programs, interactive monthly financial workshops, free financial coaching, and more. You can also start a savings account or consider financing through our State Far
• m Federal Credit Union!Take a Little "You" Time! You will have access to our generous time off policies designed so you can plan around holidays, family events, volunteering, or just to take a relaxing day off. With the opportunity to initially earn up to 20 days annually plus parental leave, paid holidays, celebration day, life leave (40 hours/year), bereavement leave, and community service/education support days, there will be
• plenty of time for you!Give Back! We offer several ways to give back through our Matching Gift Program, Good Neighbor Grant Program, and the Em
• ployee Assistance Fund.Finish Strong! Plan for retirement using free financial advisors and a 401(k) plan with company contributions of u

p to 7% of your salary.
Visit our State Farm Careers page for more information on our benefits, locations, and the hiring process of join

ing the State Farm team!



Compensation details

: 97000-160000 Yearly Salary

PI8f9172746058-29448-40301925PDN-a19