Actuarial Business Analyst - Property & Casualty Insurance (Hybrid)

Mapfre; Webster (MA); Hybrid; USD 78,000 - 115,000; Full time

Benefits offered by this job

PTO

401(k) & profit sharing

Medical, dental, vision

Life & disability insurance

Job summary

MAPFRE in Webster, MA invites applications for an Actuarial Business Analyst in Property & Casualty Insurance. The role focuses on building and maintaining datasets, validating data, and supporting decision-making across pricing, reserving, and reporting.

You will develop complex SQL queries, ensure data integrity, and collaborate with IT and business partners. The position offers a hybrid work arrangement, opportunities for mentoring teammates, and a comprehensive benefits package.

Qualifications

• 3+ years of experience in Property & Casualty Insurance
• Experience supporting actuarial, pricing, reserving, claims or predictive modeling functions strongly preferred
• Strong analytical and coding expertise
• Advanced SQL development skills including complex joins, CTEs, aggregations, window functions, performance optimization and data validation techniques
• Strong understanding of relational database concepts, data modeling and data warehouse principles
• PowerBI experience preferred; DevOps practices preferred

Responsibilities

• Build and maintain countrywide datasets across all lines of business and systems
• Develop, validate, and ensure the integrity of data used for business decision-making
• Optimize processes and procedures to ensure data accuracy, consistency, and timeliness
• Apply insurance domain knowledge to build datasets supporting Market Pricing analytical needs
• Collaborate cross-functionally with teams including Advanced Analytics, IT, and business stakeholders
• Partner with senior management to ensure analysis is clearly interpreted and drives appropriate action
• Develop and optimize complex SQL queries, views and stored procedures to support analytical and reporting needs
• Identify and implement process improvements to enhance operational efficiency
• Make decisions across a wide variety of scenarios by interpreting guidelines and applying sound judgment and discretion
• Provide training, mentorship, and guidance to less experienced team members
• Communicate effectively with business partners and senior leadership
• Efficiently retrieve, manipulate, and analyze large datasets
• Support data governance, metadata management and documentation initiatives

Skills

Advanced SQL development

PowerBI

Data analysis

Git/Bitbucket

Data governance

Education

Bachelor’s Degree in Actuarial Science or related field

Tools

Git/Bitbucket

PowerBI

Job description

Select how often (in days) to receive an alert: Create Alert

Actuarial Business Analyst - Property & Casualty Insurance (Hybrid)

Date: Oct 1, 2026

Location: Webster, MA, US

Company: MAPFRE

Summary

As aTechnical Analyst II, you'll help drive business success by developing, validating, and maintaining critical data that supports our technical and finance teams. You'll use your analytical skills to uncover insights, solve problems, and support evolving business needs while ensuring data accuracy and integrity. Working across teams, you'll build a strong understanding of data, systems, and business processes to help inform decisions and improve outcomes across the organization.

What You Will Do

• Build and maintain countrywide datasets across all lines of business and systems
• Develop, validate, and ensure the integrity of data used for business decision-making
• Optimize processes and procedures to ensure data accuracy, consistency, and timeliness
• Apply insurance domain knowledge to build datasets supporting Market Pricing analytical needs
• Collaborate cross-functionally with teams including Advanced Analytics, IT, and business stakeholders
• Partner with senior management to ensure analysis is clearly interpreted and drives appropriate action
• Develop and optimize complex SQL queries, views and stored procedures to support analytical and reporting needs
• Identify and implement process improvements to enhance operational efficiency
• Make decisions across a wide variety of scenarios by interpreting guidelines and applying sound judgment and discretion
• Provide training, mentorship, and guidance to less experienced team members
• Communicate effectively with business partners and senior leadership
• Efficiently retrieve, manipulate, and analyze large datasets
• Support data governance, metadata management and documentation initiatives

What You'll Bring

• Bachelor’s Degree in Actuarial Science, Data Analytics, Mathematics, Statisctics, Computer Science, Information Systems, Econmics, Business Analytics, or related field
• 3+ years of experience working in Property & Casualty Insurance
• Experience supporting actuarial, pricing, reserving, claims or predictive modeling functions strongly preferred
• Strong analytical and coding expertise
• Advanced SQL development skills including complex joins, Common Table Expressions (CTEs), aggregations, window functions, performance optimization and data validation techniques
• Strong understanding of relational database concepts, data modeling and data warehouse principles
• Prior experience with PowerBI preferred
• Experience with Git, Bitbucket, source control or DevOps practices preferred
• Experience implementing methodologies or process improvements
• Ability to independently complete intermediate analyses and contribute to complex projects under managerial guidance
• Demonstrated success managing multiple workstreams simultaneously and prioritizing tasks effectively

Why Mapfre?

As a global insurance leader with a strong local presence, we offer more than a job- we provide a purpose-driven career where your growth, well-being, and impact truly matter.

Purpose & Culture:

Join a company built on trust, collaboration, and inclusion. Our values guide everything we do, creating a workplace where people feel respected and empowered.

Career Growth:

Advance your skills through tuition reimbursement, leadership programs, and internal mobility opportunities. Your development is our priority.

Social Responsibility:

Contribute to meaningful initiatives through Fundación Mapfre, supporting communities and sustainability worldwide.

Pay Transparency:

The typical starting salary range for this role is determined by several factors including skills, experience, education, certifications, and location. Some roles at Mapfre are eligible for commission and/or bonus earnings, in addition to salary, calculated based upon factors set forth in the compensation plan for the role.

Salary Range

$77,700 - $114,500

Benefits Highlights:

AtMapfre, we invest in our employees' well-being by offering a comprehensive benefits package, including:

• Paid Time Off (PTO):A flexible PTO program that combines vacation, personal, volunteer and sick time into one convenient bank of paid time off.
• 401(k) & Profit Sharing:Eligible employees may participate in Mapfre's 401(k) plan that includes company matching contributions up to certain amounts under the terms of the plan.
• Medical, Dental and Vision Coverage:Choice of comprehensive medical, dental and vision insurance coverage under group plans offered by the company.
• Other Benefits Include: STD, LTD, Life Insurance, FSA, HSA and various wellness programs.

Benefits provided are subject to the terms and conditions of the applicable benefit plan or policy. The Company reserves the right to alter, amend, or terminate benefits in its sole discretion. To learn more about our benefit offerings please visit:https://mapfre.gobenefits.net/

If you require a reasonable accommodation during the application or selection process, please contact the Mapfre Talent Acquisition team at [e-mail]. Mapfre is proud to be an Equal Opportunity Employer.

Important Notice:

The information above is intended to provide a general overview of available benefits. Eligibility, plan provisions, and coverage are governed by the terms and conditions of the applicable benefit plans and policies, which may be modified from time to time.

#MAPFRE123

Nearest Major Market: Worcester
Job Segment: Accounting, Actuarial, Recruiting, Computer Science, Business Analyst, Finance, Insurance, Human Resources, Technology