Data Engineer - Agency Data & Technology

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!

Work Locations: Bloomington, IL-Corporate, Dunwoody, GA-ParkCenter Hub, Richardson, TX-CityLine Hub or Tempe, AZ-Marina Heights 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 office and from their home

The Agency Data & Technology team is seeking a Data Engineer, who will report to a manager that is currently being identified. This team is part of the larger Agency Data, Analytics and Measurement team, which partners closely with Corporate Agency teams and executives. Functionally, Agency Data & Technology is part of Corporate Agency. Organizationally, this position will report through Marketing and be part of the broader Agency/Marketing analytics community. This creates the opportunity to co-locate like skillsets, enable technical skill development, and offer broader career pathing. The mission of the Agency Data & Technology team is to modernize and manage data analytics infrastructure that enable data-driven decisions throughout Agency.

Key responsibilities of the team include:

1. Data Strategy and Modernization for Agency: Drive, oversee, and enable data modernization throughout Agency. Ensure Agency data are captured, managed, and accessible so that data are usable. These are done in close partnership with Enterprise Technology and Agency teams.
2. Agency Data Mart / Associate Register: Manage and modernization Agency Data Mart. Support the migration of Agency Data Mart to Associate Register within AWS.
3. Agency Data Stewardship: Serve as the Agency Data Steward with accountability for providing oversight and governance of the data management activities for Agency data.
4. Data Support: Oversee the team as they provide data for tools/apps and data feeds for business partners throughout Agency.

As a Data Engineer you will:

• Work closely with Enterprise Technology, other data engineers in other functions, and others on the team to develop data products to support business needs.
• Design analytic data asset solutions to meet Agency and enterprise needs, including focused validation and testing to ensure data is of the highest quality.
• Develop, test, implement, execute, validate, and monitor logic to build and maintain data products.
• Provide data pipeline solutions for the development, implementation, containerization, execution, validation, monitoring, and improvement of data analytics solutions.
• Demonstrate advanced understanding in data engineering practices, including ETL (Extract, Transform, Load), data integration, reusable data pipelines and data management.
• Conformance with State Farm data management and governance policies.
• Establish business domain knowledge for State Farm data sources.
• Identify critical and emerging technologies, techniques, tools, data sources, and platforms in the data engineering field, including cloud-based solutions, that support and extend data solutions.

• Bachelor's degree in computer science, engineering, related data field OR equivalent certifications and experience.
• Experience using SQL or Python for complex queries, joins, ETL of large and/or multiple datasets across various database types (Redshift, S3, DB2).
• Experience with various databases (e.g., AWS Redshift, S3, DB2, MS SQL).
• Experience with CI/CD pipelines, GitLab, and Terraform is a plus.
• Experience or ability to rapidly gain enterprise data domain knowledge, including agency and product line data.
• Ability to learn and adopt new technologies and languages.
• Critical thinking skills to challenge current thinking and apply the right technology to solve problems.
• Experience architecting and engineering data pipelines and optimizing them for performance and scalability.
• Experience taking initiative in shaping and driving solutions with teams and business partners.
• Experience with gathering and creating analytic business requirements, researching potential data sources (both internal and external sources), designing, developing, and maintaining data assets.
• Experience in large, complex data environments both highly coupled and highly decoupled.
• Comfortable communicating technical content to both technical and non-technical audiences over static documentation and live presentations.

*****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) or in the future for this opportunity*****

Because work-life balance is a priority at State Farm, compensation is based on our standard 38:45-hour work week!

• Potential starting salary range: $100,000 - $130,000
• Starting salary will be based on skills, background, and experience
• High end of the range limited to applicants with significant relevant experience
• Potential yearly incentive pay up to 15% of base salary

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!

PI269050765