CoreHRx Jobs

Apply in one click, save jobs and take free mock tests.

Register free Log in
Hiring? Post jobs with CoreHRx
My account
user

View & update profile

CAT Modeling (for one of Lloyd’s largest syndicates)

WNS Global Services Verified employer

Full time
Experience
10+ years
Location
Gurgaon
Work mode
Not stated
Posted 1 month ago Last checked 3 hr ago

You apply on WNS Global Services' website. CoreHRx takes you there after you sign in.

CoreHRx never asks candidates for money. If anyone does, .

Role at a glance

You will
  • An exciting opportunity for a Catastrophe Risk Analyst to join a leading Exposure Management team at one of Lloyd’s largest syndicates.
  • The successful candidate will be delivering cutting edge analytics to stakeholders across the business for the D&F Property class, which…
  • This is an excellent opportunity for a candidate looking to have a material impact at a top Lloyds’ syndicate and global (re)insurer.
Experience
10+ years
Must-have skills
Data AnalysisMS ExcelMicrosoft SQL ServerPivot TablesPower QueryProject Management

How well do your skills match this job?

Sign in to see your fit: the skills, experience and location this job asks for, checked against your profile.

Job description

Location: Gurugram, HR, India
Department: Other

Job Description

The Role

An exciting opportunity for a Catastrophe Risk Analyst to join a leading Exposure Management team at one of Lloyd’s largest syndicates. The successful candidate will be delivering cutting edge analytics to stakeholders across the business for the D&F Property class, which has seen significant growth over the last 12 months. This is an excellent opportunity for a candidate looking to have a material impact at a top Lloyds’ syndicate and global (re)insurer.

As an analyst, you will have a real ability to meaningfully influence the risk selection process. The successful candidate will look to work collaboratively with various internal stakeholders to ensure timely modelling analytics to support risk pricing and wider Catastrophe Management goals.

Skill mix: Account Modeling + Data Cleansing

CAT Modelers/ Sr. CAT Modelers:

Responsibilities:

  • Confident and timely delivery of analytics and the ability to explain how these analytics can help drive risk selection.
  • Use RMS and various other tools to deliver market leading analysis both on individual account and portfolio basis.
  • Work closely with the Natural Catastrophe Management team, across different regions, to ensure close communication across the team, consistent application of view of risk and contribute to cross-region analytics.
  • Create a narrative based on the modelling data and other sources to effectively provide a valuable summary of a certain risk and give advice to Underwriters on the strengths and weaknesses of both the data and the model’s ability to provide meaningful results. This includes communicating the concept of uncertainty.
  • Communicate risk metrics to key stakeholders.
  • Coordinate with the Analytics and Reporting team to ensure timely delivery of data required for internal and external reporting.

Skills and Experience:

  • Experience in a Cat Modelling role – RMS experience is highly desirable and D&F Property class experience is advantageous.
  • Highly numerate and logical – strong mathematical/statistical knowledge is advantageous.
  • Excellent business communication skills – ability to influence, negotiate, and listen.
  • Ability to manipulate large data sets with strong Excel and SQL skills.
  • Experience using Microsoft Power BI for analytics is desirable.
  • Intermediate/Advanced Experience with MS SQL is a strong advantage. Ability to build/design and manipulate queries to improve process.
  • Familiarity with another programming language such as VBA, .NET, R, Python is an advantage.

Asst. Manager - CAT Modeling

Responsibilities:

  • Lead and manage catastrophe modeling projects, ensuring timely and high-quality delivery of client and business requirements.
  • Review, validate, and approve exposure data, data scrubbing activities, quality checks, and model-ready datasets.
  • Manage and mentor a team of catastrophe modeling analysts, providing technical guidance, training, and performance coaching.
  • Oversee workload planning, resource allocation, and project prioritization to meet business objectives and service-level expectations.
  • Drive data quality initiatives by identifying process gaps, implementing controls, and ensuring adherence to quality standards.
  • Perform complex account, portfolio, and reinsurance analysis using catastrophe modeling platforms and internal tools.
  • Collaborate with onshore stakeholders, underwriters, brokers, actuaries, and client teams to resolve data and modeling-related queries.
  • Monitor project risks, track deliverables, and proactively communicate status, issues, and mitigation plans to management.
  • Develop and enhance standard operating procedures, best practices, and process improvement initiatives.
  • Review catastrophe model outputs, perform reasonability checks, and provide analytical insights to support business decisions.
  • Ensure compliance with organizational policies, audit requirements, and data governance standards.
  • Support transition activities, process documentation, knowledge management, and capability-building initiatives within the team.

