Data Engineer - AWS Glacier

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!

We are excited to announce the formation of a dynamic new product team dedicated to the development and implementation of cloud-based big data solutions. We are seeking an experienced Data Engineer with a strong background in Python, Scala, and AWS services to join our team. Ideal candidates will have deep experience moving large datasets for long term storage, and record retention on Cloud/AWS. The primary purpose of this service is to facilitate data archival and retention deletion, but it will also involve transforming and ingesting legacy data. In this role you will contribute to the team by assisting in the design, development, and support of solutions on AWS. Additionally, this role will involve enhancing and resolving any defects in the products and services created by the team. The ideal candidate for this position will have a passion for continuous learning and applying new technical and business skills. A strong product mindset and the ability to thrive in an agile, fast-paced, and ever-evolving environment will greatly benefit this team.

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 now or in the future (e.g. H-1B visa) for this opportunity.

Required Skills:

• Proven expertise in managing large-scale Big Data datasets, specifically utilizing AWS S3 Glacier for long-term storage, AWS Glue for data integration, Apache Spark for data processing, and Terraform for infrastructure as code, with hands-on experience working with terabyte-sized structured and unstructured datasets.
• 4+ years of professional work experience programming with Python, focusing on data engineering and migration tasks.
• 2+ years of professional work experience programming with Scala, contributing to data processing and transformation projects.
• Proficient in data analysis, with the ability to write complex queries using Amazon Athena to ensure data accuracy across various integration points in data pipelines, while effectively handling different data formats.

Desired Skills:

• Strong SQL skills, with the ability to extract and manipulate data from diverse sources effectively.
• Familiarity with test-driven development (TDD) and continuous integration/continuous deployment (CI/CD) practices, preferably using GitLab CI.
• Proficient in utilizing testing frameworks such as JUnit and Cucumber to maintain high-quality software development standards.
• Experience with Containers-as-a-Service (CaaS) architecture, enhancing application deployment and scalability.
• Extensive experience in ETL (extract, transform, load) processes, facilitating data preparation for analytics and the deployment of production solutions across multiple platforms.

The selection process:

1. Qualified candidates may be invited to participate in an on demand video interview consisting of behavior based interview questions to include a coding challenge.
2. Our hiring team will evaluate on demand video interview submissions and competitive candidates may be invited to a live video interview with our hiring team.

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, OPT) for this opportunity.

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.

HUB LOCATIONS: Dunwoody, GA; Richardson, TX; Tempe, AZ; or Bloomington, IL

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.

For Colorado, Maryland and Washington State: (geographic differential may apply): Salary Range: $119,750 - $152,375 | Potential yearly incentive pay up to 15% of base salary

For California, New York, and CT residents (geographic differential may apply): Salary Range: $105,380 - $152,375 | Potential yearly incentive pay up to 125% of base salary

For Illinois, Hawaii & Vermont residents: Salary Range: Salary Range: $90,600-$116,300 | Potential yearly incentive pay up to 15% of base salary

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.

Application deadline: 11:59 PM CDT 12/9. Applicant volume and hiring needs may result in early closure or extension beyond the listed deadline. To submit an application, click "Apply" on the job listing page on the State Farm career site.

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!-ca1

#LI-CA1

We are excited to announce the formation of a dynamic new product team dedicated to the development and implementation of cloud-based big data solutions. We are seeking an experienced Data Engineer with a strong background in Python, Scala, and AWS services to join our team. Ideal candidates will have deep experience moving large datasets for long term storage, and record retention on Cloud/AWS. The primary purpose of this service is to facilitate data archival and retention deletion, but it will also involve transforming and ingesting legacy data. In this role you will contribute to the team by assisting in the design, development, and support of solutions on AWS. Additionally, this role will involve enhancing and resolving any defects in the products and services created by the team. The ideal candidate for this position will have a passion for continuous learning and applying new technical and business skills. A strong product mindset and the ability to thrive in an agile, fast-paced, and ever-evolving environment will greatly benefit this team.

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 now or in the future (e.g. H-1B visa) for this opportunity.

Required Skills:

• Proven expertise in managing large-scale Big Data datasets, specifically utilizing AWS S3 Glacier for long-term storage, AWS Glue for data integration, Apache Spark for data processing, and Terraform for infrastructure as code, with hands-on experience working with terabyte-sized structured and unstructured datasets.
• 4+ years of professional work experience programming with Python, focusing on data engineering and migration tasks.
• 2+ years of professional work experience programming with Scala, contributing to data processing and transformation projects.
• Proficient in data analysis, with the ability to write complex queries using Amazon Athena to ensure data accuracy across various integration points in data pipelines, while effectively handling different data formats.

Desired Skills:

• Strong SQL skills, with the ability to extract and manipulate data from diverse sources effectively.
• Familiarity with test-driven development (TDD) and continuous integration/continuous deployment (CI/CD) practices, preferably using GitLab CI.
• Proficient in utilizing testing frameworks such as JUnit and Cucumber to maintain high-quality software development standards.
• Experience with Containers-as-a-Service (CaaS) architecture, enhancing application deployment and scalability.
• Extensive experience in ETL (extract, transform, load) processes, facilitating data preparation for analytics and the deployment of production solutions across multiple platforms.

The selection process:

1. Qualified candidates may be invited to participate in an on demand video interview consisting of behavior based interview questions to include a coding challenge.
2. Our hiring team will evaluate on demand video interview submissions and competitive candidates may be invited to a live video interview with our hiring team.

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, OPT) for this opportunity.

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.

HUB LOCATIONS: Dunwoody, GA; Richardson, TX; Tempe, AZ; or Bloomington, IL

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.

For Colorado, Maryland and Washington State: (geographic differential may apply): Salary Range: $119,750 - $152,375 | Potential yearly incentive pay up to 15% of base salary

For California, New York, and CT residents (geographic differential may apply): Salary Range: $105,380 - $152,375 | Potential yearly incentive pay up to 125% of base salary

For Illinois, Hawaii & Vermont residents: Salary Range: Salary Range: $90,600-$116,300 | Potential yearly incentive pay up to 15% of base salary

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.

Application deadline: 11:59 PM CDT 12/9. Applicant volume and hiring needs may result in early closure or extension beyond the listed deadline. To submit an application, click "Apply" on the job listing page on the State Farm career site.

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!-ca1

#LI-CA1