Analyst - CAT Modelling

Xceedance; Bengaluru; On-site; INR 600,000 - 900,000; Full time

Job summary

Xceedance in Bengaluru, India is seeking a data-exposure specialist to capture precise exposure information, manage policy data, and deliver timely reports across multiple insurance lines.

The role emphasizes analytical thinking, advanced Excel/VBA skills, and effective communication with onshore teams to ensure accurate, timely results.

Qualifications

• Masters in applied mathematics/ statistics/ economics/ Insurance domain
• Excellent analytical skills
• Basic excel knowledge such as using VLOOKUP and running pivots
• Good problem-solving skills
• Good presentation skills
• Advance Excel/VBA

Responsibilities

• To ensure exposure information is captured accurately within the timeline specified and understand basic rules of exposure management.
• Gain understanding of different insurance coverages and policy specific data for coverages.
• Recognize and comprehend ground level data and associated policy coverages in Excel and allied software for reporting.
• Data capture and weekly/monthly reporting; analyze data for lines of business including Offshore Energy, Offshore Construction, property, terrorism, marine, construction, cargo, hull.
• Use third-party software to capture exposure information like insured values, financial limits & retention for different lines of business.
• Daily interaction with onshore aggregation team, underwriters, and colleagues to clarify queries.
• Produce aggregate reports for all classes of business as per ACCORD standard on monthly and ad hoc basis.
• Understand worldwide geography and address formats; ensure accurate positioning and cleansing of address data.
• Ensure clear communication with onshore counterparts before final delivery.
• Work under pressure and maintain flexibility; document processes and ensure quicker resolution of queries.
• Review processes regularly to identify improvements and opportunities.

Job description

What youll be doing:

• To ensure exposure information is captured in a precise and accurate manner and within the timeline specified. Understand and put to practice the basic rules of exposure management.
• Gain a deep understanding of different insurance coverages, know location and policy specific data pertaining to different coverages.
• Recognize and comprehend ground level data and associated policy coverages in excel and in allied software to carry out meaningful reporting.
• Data Capture, reporting on a weekly / monthly duration, Analysis of data for different lines of business including Offshore Energy account, Offshore Construction policies, property, terrorism, marine, construction, cargo, hull etc.
• Use of third-party software for the capturing exposure information like insured values, financial limits & retention for different lines of business
• Daily interaction with onshore aggregation team/ underwriters / colleagues to clarify and answer associated queries.
• Produce aggregate report for all class of business as per ACCORD standard on monthly and as and when needed on ad hoc basis.
• Understand worldwide geography and address formats, different occupancies and be responsible for the accurate positioning, cleansing and exactness of worldwide Address data.
• Ensure clear and concise communication with the onshore counterparts before final delivery of the project.
• Display good ability to work under pressure and ensure flexibility in working.
• Ensuring documentation of processes is always up to date.
• Ensuring onshore communication is necessary, clear, precise, complete & ensuring quicker resolution of queries.
• Would be required to review the process on a regular basis to understand the scope of improvement areas and identify new process opportunities.

Qualifications & Experience

• Masters in applied mathematics/ statistics/ economics/Insurance domain
• Excellent analytical skills
• Basic excel knowledge such as using VLOOKUP and running pivots
• Good problem-solving skills
• Good presentation skills
• Advance Excel/VBA