Data Analyst - Delegated Underwriting

London, England, United Kingdom

12/17/2024

Job Description

The Role

We are looking for a Data Analyst to work within our Underwriting team for Delegated Authorities – North America. The team writes a mixture of commercial and personal lines across USA & Canada. Classes include Homeowners, Commercial Property, Commercial Liability, Automobile (APD & MTC) and Flood (RCBAP, Homeowners & Commercial). There will be an emphasis towards enhancing the team’s technological and analytical capabilities. This position will ideally suit an individual who is interested in building a career in underwriting with the opportunity as the role develops and embeds of working towards being responsible for their own allocated accounts.

Responsibilities

Key Responsibilities

• Understand and improve upon team’s current PowerBI analytics and reporting.
• Apply loss development curves across portfolio within analytics tools.
• Represent team across various Syndicate IT projects.
• Assist syndicate management with Target Operating Model based on desired future processes.
• Co-ordinate regulatory returns alongside relevant stakeholders.
• Assist the Underwriters for both new and renewal business liaising with brokers accordingly including analysing accounts.
• Handle business using actuarial pricing models adhering to any applicable Personal Authority Limits (PALs)
• Understand the application of catastrophe models (RMS or equivalent) for underwriting purposes.
• Liaise with and work alongside other key stakeholders such as claims, actuarial, delegated underwriting management and cat modelling teams.
• Calculate profit commission statements
  
  

Qualifications

Essential Skills & Experience

• ACII qualified or working towards.
• Ability to analyse, model and interpret data.
• Strong skills with Microsoft Excel especially Pivot Tables, vlookups & IF statements.
• Experience using software and functions such as MS Access, MS PowerBI, MS Power Automate/Flow, VBA/DAX and Python.
• Proficient with MI tools such as Qlik.
• Ability to use SQL.