Data Analyst - P&C Underwriting Analytics

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

Within the PCU Portfolio Analysis unit, the Risk Analytics team is seeking a Data Analyst. Responsibilities include developing data-driven approach to problem solving and opportunity identification, in collaboration with business partners, by understanding business needs and marrying those with awareness of our modeling strategies. Our team is highly collaborative working closely with business partners primarily across Underwriting Solutions, P&C Modeling, P&C Actuarial, and Financial Operations as we monitor risk of our business. This role will provide an opportunity to demonstrate deep technical knowledge, own and support data processes and strategy to support new business and reunderwriting model threshold work, solve complex problems. Specifically for this role we are looking for the following:

• Query and aggregate data sets from different sources/platforms to support business objectives.
• Conduct data analysis and field ad hoc data requests from business partners and leadership.
• Manage data quality to ensure accuracy in reporting, projection, and analytic efforts.
• Monitor and track key performance indicators through dashboarding and reporting, often in collaboration with other areas.
• Collaborate on underwriting strategy within P&C Underwriting and enterprise business partners.
• Support the creation of visualizations and maps using tools such as Python, PowerBI, and GIS.
• Help develop and maintain automated reports and notebooks in cloud environments such as AWS SageMaker.
• Steward data methodologies and calculations to enhance consistency.
• Communicate findings clearly, with support, to both technical and non-technical audiences.

Work Arrangement

This is a hybrid position which allows you to spend some of your time working from home as well as some time working collaboratively in-office. During the job training period you may have a higher percentage of time spent in-office to support your learning experience.

• This role is 2 days per week in the office, 3 days per week working from home. Specific days in-office vary by location and may be adjusted at any time based on business need.
• Candidates must be located within a reasonable daily commuting distance to any of our major hub locations, Bloomington IL, Dunwoody GA, Richardson TX or Tempe AZ.

Hours of operation are 8:00 AM - 4:15 PM M-F, with flexible start times. May occasionally require irregular hours based on workload.

Qualifications

• Identify and clarify data quality pain points and opportunities for improvements.
• Experience navigating different generations of data structures.
• Work independently with minimal supervision.
• Coach peers on data processes and strategies.
• Experience working with or adjacent to data models.
• Ability to effectively utilize business intelligence data systems, models, financial/statistical resources, and analytical software applications in the creation of reports, charts, and visuals.
• Ability to summarize metrics for reporting and identify corrective actions.
• Proficient in BI Tooling (i.e., Power BI, Qlik, QuickSight).
• Advanced skills within the Microsoft suite, especially Excel, Word, PowerPoint.
• May apply specialized knowledge of research/statistical techniques.
• Establishes positive relationships and coordinates work across teams and departments.
• Ability to communicate complex information to both technical and non-technical audiences.
• Proficiency in SQL and Python strongly preferred.
• Familiarity with AWS Suite and cloud-based infrastructure.
• Experience working in GitLab or other versioning software.
• Master’s Degree and/or Bachelor's Degree in Data Analytics or adjacent discipline is preferred.

Visit State Farm Careers for more information on our benefits, locations, and the hiring process.

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: $66,000 - $107,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 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!