Data Engineer - AWS REMOTE - State Farm

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!

Responsibilities

Do you crave innovation and want to work for a company that is the BEST at what they do in the industry? Does the opportunity to work and maintaining a work life balance appeal to you? Then we have the perfect job for you! We are seeking for a Data Engineer who push the envelope and strive to create the best product possible. This position will allow you to utilize different technologies, languages, and frameworks to drive solutions while working on inclusive teams that foster diversity of thought. At State Farm, we prioritize your professional development and career goals. That's why we offer in-house training programs and opportunities for up-skilling, ensuring you have the support and resources you need to succeed.

We are looking to establish a dynamic new product team that will be responsible for the development and implementation of cloud-based big data solutions, the ideal candidate will have deep experience moving large datasets, 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. We are currently seeking an experienced data engineer who can 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 (e.g. H-1B visa) for this opportunity.

These positions span a broad set of technical skills; Candidates with software development and big data experience along with a willingness to learn while working in a fast-paced challenging agile environment are encouraged to apply.

Ideal candidate will have the following:

• 4-5 years of professional work experience programming with Python
• 2+ years of professional work experience programming with Scala

Additional Desired Skills:

• Strong experience in handling large-scale Big Data datasets containing a combination of structured and unstructured data.
• Proficient in working with AWS S3 Glacier storage, AWS Glue, Apache Spark, and Terraform for efficient data processing and storage.
• Expert in Data Analysis and writing queries using Athena, performing data accuracy amongst various integration points in a pipeline considering different data formats
• Skilled in SQL and adept at extracting and manipulating data from various sources.
• Familiarity with test-driven development (TDD) and continuous integration/continuous deployment (CI/CD) systems, preferably with Gitlab CI.
• Proficient in using testing tools such as JUnit and Cucumber to ensure high-quality software development.
• Experience with Containers-as-a-Service (CaaS) architecture.
• Extensive experience in ETL (extracting, transforming, and loading) processes for data used in analytic discovery and deployment of production solutions across multiple platforms.

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: $82,786.28 - $156,200

For NYC and CT candidates:

Potential salary range: $82,786.28 - $177,500

Potential yearly incentive pay:4%-12% of base salary

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!

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.