Property Underwriting Data & Automation Analyst

Lancashire Insurance Services Limited; Greater London; On-site; GBP 42,000 - 62,000; Full time

Job summary

Lancashire Insurance Services Limited in London is seeking a Delegated Underwriting Analyst to support underwriting and operations through data-driven processes. You will collaborate with the Property Team and leverage Excel and Power BI to analyze accounts, monitor performance, and improve pricing tools.

The role emphasizes data accuracy, strong organisational skills, and the ability to work independently and within a team in a fast-paced environment.

Qualifications

• Experience in an administrative or underwriting support role.
• Proficient data management and analysis using Excel and Power BI.
• Attention to detail and high accuracy.
• Strong organizational and time-management skills.
• Excellent written and verbal communication.
• Able to work independently and in a team.

Responsibilities

• Perform analysis on individual accounts and overall portfolio to track metrics throughout the year (rate/deductible/risk profile/region etc).
• Work with Exposure Management to peer review output/exposures.
• Assist with data input for Exposure Management, gathering bordereaux from brokers/portals if needed. Help manage workflow to ensure regular updates of all accounts.
• Creating and collaborating with Underwriters to complete pricing tools.
• Manage premium monitoring process - prepare for monthly/quarterly meetings using MI from dashboard.
• Manage Contract Performance monitoring using MI from dashboard.
• Verify bordereaux to ensure compliance with underwriting guidelines and limitations.
• Create and improve Regional loss scenarios across the Binder portfolio.
• Manage and assist with DU process, collecting all relevant info, answering queries. For lead accounts filling out basic info on forms.

Skills

Underwriting support

Data analysis

Excel

Power BI

Underwriting software

Attention to detail

Organizational skills

Communication skills

Independent working

Proactive attitude

Tools

Excel

Power BI

Underwriting software

Job description

Lancashire Insurance Services Limited in London is seeking a Delegated Underwriting Analyst to support underwriting and operations through data-driven processes. You will collaborate with the Property Team and leverage Excel and Power BI to analyze accounts, monitor performance, and improve pricing tools.

The role emphasizes data accuracy, strong organisational skills, and the ability to work independently and within a team in a fast-paced environment.