Job description

Date: Oct 1, 2026 Location: Webster, MA, US Company: MAPFRE 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: 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 Nearest Major Market: Worcester Job Segment: Accounting, Actuarial, Data Warehouse, Database, SQL, Finance, Insurance, Technology Apply now » Apply now • Apply Now • Start applying with LinkedIn • Please wait... Find similar jobs: PROFESSIONALS, ACTUARIAL AND MARKET PRICING + PROFESSIONALS, ACTUARIAL AND MARKET PRICING • Opens in a new tab. • Opens in a new tab. • Opens in a new tab. • Opens in a new tab. • Opens in a new tab. © Copyright 2018 Mapfre × Cookie Consent Manager When you visit any website, it may store or retrieve information on your browser, mostly in the form of cookies. Because we respect your right to privacy, you can choose not to allow some types of cookies. However, blocking some types of cookies may impact your experience of the site and the services we are able to offer. Required Cookies These cookies are required to use this website and can't be turned off. Required Cookies Show More Details Required Cookies Provider Description Enabled SAP as service provider We use the following session cookies, which are all required to enable the website to function: • "route" is used for session stickiness • "careerSiteCompanyId" is used to send the request to the correct data center • "JSESSIONID" is placed on the visitor's device during the session so the server can identify the visitor • "Load balancer cookie" (actual cookie name may vary) prevents a visitor from bouncing from one instance to another • "rmk12" is used to determine whether the user has accepted the legacy cookie banner Cookies from provider SAPasserviceprovider are required and cannot be turned off Functional Cookies These cookies provide a better customer experience on this site, such as by remembering your login details, optimizing video performance, or providing us with information about how our site is used. You may freely choose to accept or decline these cookies at any time. Note that certain functionalities that these third-parties make available may be impacted if you do not accept these cookies. Consent to all Functional Cookies Show More Details Functional Cookies Provider Description Enabled Vimeo Vimeo is a video hosting, sharing, and services platform focused on the delivery of video. Opting out of Vimeo cookies will disable your ability to watch or interact with Vimeo videos. Cookie Policy Privacy Policy Terms and Conditions Consent to cookies from provider Vimeo Advertising Cookies These cookies serve ads that are relevant to your interests. You may freely choose to accept or decline these cookies at any time. Note that certain functionality that these third parties make available may be impacted if you do not accept these cookies. Consent to all Advertising Cookies Show More Details Advertising Cookies Provider Description Enabled LinkedIn LinkedIn is an employment-oriented social networking service. We use the Apply with LinkedIn feature to allow you to apply for jobs using your LinkedIn profile. Opting out of LinkedIn cookies will disable your ability to use Apply with LinkedIn. Cookie Policy Cookie Table Privacy Policy Terms and Conditions Consent to cookies from provider LinkedIn Confirm My Choices Reject All Cookies Accept

Requirements

Must-haves

Webster, MA, US
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
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
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
Experience implementing methodologies or process improvements
Ability to independently complete intermediate analyses and contribute to complex projects under managerial guidance

Nice-to-haves

Experience supporting actuarial, pricing, reserving, claims or predictive modeling functions strongly preferred
Prior experience with PowerBI preferred
Experience with Git, Bitbucket, source control or DevOps practices preferred

Application prep

Use the role’s language and application details while tailoring your materials.

Keywords to mirror

sql

Platform: careers-html
Effort: medium

Benefits

Benefits detected in the listing.

Dental

Vision

401(K)

Pto

Paid Time Off

Wellness