Catastrophe Modeler
Minneapolis, MN, United States8h ago
Key details
- Location
- Minneapolis, MN, United States
- Work style
- Onsite
- Level
- Mid level
- Experience
- 3–5 yrs
- Function
- other
- Focus area
- other
- Posted
- 8h ago
Skills
About the role
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.
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.
- 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.
How well do you match this job?
Free account needed to apply or save. It takes a minute, and we'll bring you right back to this job.