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’ll 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. Our ideal candidate is self-driven, hardworking, and intellectually curious - someone who thrives on solving complex problems and has a natural aptitude for understanding technical concepts and providing meaning to model results. This role offers significant room for professional growth, innovation, and impact within a team that values collaboration, initiative champions, and continuous learning.
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.
- Utilize AI to push analytical capabilities forward, leveraging domain knowledge to create and build differentiating tools and solutions.
- 3–5 years of experience in catastrophe modeling, preferably within a reinsurance brokerage, insurer or reinsurer.
- Proficiency in both AIR/Verisk and RMS/Moody’s modeling platforms is ideal.
- Demonstrate 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.