Senior Catastrophe Portfolio Modeling Analyst

Position Summary

What will your job entail?

What You’ll Do

• Perform catastrophe modeling using RMS and AIR across multiple lines of business.
• Prepare, validate, and cleanse exposure data for modeling.
• Produce portfolio-level metrics such as PML, AAL, exposed limits, and tail-risk metrics.
• Build SQL queries, scripts, and tools to support automation and reporting.
• Provide technical and modeling support to underwriting, operations, and analytics teams
• Support catastrophe event response with exposure summaries and loss estimation.
• Maintain capacity tracking dashboards and reports.

Tech Stack You’ll Use

• Modeling Platforms: RMS (Risk Modeler, Underwrite IQ), AIR (Touchstone)
• Languages & Tools: SQL, Python (preferred), Excel/VBA, Alteryx
• Data: Exposure schedules, shapefiles, ELTs/EDMs, event results
• Cloud (Preferred): Azure Databricks, Azure Data Lake

Qualifications

Required

• 5+ years of catastrophe modeling or portfolio risk experience.
• Proficiency in RMS and/or AIR Touchstone.
• Strong SQL skills and experience with large datasets.
• Ability to support real-time event response activities.

· Strong communication skills.

Preferred / Nice-to-Have

• Experience with Python or R for data analysis and automation.
• Knowledge of reinsurance structures and portfolio risk metrics (PML, AAL, TVaR).
• Exposure to Azure Databricks or other cloud-based analytics platforms.
• Experience automating workflows using Alteryx or similar tools.
• Familiarity with geospatial data handling and mapping.

Core Competencies

• Analytical Thinking: Ability to interpret complex model outputs and portfolio metrics.
• Attention to Detail: Ensures accuracy in exposure data and modeling assumptions.
• Communication: Clearly conveys technical insights to non-technical stakeholders.
• Problem-Solving: Develops creative solutions for modeling challenges and data issues.

Ryan Specialty is an Equal Opportunity Employer. We are committed to building and sustaining a diverse workforce throughout the organization. Our vision is an inclusive and equitable workplace where all employees are valued for and evaluated on their performance and contributions. Differences in race, creed, color, religious beliefs, physical or mental capabilities, gender identity or expression, sexual orientation, and many other characteristics bring together varied perspectives and add value to the service we provide our clients, trading partners, and communities. This policy extends to all aspects of our employment practices, including but not limited to, recruiting, hiring, discipline, firing, promoting, transferring, compensation, benefits, training, leaves of absence, and other terms, conditions, and benefits of employment.

How We Support Our Teammates

Ryan Specialty seeks to offer our employees a comprehensive and best-in-class benefits package that helps them — and their family members — achieve their physical, financial, and emotional well-being goals. In addition to paid time off for company holidays, vacation, sick and personal days, Ryan offers paid parental leave, mental health services and more.

The wage range for this role considers many factors, such as training, transferable skills, work experience, licensure and certification, business needs, and market demands. The pay range is subject to change and may be modified in the future. Full-time roles are eligible for bonuses and benefits. For additional information on Ryan Specialty Total Rewards, visit our website https://benefits.ryansg.com/.

We provide individuals with disabilities reasonable accommodations to participate in the job application or interview process, to perform essential job functions, and to receive other benefits and privileges of employment in accordance with applicable law. Please contact us to request an accommodation at HR@Ryansg.com

The above is intended to describe this job's general requirements. It is not to be construed as an exhaustive statement of duties, responsibilities, or physical requirements. Nothing in this job description restricts management's right to assign or reassign duties and responsibilities to this job at any time. Reasonable accommodations may be made to enable individuals with disabilities to perform essential functions.