Actuarial Business Analyst - Property & Casualty Insurance (Hybrid)

MAPFRE; Webster (MA); On-site; USD 78,000 - 115,000; Full time

Benefits offered by this job

Paid Time Off (PTO)

401(k) & Profit Sharing

Medical, Dental and Vision Coverage

Job summary

Mapfre is seeking a Technical Analyst II to drive data-driven decisions across actuarial, pricing and analytics teams in Massachusetts. You will build and validate large datasets, write complex SQL, and partner with stakeholders to ensure data accuracy and actionable insights.

You will collaborate with IT and business units, mentor junior colleagues, and contribute to data governance initiatives while supporting ongoing process improvements and reporting needs.

Qualifications

• Bachelor’s degree in relevant field; 3+ years in P&C Insurance.
• Actuarial, pricing, reserving, claims or predictive modeling experience preferred.
• Strong analytical and coding expertise.
• Advanced SQL development with joins, CTEs, aggregations, window functions.
• Relational DB/data warehouse knowledge.
• PowerBI experience.
• Git/DevOps familiarity.
• Experience implementing methodologies or process improvements.
• Ability to manage multiple workstreams and perform analyses.

Responsibilities

• Build and maintain countrywide datasets across lines of business and systems.
• Develop, validate, and ensure data integrity for business decisions.
• Optimize processes for data accuracy, timeliness, and consistency.
• Apply insurance domain knowledge to datasets for market pricing analytics.
• Collaborate cross-functionally with Advanced Analytics, IT and stakeholders.
• Partner with senior management to drive action from analyses.
• Develop and optimize complex SQL queries, views, and procedures.
• Identify and implement process improvements for efficiency.
• Make decisions across scenarios by interpreting guidelines.
• Provide training and mentorship to less experienced teammates.
• Communicate effectively with business partners and leadership.
• Retrieve, manipulate, and analyze large datasets efficiently.
• Support data governance and metadata management initiatives.

Skills

Analytical skills

SQL proficiency

Data validation

Problem solving

Cross-functional collaboration

Mentoring

Education

Bachelor's degree in a related field

Tools

PowerBI

Git/Bitbucket

SQL tooling

ETL concepts

Job description

Summary

As a Technical 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.