Lockton
Lockton Re is offering an exciting opportunity to join our dynamic and rapidly growing catastrophe modeling team. As part of a global reinsurance brokerage with a strong entrepreneurial culture, you will work alongside some of the industry’s most talented modelers, brokers, and actuaries, gaining exposure to a wide variety of clients with a wide variety of challenges to solve.
Key Responsibilities
Produce catastrophe modeling reports using both AIR/Verisk and RMS/Moody’s platforms across multiple perils and geographies.
Perform advanced data manipulation and transformation to clean, structure, and prepare large exposure datasets for modeling and analytical workflows using SQL, Excel, and other data tools.
Translate model results into meaningful insights to support reinsurance placement strategies, pricing, and portfolio optimization.
Build, maintain, and automate analytical workflows using SQL, Excel, and other data management tools.
Collaborate with brokers, actuaries, and data teams to deliver high‑quality analytics for reinsurance renewals, new business, and strategic projects.
Support model validation, sensitivity testing, and comparisons across model vendors and versions.
Contribute to process improvement initiatives and help shape the analytical direction of Lockton Re’s modeling practice.
Qualifications
3–5 years of experience in catastrophe modeling, preferably within a reinsurance brokerage, insurer, or modeling firm.
Proficiency in both AIR/Verisk and RMS/Moody’s modeling platforms (ideal).
Strong understanding of catastrophe model methodologies, including hazard, vulnerability, and financial modules, to interpret model results and communicate key drivers of loss.
Strong working knowledge of Excel (formulas, pivot tables, VBA preferred).
Advanced SQL skills required; experience with other languages (e.g., Python, R, VBA) a plus.
Familiarity with exposure data structures, reinsurance contract terms, and key loss metrics (AAL, OEP/AEP, TVaR, etc.).
Professional Competencies
Excellent communication skills, with the ability to clearly explain technical results to non‑technical audiences.
Strong time management and ability to balance multiple concurrent projects under tight deadlines.
High level of professionalism and attention to detail in all work deliverables.
Demonstrated collaboration and interpersonal skills—comfortable working across analytical and client‑facing teams.
Critical thinking mindset with a proactive approach to problem‑solving and continuous improvement.
Seniority level
Mid‑Senior level
Employment type
Full‑time
Job function
Design, Art/Creative, and Information Technology
Insurance
#J-18808-Ljbffr
Key Responsibilities
Produce catastrophe modeling reports using both AIR/Verisk and RMS/Moody’s platforms across multiple perils and geographies.
Perform advanced data manipulation and transformation to clean, structure, and prepare large exposure datasets for modeling and analytical workflows using SQL, Excel, and other data tools.
Translate model results into meaningful insights to support reinsurance placement strategies, pricing, and portfolio optimization.
Build, maintain, and automate analytical workflows using SQL, Excel, and other data management tools.
Collaborate with brokers, actuaries, and data teams to deliver high‑quality analytics for reinsurance renewals, new business, and strategic projects.
Support model validation, sensitivity testing, and comparisons across model vendors and versions.
Contribute to process improvement initiatives and help shape the analytical direction of Lockton Re’s modeling practice.
Qualifications
3–5 years of experience in catastrophe modeling, preferably within a reinsurance brokerage, insurer, or modeling firm.
Proficiency in both AIR/Verisk and RMS/Moody’s modeling platforms (ideal).
Strong understanding of catastrophe model methodologies, including hazard, vulnerability, and financial modules, to interpret model results and communicate key drivers of loss.
Strong working knowledge of Excel (formulas, pivot tables, VBA preferred).
Advanced SQL skills required; experience with other languages (e.g., Python, R, VBA) a plus.
Familiarity with exposure data structures, reinsurance contract terms, and key loss metrics (AAL, OEP/AEP, TVaR, etc.).
Professional Competencies
Excellent communication skills, with the ability to clearly explain technical results to non‑technical audiences.
Strong time management and ability to balance multiple concurrent projects under tight deadlines.
High level of professionalism and attention to detail in all work deliverables.
Demonstrated collaboration and interpersonal skills—comfortable working across analytical and client‑facing teams.
Critical thinking mindset with a proactive approach to problem‑solving and continuous improvement.
Seniority level
Mid‑Senior level
Employment type
Full‑time
Job function
Design, Art/Creative, and Information Technology
Insurance
#J-18808-Ljbffr