Reinsurance & Loss Trends Analyst Sr (Hybrid Webster or Boston)

MAPFRE•Webster, MA

1d•Hybrid

About The Position

The Reinsurance & Loss Trends Senior Analyst delivers analytical insights that shape reinsurance strategy, loss monitoring, and operational decision-making across the organization. This role applies intermediate to advanced analytical techniques in alignment with internal policies, while continuously adapting methodologies to meet evolving business needs. The Senior Analyst plays a critical role in validating data integrity, identifying performance drivers, and producing reinsurance and loss trend reporting that directly supports the effectiveness of the Reinsurance & Loss Trends function and the Company’s overall financial performance. The role partners closely with cross‑functional stakeholders to translate complex data into clear, actionable insights.

Requirements

Bachelor’s degree in Science, Actuarial Mathematics, Statistics, or a related field (required).
3–5 years of experience in a related analytical, reinsurance, or insurance role (required).
Demonstrated experience performing intermediate quantitative analyses (required).
Strong analytical and problem-solving skills, with the ability to independently manage complex data and analytical requests.
Experience with catastrophe modeling, actuarial studies, or detailed claims reconciliation.
Proven experience using business intelligence tools, particularly Power BI, to deliver decision‑oriented reporting.
Solid technical proficiency in SQL, Python and/or R, and advanced Excel, with experience working with large datasets.
Strong understanding of financial, operational, and risk-related data; insurance or reinsurance experience strongly preferred.
Demonstrated knowledge of reinsurance structures (treaty vs. facultative), accounting principles, and contractual/legal language.
Ability to clearly communicate technical findings to non‑technical audiences and senior leadership.
Highly detail‑oriented with a strong focus on data accuracy, governance, and continuous improvement.

Responsibilities

Analyze and validate large, complex financial, operational, portfolio, and claims datasets to identify patterns, drivers, and current or emerging loss trends.
Model and project loss frequency, severity, and financial impact; produce projections and scenario analyses based on current experience.
Apply analytical, financial, and decision‑analysis techniques to evaluate business scenarios and support data-driven recommendations.
Design, build, and maintain interactive Power BI dashboards to monitor performance metrics, cost drivers, loss trends, and key reinsurance indicators.
Develop, optimize, and maintain SQL queries to extract, transform, and analyze data from multiple internal systems.
Utilize SQL, Python, R, and advanced Excel to support analytical modeling and reporting.
Document analytical workflows, data definitions, metrics, and reporting standards to improve transparency and scalability.
Support day‑to‑day execution and administration of ceded reinsurance programs, including excess of loss (XOL), quota share (Q/S), and facultative placements.
Prepare detailed monthly and quarterly financial and operational reports for reinsurers and internal management.
Support forecasting, budgeting, performance monitoring, and reconciliation activities.
Review reinsurance contracts to ensure compliance with contractual terms, accounting standards, and internal policies.
Lead and support internal and external reinsurer audits, including detailed analysis of claims and underwriting data.
Maintain a strong focus on data quality, controls, and continuous process improvement.
Develop actionable insights on risk transfer opportunities and reinsurance market trends; make recommendations to enhance profitability.
Serve as a primary point of contact for brokers and reinsurers.
Collaborate with claims, underwriting, actuarial, finance, legal, technical, and risk teams to align reinsurance strategy with business objectives and support informed decision-making.