Skills and Experience:

  • 10+ years of experience in Catastrophe Modeling, exposure management, and insurance analytics.
  • Bachelor's degree in Engineering, Mathematics, Statistics, Economics, Finance, Computer Science, Data Analytics, or a related quantitative discipline.
  • Strong hands-on experience with catastrophe modeling platforms such as RMS, AIR/Verisk, or equivalent industry-standard tools.
  • Proven expertise in exposure data review, data cleansing, financial validation, geo-coding, and portfolio quality assurance.
  • Demonstrated experience in leading teams, managing performance, and developing junior analysts.
  • Strong project management skills with the ability to manage multiple deliverables, stakeholders, and competing priorities.
  • Excellent understanding of insurance and reinsurance concepts, policy structures, CAT modeling methodologies, and financial terms.
  • Advanced Microsoft Excel skills, including complex formulas, Pivot Tables, Power Query, and data analysis techniques.
  • Strong analytical, problem-solving, and decision-making capabilities.
  • Excellent verbal and written communication skills with experience interacting with global stakeholders and senior leadership.
  • Experience driving process improvements, automation initiatives, and operational excellence programs.
  • Ability to work independently in a fast-paced environment while maintaining high levels of accuracy and quality.
  • Strong stakeholder management, collaboration, and client-facing skills.

Qualifications

Bachelor’s Degree in Mathematics/ Applied Mathematics/ Statistics/ Operations Research/ Actuarial Science

Company Description

WNS, part of Capgemini, is an Agentic AI-powered leader in intelligent operations and transformation, serving more than 700 clients across 10 industries, including Banking and Financial Services, Healthcare, Insurance, Shipping and Logistics, and Travel and Hospitality. We bring together deep domain excellence – WNS’ core differentiator – with AI-powered platforms and analytics to help businesses innovate, scale, adapt and build resilience in a world defined by disruption.

Our purpose is clear: to enable lasting business value by designing intelligent, human-led solutions that deliver sustainable outcomes and a differentiated impact. With three global headquarters across four continents, operations in 13 countries, 65 delivery centers and more than 66,000 employees, WNS combines scale, expertise and execution to create meaningful, measurable impact.

Key skills

Required

Data AnalysisMS ExcelMicrosoft SQL ServerPivot TablesPower QueryProject ManagementQuality AssuranceSQLStakeholder Management

Preferred

Power BIPython

Soft skills

CollaborationCommunicationDecision MakingLeadershipProblem Solving

Job market insights

29active Data Analysis jobs in Gurgaon
47active MS Excel jobs in Gurgaon
12active Microsoft SQL Server jobs in Gurgaon
81 more open jobs at WNS Global Services

Jobs asking for Data Analysis in Gurgaon also ask for

  • SQL34%
  • Python28%
  • MS Excel21%
  • Project Management21%
  • Power BI10%

From live job posts on CoreHRx, updated 2 Nov 2026. Skill figures count posts that list their skills; salary figures only posts that show a salary.

Questions about this job

How much experience does this job need?

The post asks for 10 Yrs experience.

Where is this job based?

In Gurgaon.

What kind of job is this?

It is a full time job.

How do I apply?

You apply on WNS Global Services' website. CoreHRx takes you there after you sign in.

This guide is for Indian job seekers preparing for SQL rounds in data analyst, data engineer, backend developer and database roles, from freshers to experienced professionals. It has 60 questions in three levels: easy covers joins, grouping and NULLs; medium covers window functions, CTEs, indexes and isolation levels; hard covers locking, MVCC, query tuning and classic puzzles such as login streaks and medians. Answers use ANSI SQL, with MySQL 8 and PostgreSQL notes where the two differ. Write each query against your own sample tables first, then compare your result with the sample answer.

Questions you may be asked

  1. What is the difference between WHERE and HAVING?
  2. What is the difference between DELETE, TRUNCATE and DROP?
  3. What is the difference between an INNER JOIN and a LEFT JOIN?
  4. What is the difference between a primary key and a unique key?

Get jobs in Gurgaon by email

Create a free profile and we email you new jobs in Gurgaon, at most once a week.

Similar jobs