Technical Analyst II / Business Intelligence Analyst (Hybrid)

Summary

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.