Data Analytics Engineer

OverviewBeing 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!Office Location(s): Bloomington, IL; Richardson, TX; Tempe, AZHybrid Work Arrangement: In this position, you should plan to spend time working in the office and remotely (with the ability for same day travel to and from your assigned office location) as part of a hybrid work arrangement. Work arrangements could change over time based on business need.• ****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*****ResponsibilitiesAs a member of the P&C Actuarial and Underwriting Modeling Department you will be challenged and empowered to grow professionally. We are dedicated to helping each of our associates develop to their full potential. We appreciate your interest in this role.Currently hiring for multiple openings. Team placement will be aligned based on candidate’s individual expertise.As a Data Analytics Engineer you will:• Work closely with data scientists and business experts to develop modeling and/or analytics solutions for actuarial and underwriting business problems• Building and maintaining data pipelines for the development, implementation, execution, validation, monitoring, and improvement of data science solutions• Establish business domain knowledge for State Farm data sources• Investigate, recommend, and initiate acquisition of new data resources from internal and external 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 quantitative analytic deployment solutionsQualificationsSuccess in this job requires:• Up-to-date expertise in data engineering practices. Ability to provide solutions for the identification, acquisition, cleansing, profiling, and ETL (extracting, transformation, and loading) of data used in data science discovery and deployment solutions• Conformance with State Farm data management and governance policies• An understanding of the basics of predictive analytics/statistical models/machine learning models• Developing and maintaining an effective network of both scientific and business contacts/knowledge• Strong business acumen and the technical ability to acquire, transform and interpret complex data• Excellent communication skills and the ability to work with multiple, diverse stakeholders across business areas and leadership levels• Willingness to learn and adapt in agile development environment• Ability to learn and share new technical concepts quicklyPreferred Skills and Work Experiences:• Bachelor’s Degree in Computer Science or a related field• AWS Certification(s)• Experience with version control (e.g., GitHub, GitLab)• Hands on GitOps experience• Familiarity with Python and Spark/PySpark• Familiarity with building SQL and No-SQL queries• Experience working with P&C data• Experience working in AWS/Cloud Concepts, Hadoop, or LINUX• Experience with gathering and creating analytic business requirements, researching potential data sources (both internal and external sources), designing, developing and maintaining data assetsCompetencies:• Technical/Functional Expertise• Critical Thinking• Teamwork• Adaptability• ****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*****