Property & Casualty Data Analyst

Federated Mutual Insurance Company•Owatonna, MN

5h•Onsite

About The Position

Federated Insurance is seeking a highly personable and technical Data Analyst to advance our claims data capabilities. In this role, you will build trusted, automated data solutions using SQL and DBT to support ad hoc analysis and reporting in Excel, Python, and Tableau, while forming strong partnerships with claims professionals and technical teams. You will also have opportunities to perform statistical analysis in Python and continue developing your data science skills. Success in this role will require strong data modeling practices, attention to data governance, and the ability to communicate effectively across business and technical audiences. This is a full-time, in-office role based in Owatonna, MN, requiring candidates to live in or commute daily to the area. This is not a remote position. This position will work in our Owatonna, MN office full-time.

Requirements

Bachelor’s degree in Data Science, Statistics, Mathematics, Computer Science, Business Analytics, or a related field — or equivalent professional experience
At least 3 years of experience in an analyst or similar role, demonstrating strong analytical skills, effective communication, problem‑solving ability, strategic thinking, and project management
Strong understanding of Data exploration and analysis techniques, KPI design and performance monitoring, and Presenting analytical insights to non-technical audiences
Experience with statistical software and programming languages commonly used in data analysis
Strong communication skills, with the ability to present technical or complex information in a clear, understandable way
Ability to collaborate effectively with employees at all levels, clients, and other stakeholders
High level of integrity, with the ability to handle confidential business and personnel information appropriately
Must be legally authorized to work in the United States for any employer.
Must not require sponsorship for employment visa status, such as an H1-B visa.
Must not be a student or recent graduate with J-1 or F-1 visas or similar temporary work authorization.

Nice To Haves

Experience with SQL and DBT
Experience with Excel, Python, and Tableau
Experience with statistical software and programming languages commonly used in data analysis

Responsibilities

Build trusted, automated data solutions using SQL and DBT to support ad hoc analysis and reporting in Excel, Python, and Tableau.
Form strong partnerships with claims professionals and technical teams.
Perform statistical analysis in Python and continue developing data science skills.
Apply strong data modeling practices.
Maintain attention to data governance.
Communicate effectively across business and technical audiences.