Hybrid Data Analyst - Risk Analytics (Python, Power BI)

State Farm; Bloomington (IL); Hybrid; USD 66,000 - 107,000; Full time

Benefits offered by this job

Salary $66,000-$107,000 per year

Annual incentive pay up to 10%

Comprehensive health and wellbeing

Job summary

State Farm in Bloomington, IL is seeking a Data Analyst to join the Risk Analytics team in the PCU Portfolio Analysis unit. You will develop data-driven solutions, partner with Underwriting Solutions, P&C Modeling, and Finance to monitor risk and optimize decisions.

You will query diverse data sources, ensure data quality, build dashboards, and create visualizations with Python and Power BI, while leveraging AWS SageMaker for notebooks and cloud workflows.

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 summarize metrics for reporting and identify corrective actions.

Responsibilities

• 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.

Skills

SQL

Python

Data Visualization

Power BI

Communication

Data Quality

Problem Solving

Collaboration

Education

Master’s Degree in Data Analytics

Bachelor’s Degree in related field

Tools

GitLab

AWS SageMaker

Job description

State Farm in Bloomington, IL is seeking a Data Analyst to join the Risk Analytics team in the PCU Portfolio Analysis unit. You will develop data-driven solutions, partner with Underwriting Solutions, P&C Modeling, and Finance to monitor risk and optimize decisions.

You will query diverse data sources, ensure data quality, build dashboards, and create visualizations with Python and Power BI, while leveraging AWS SageMaker for notebooks and cloud workflows.