Actuarial Business Analyst - Property & Casualty Insurance (Hybrid)

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

At Mapfre, 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 talentacquisition@mapfre.com. 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