Data Engineer

Join State Farm as a Data Engineer within our General Departments team, where you will play a crucial role in developing and optimizing our data infrastructure. In this position, you will be responsible for implementing robust backup and recovery solutions for our databases, ensuring data integrity and high availability. You will facilitate seamless data sharing and collaboration across teams by managing access provisioning for data consumers. As the owner of stored procedures, you will focus on improving data processing efficiency and upholding high-quality data standards. Additionally, you will oversee database architecture and clusters, driving optimal data design and management practices, while leveraging your expertise in RDS provisioning to create scalable and efficient database solutions.

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.

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! Khakis optional. . .

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 of 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 professionals, 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 Farm 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 Employee Assistance Fund.
• Finish Strong! Plan for retirement using free financial advisors and a 401(k) plan with company contributions of up to 7% of your salary.

Visit our State Farm Careers page for more information on our benefits, locations, and the hiring process of joining the State Farm team!

• Participates in solution design, taking into consideration risks, mitigations, performance, user experience, testability and reduce technical debt
• Utilizes Data Engineering knowledge necessary to support design, development, testing and execution of technology solutions
• Provides input into overall testing strategy and plan; contributes to testing approach and scenarios for requirements
• Develops solutions on variety of platforms according to business requirements
• Provides technical support to team
• Conducts research and integrate industry best practices into processes and potential solutions
• Participates in the full software development cycle including coding, testing, implementation, support and sunset
• Utilizes agile software development practices, coding, data and testing standards, code reviews, source code management, continuous delivery and software architecture
• Designs, develops, tests and supports software in support of big data objectives
• Possesses an understanding of how technology solutions meet the business outcomes and offers a range of solutions for business partners; understands business current and aspirational needs
• Participates in sprint planning; provides work estimates to deliver product stories; owns development stories
• Completes required coding to satisfy the defined acceptance criteria and deliver desired outcome
• Assists in the development of automated testing and supporting code as necessary to support stories
• Completes required documentation to communicate required information to deployment, maintenance, support and business teams
• Adopts Service Design, where appropriate, through utilization of modularity within architecture to enable continuous delivery
• Considers the application of emerging technology solutions to increase efficiency and effectiveness and a general expectation of continuous innovation
• Resolves problems that result in a decreased time to market; improves quality, enhances flexibility and embraces the solution provider mindset
• Exhibits DevOps mindset where team is accountable for product from inception to sunset
• Participates in open-source communities to help solve technical challenges and contributes back where applicable

• Proficient in Java and experienced with version control systems such as SVN and GIT, ensuring efficient code management and collaboration.
• Experienced with AWS services: RDS, EMR, Glue, Athena, S3, Lambda
• Demonstrated experience within distributed computing systems to design, develop and test scalable applications capable of handling high-volume datasets, ensuring optimal performance and reliability
• Skilled in continuous integration using tools like Jenkins and GitLab Runner, along with build tools like Maven and ANT for streamlined development processes.
• Familiar with application servers including Tomcat and WebSphere (WAS), and adept at utilizing the Spring Source Tool Suite for development.
• Experienced in test automation with Selenium Web Driver and Selenium RC, as well as managing defects using TRAC IT and HP Service Manager.
• Knowledgeable in scripting languages (Groovy, JavaScript, Terraform, Python) and code quality tools (JaCoCo, Checkstyle, PIT, PMD, FindBugs, Sonar) to maintain high coding standards.

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 and Washington State residents (geographic differential may apply): Salary Range: $85,500 - $127,300 | Potential yearly incentive pay up to 12% of base salary

For California, New York, and CT residents (geographic differential may apply): Salary Range: $894,075.31 - $145,375 | Potential yearly incentive pay up to 12% of base salary

For Hawaii residents: Salary Range: Salary Range: $85,500-$116,300 | Potential yearly incentive pay up to 12% 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 is expected to close at 11:59 PM CDT 12/3. 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. #LI-CA1

#li-sd

PI255666836