Lead Data Engineer/Data Engineer
State Farm · Richardson, TX
- On site
- Full-time
- $160,000 / year
- Richardson, TX
Job highlights
- Data Engineer role on Central Claims Data team.
- Modernize claims data systems using AWS.
- Support Db2 and Aurora Postgres environments.
- Utilize Python, SQL, and DevOps practices.
- Hybrid work arrangement in multiple locations.
About the role
Data Engineer
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 you are 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
- 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
- Data Engineering
- AWS
- Python
- SQL
- Db2
- PostgreSQL
- Aurora Postgres
- DataOps
- DevOps
- CI/CD Pipelines
Skills & topics
- Data Engineer
- Data Engineering
- AWS
- Python
- SQL
- Db2
- PostgreSQL
- Aurora Postgres
- DataOps
- DevOps
- CI/CD
- ETL
- Database Management
- Data Migration
- Hybrid Work
How to get hired
- Tailor your resume: Highlight your 2-3 years of data engineering experience, focusing on Db2, PostgreSQL, Aurora Postgres, Python, SQL, and DevOps/DataOps.
- Showcase your skills: Emphasize your experience with data migrations, AWS, and CI/CD pipelines in your application.
- Demonstrate a growth mindset: During interviews, express your passion for learning and ability to thrive in uncertain environments.
- Prepare for technical questions: Be ready to discuss mainframe concepts, database performance, COBOL, JCL, Stored Procedures, and SQL.
- Network internally: Leverage State Farm's career page and resources to understand their culture and hiring process.
Technical preparation
Practice Python coding and SQL queries.,Review AWS data services and cloud concepts.,Familiarize with database management tools.,Understand CI/CD and DataOps principles.
Behavioral questions
Describe a challenging data project.,How do you handle uncertainty?,Share a time you learned quickly.,How do you collaborate with others?
Frequently asked questions
- What is the salary range for a Data Engineer at State Farm?
- The potential starting salary range for a Data Engineer at State Farm is $97,000 to $160,000 annually, with the higher end reserved for candidates with extensive relevant experience. Additionally, there's potential for yearly incentive pay up to 18% of your base salary.
- What is the work arrangement for this Data Engineer position?
- This Data Engineer position offers a hybrid work arrangement, meaning you will spend some time working from home and some time in the office. Specific hybrid work locations include Bloomington, IL; Dunwoody, GA; Richardson, TX; or Tempe, AZ.
- What technologies will I be working with as a Data Engineer at State Farm?
- As a Data Engineer, you will work with technologies such as IBM Db2, Aurora Postgres, Python, SQL, GitHub/GitLab, and potentially other AWS services as part of the modernization effort. Experience with tools like Flyway or Liquibase for Data DevOps is also valuable.
- Does State Farm offer sponsorship for this Data Engineer role?
- No, State Farm does not offer sponsorship for this Data Engineer position. Applicants must be legally eligible to work in the U.S. immediately, and the company will not sponsor for U.S. work authorization.
- What are the key qualifications for the Data Engineer role at State Farm?
- Key qualifications include 2-3 years of data engineering experience, general knowledge of mainframe and relational databases, experience with Db2 and PostgreSQL/Aurora Postgres, proficiency in Python and SQL, and familiarity with DevOps/DataOps practices and tools like GitHub/GitLab.
- What does a 'growth mindset' mean for this Data Engineer position?
- A 'growth mindset' for this Data Engineer role means demonstrating a passion for continuous learning, a willingness to enhance both technical and business acumen, and an eagerness to adapt to new and uncertain environments. It signifies a proactive approach to skill development and problem-solving.
- What kind of projects can I expect as a Data Engineer on the Central Claims Data team?
- You can expect to support and maintain existing claims data on IBM Db2, while also actively participating in a multi-year modernization effort to host the Enterprise Claims System on AWS. This involves developing and supporting services for Aurora Postgres and contributing to the overall data architecture evolution.
Similar roles
Open positions we recommend based on this role.