Lead Data Engineer

Overview 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. We're moving with urgency to become a Next Gen Good Neighbor, with technology that strengthens human connections and enhances the customer experience. As an employee, you'll spend less time navigating systems and more time applying judgment, empathy, and expertise in the moments that matter most. Responsibilities State Farm (Bloomington, IL) seeks a Lead Data Engineer to help migrate, build, and service Analytics environments with a particular concentration on cloud based environments as well as other emerging technologies and capabilities. Specific duties include: apply skills, tools, security processes, applications, environments and programming language(s) to complete complex assignments; apply advanced engineering practices to design data solutions using industry-adopted languages and frameworks; diagnose and resolve complex problems/issues; maintain advanced understanding in software engineering topics, including classes, functions, security, containers, version control, CI/CD, and unit tests; maintain advanced understanding in programming, and database and data storage functionality and apply that understanding to build reusable data solutions; maintain advanced understanding in compute environments, including but not limited to Linux, Public Cloud, and containers; maintain advanced understanding in data engineering topics, including ETL (Extract, Transform, Load), data integration, reusable data pipelines, data management, data analytics, data visualization, and data science; maintain advanced business domain expertise for data sources and applies in recommendations, designs, and execution of data solutions; apply advanced understanding regarding data and technology trends/changes, best practices, and processes to complete assignments and influence the direction of product solutions; apply advanced understanding of product design, data design and movement and test to ensure quality outcomes; leverage an advanced understanding of the State Farm organizational structure to navigate the organization; provide mentorship, technical guidance, training, and may delegate work to others; possibly take on several simultaneous work stories or focus on a single complex story; understand, support, and help define the vision and direction for the product development; and possibly have membership and engage with technical groups in the organization; leverage inner source best practices to encourage code discoverability and collaboration across the enterprise. Option for hybrid work environment, allowing work from home with required travel to local office at least once per quarter. Required to live within 180 miles of local office and within the United States. Qualifications Position requires a Bachelor’s degree, or foreign equivalent, in Computer Science, Information Systems Security, or a closely related field of study, plus 5 years of experience in the job offered, or as a Software Developer, Associate – Projects, or similar technical architectural position. Specific experience must include: gaining enterprise data domain knowledge, including rating, underwriting, and/or claims, rapidly; working with programming languages, including Java, Python, Spark, Terraform, Angular 7, React JS, JavaScript, and jQuery; working with AWS services, including (AWS Glue, Lambda, SQS, SNS, Cloud Watch, S3, Event Bridge, RDS, EC2); working with various databases, including AWS Redshift, S3, AWS DynamoDB, DB2, Postgres, Oracle, MS SQL, and MongoDB; developing solutions on AWS Redshift and S3; working with version control, including GitHub, GitLab, Jenkins, Docker, IDE like PyCharm, STS, eclipse, vs code); learning and adopting new technologies and languages; and using critical thinking skills to challenge current thinking and applying the right technology to solve problems. Option for hybrid work environment, allowing work from home with required travel to local office at least once per quarter. Required to live within 180 miles of local office and within the United States. Salary: $150,592/yr. Full time position. Our Benefits Because work-life balance is a priority at State Farm, compensation is based on our standard 38:45-hour work week! 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. #J-18808-Ljbffr