Hybrid Actuarial Data Analyst — Property & Casualty

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

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.