Data Analyst Claims

Position Overview

As a Claims Data Analyst at Mercury Insurance, you will play a vital role in identifying business opportunities, supporting strategic decision-making, and driving operational improvements through data analysis. Working closely with claims leadership and cross-functional teams, you will transform complex data into actionable insights and help implement solutions to optimize claims processes.

Key Responsibilities

• Collaborate with claims leadership and various departments (Product, Underwriting, IT, etc.) to support the identification and resolution of business challenges using data insights.

• Extract and prepare data from multiple sources (Guidewire, NextGen, EDW) for analysis; ensure accuracy and continuously improve data retrieval methods.

• Develop reports, visualizations, and dashboards using tools like Power BI to communicate trends, performance metrics, and business recommendations.

• Interpret large datasets to uncover patterns, forecast claims activity, and support business planning and risk mitigation efforts.

• Serve as a key point of contact for standard and ad-hoc reporting needs, providing timely and accurate analysis to stakeholders.

• Build presentations that clearly articulate identified issues, potential solutions, and performance metrics; present findings in management meetings when required.

• Actively engage with subject matter experts across claims operations to gain a deep understanding of job functions, KPIs, and business drivers.

• Design and maintain spreadsheets and visual tools to assist management in data-driven decision-making.

• Consistently communicate insights and updates to leadership in a clear and proactive manner.

• Support and guide claims team members in understanding and utilizing reporting tools and data sources.

• Maintain regular, full-time attendance and perform other duties as assigned.

Qualifications

Education

• Bachelor’s degree in a quantitative or analytical field such as Mathematics, Statistics, or Engineering required.

• A Master’s degree may substitute for work experience.

Experience

• Minimum of 3 years of insurance industry experience in an analytical role, or an equivalent combination of education and experience.

Skills and Competencies

• Advanced proficiency in SQL required.

• Strong experience with Power BI and other data visualization platforms.

• Knowledge of Python and/or R is a plus.

• Solid foundation in statistics and model validation techniques.

• Ability to analyze large, complex datasets with a high degree of accuracy and attention to detail.

• Excellent problem-solving, analytical, and critical thinking skills.

• Strong verbal and written communication skills; ability to present complex data findings to both technical and non-technical audiences.

• Ability to manage multiple projects simultaneously and meet tight deadlines.

• Willingness to travel and work flexible hours as needed.

• Adherence to company privacy policies due to the sensitive nature of the data handled in this role.

Why Mercury Insurance?

For over 60 years, Mercury Insurance has been driven by a mission to help people manage risk and recover from the unexpected. Our work is essential—and so are the people behind it. We foster a culture of collaboration, growth, and inclusivity, empowering every team member to make a difference.

We value diverse perspectives and are committed to creating an environment where everyone feels supported, respected, and celebrated.

Perks & Benefits

• Competitive compensation with performance and holiday bonus opportunities

• Flexible work options, including remote work within the U.S.

• Generous paid time off (vacation, sick leave, company holidays, volunteer time)

• Comprehensive insurance offerings: medical, dental, vision, life, and pet insurance

• 401(k) retirement savings with company match

• Education assistance and career development programs

• Free access to mental health coaching, elder/childcare resources, and wellness support

• Employee recognition programs and opportunities for advancement