Data Analyst - P&C Underwriting Analytics

State Farm • Dunwoody, GA

22h • Hybrid

About The Position

The Data Analyst will join the Risk Analytics team within the PCU Portfolio Analysis unit, collaborating with business partners to solve problems and identify opportunities using data and an understanding of modeling strategies. The team works closely with partners across Underwriting Solutions, P&C Modeling, P&C Actuarial, and Financial Operations to monitor business risk. The role includes owning and supporting data processes and strategy for new business and reunderwriting model threshold work, as well as solving complex problems.

This is a hybrid position: two days per week in the office and three days per week working from home. During training, employees may spend more time in the office. Candidates must live within a reasonable daily commuting distance of Bloomington, IL; Dunwoody, GA; Richardson, TX; or Tempe, AZ. Standard hours of operation are Monday through Friday, 8:00 a.m. to 4:15 p.m., with flexible start times. Occasional irregular hours may be required based on workload.

Requirements

• Experience navigating different generations of data structures.
• Ability to work independently with minimal supervision.
• Experience working with or adjacent to data models.
• Ability to effectively use business intelligence data systems, models, financial or statistical resources, and analytical software to create reports, charts, and visuals.
• Ability to summarize metrics for reporting and identify corrective actions.
• Proficiency in business intelligence tools such as Power BI, Qlik, or QuickSight.
• Advanced skills in Microsoft Office, especially Excel, Word, and PowerPoint.
• Ability to communicate complex information to technical and non-technical audiences.

Nice To Haves

• Proficiency in SQL and Python is strongly preferred.
• Familiarity with the AWS suite and cloud-based infrastructure.
• Experience working in GitLab or other version control software.
• A master's degree and/or bachelor's degree in Data Analytics or an adjacent discipline is preferred.
• Knowledge of research or statistical techniques may be applied.

Responsibilities

• Query and aggregate data from different sources and platforms to support business objectives.
• Analyze data and respond to ad hoc requests from business partners and leadership.
• Manage data quality to ensure accuracy in reporting, projections, and analytics.
• Monitor and track key performance indicators through dashboards and reporting, often in collaboration with other areas.
• Collaborate on underwriting strategy within P&C Underwriting and with enterprise business partners.
• Support creation of visualizations and maps using tools such as Python, Power BI, and GIS.
• Help develop and maintain automated reports and notebooks in cloud environments such as AWS SageMaker.
• Steward data methodologies and calculations to improve consistency.
• Communicate findings clearly, with support, to technical and non-technical audiences.
• Identify data-quality pain points and opportunities for improvement.
• Coach peers on data processes and strategies.
• Summarize metrics for reporting and identify corrective actions.
• Establish positive relationships and coordinate work across teams and departments.

Benefits

• Potential yearly incentive pay up to 10% of base salary.
• Annual raise and bonus eligibility.
• Health and wellbeing programs, including healthcare plan options, vision and dental coverage, telemedicine, and mental health professionals.
• Educational benefits, including training programs, tuition assistance, employee resource groups, and mentoring.
• Fertility, IVF, and adoption assistance.
• National discount programs, financial workshops, and free financial coaching.
• Time-off policies, including up to 20 days initially earned annually, parental leave, paid holidays, a celebration day, life leave, bereavement leave, and community service or education support days.
• Matching Gift Program, Good Neighbor Grant Program, and Employee Assistance Fund.
• Free financial advisors and a 401(k) plan with company contributions of up to 7% of salary.

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level
• Education Level: No Education Listed