Actuarial Business Analyst – Property & Casualty Insurance (Hybrid)

About the role

As a Technical Analyst II at MAPFRE, you will develop, validate, and maintain critical data sets that support actuarial, pricing, and finance teams across the Property & Casualty business. You will work cross‑functionally to ensure data accuracy, drive insights, and improve operational efficiency.

Key responsibilities

• Build and maintain country‑wide datasets across all lines of business and systems.
• Develop, validate, and ensure the integrity of data used for business decision‑making.
• Optimize processes to guarantee data accuracy, consistency, and timeliness.
• Collaborate with Advanced Analytics, IT, and business stakeholders to support market pricing analyses.
• Develop complex SQL queries, views, and stored procedures for reporting and analytics.
• Identify and implement process improvements to enhance operational efficiency.
• Provide training, mentorship, and guidance to less experienced team members.

Required profile

• Bachelor’s degree in Actuarial Science, Data Analytics, Mathematics, Statistics, Computer Science, Information Systems, Economics, Business Analytics, or related field.
• 3+ years of experience in Property & Casualty insurance, preferably supporting actuarial, pricing, reserving, claims, or predictive modeling functions.
• Demonstrated ability to manage multiple workstreams and prioritize tasks effectively.

Required skills

• Advanced SQL development (complex joins, CTEs, window functions, performance optimization).
• Strong understanding of relational database concepts, data modeling, and data‑warehouse principles.
• Experience with PowerBI for data visualization.
• Familiarity with Git, Bitbucket, or other source‑control/DevOps practices.
• Ability to independently complete intermediate analyses and contribute to complex projects.

What we offer

• Competitive salary range $77,700 – $114,500 USD per year.
• Comprehensive benefits including flexible PTO, 401(k) with company match, medical/dental/vision coverage, STD, LTD, life insurance, FSA, HSA, and wellness programs.
• Career growth opportunities such as tuition reimbursement, leadership programs, and internal mobility.
• Purpose‑driven culture focused on trust, collaboration, inclusion, and social responsibility.