Data Analyst

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. Come join a #1 team and do some good!

Responsibilities

The Life/Health Data Team is developing innovative data products using emerging AWS technologies and capabilities. We need your help modernizing and transforming our data processes to Cloud-based technology, investigating new and innovative services, and building creative data solutions. Working in the Life/Health business department on the Data Team, you’ll play an integral role working directly with business and technical partners to make decisions and drive pace.

The primary function of the Life/Health Data Team is to develop data expertise and provide meaningful insight to facilitate data driven decisions by our stakeholders. This promotes gaining competitive advantage through evidence-based research, data analytics, and predictive modeling.

As a member of the Life/Health Data Team you will be challenged and empowered to grow and learn. We are dedicated to the development of each team member to reach their full potential.

We appreciate your interest in this role.

Day in the Life

In this role, day-to-day activities will vary based on the needs of your customers and our transformational efforts. Broadly, your responsibilities will include the following:

• Maintain life insurance data assets needed to fulfill requests from stakeholders
• Develop, enhance, and own ETL processes for Life/Health data
• Migrate (develop) ETL processes to (in) AWS
• Write ad-hoc queries and perform reporting/analytics supporting business partners
• Consult, support, and work directly with business partners upstream (e.g., Enterprise Technology) and downstream (e.g., L/H Actuarial, Advanced Analytics, Research, General Underwriting or Business Intelligence)
• Collaborate with State Farm associates in various roles to document, develop and deliver data products needed by stakeholders
• Maintain legacy ETL functions, primarily in SAS, until they migrate to AWS
  
  

Qualifications

Required Skills

• Recent programming and SQL coding experience and/or four year degree in Computer Science or related field.
• Experience in Python or similar language and SQL
• SAS programming experience and experience performing ETL tasks
• Excellent verbal and written communication skills
• Source management knowledge, Git/GitLab preferred
• Excellent problem solving skills and ability to handle multiple projects simultaneously
• Ability to work with data sources in a variety of formats
• 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
  
  

Preferred Skills

• Advanced data skills - AWS or similar tools and platforms
• Experience working in AWS environment and using AWS enabled tools (Athena, Sagemaker, Quicksight, Pyspark)
• Experience with Pandas or other similar data manipulation packages
• Track record of improving/innovating business processes
• Knowledge of State Farm/insurance data sources and processes
• Ability to create clear technical documentation and knowledge-based solutions
  
  

Our Benefits

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: $80,000 - $120,000
• Starting salary will be based on skills, background, and years of experience
• High end of the range limited to applicants with significant relevant experience
• Potential yearly incentive pay up to 10% 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!

LI-JM1