Bordereaux Analyst

Westfield Specialty; Greater London; On-site; GBP 40,000 - 55,000; Full time

Job summary

A prominent insurance firm in the UK is seeking a Bordereaux Technician to manage and analyze data related to insurance coverage. Responsibilities include processing bordereaux, ensuring compliance with regulatory standards, and collaborating with stakeholders. The ideal candidate should have strong Excel skills, experience in data analysis, and familiarity with Lloyd’s practices. A-level education and desire for relevant professional qualifications are preferred for this role.

Qualifications

• Experience in delegated authority, bordereaux management, insurance data analysis.
• Knowledge of Lloyd’s and/or company market bordereaux practices.

Responsibilities

• Receive, review and process incoming bordereaux.
• Ensure data quality and compliance with Lloyd’s standards.
• Liaise and collaborate with internal teams.

Skills

Strong Excel skills

Experience with data integration/mapping tools

Strong analytical and problem-solving skills

Good communication with internal and external stakeholders

Education

A-level standard

Relevant professional qualifications (CII, LM1/LM2)

Tools

Atlas

DCOM

IMR

Crystal

Job description

About Us

Founded in 1848, Westfield is a global leader in property and casualty insurance, delivering superior risk insights and innovative solutions to customers through a diverse portfolio of insurance products. Westfield underwrites commercial, personal, surety, and specialty lines of coverage through a network of leading independent agents and brokers in the United States and specialty products through Lloyd’s of London Syndicate 1200. As a mutual insurance company with more than 3,000 employees, Westfield has revenues in excess of $4 billion and more than $10 billion in assets.

Key Accountabilities:

Bordereaux Management

• Receive, review and process incoming bordereaux from Coverholders and TPAs in line with binding authority agreements.
• Ensure data quality and compliance with Lloyd’s Coverholder reporting standards and other regulatory requirements.
• Maintain bordereaux schedules and ensure timely ingestion into internal systems.
• Create reports and trend analysis as required

Data Validation and Upload

• Cleanse, map and upload bordereaux to internal systems.
• Identify and investigate anomalies, missing data and contract breaches.
• Resolve queries from outsource partners e.g. coverholders, brokers, TPAs

Stakeholder Collaboration

• Liaise and collaborate with internal teams, including underwriting, finance, claims, external partners, Coverholders, Broker and TPAs
• Support Underwriters in monitoring binder performance.
• Highlight and escalates persistent data or performance issues.
• Support the Bordereaux Manager in handling queries and reporting requirements

Role Requirements:

• Prior experience in a Bordereaux Technician or Analyst role within the Lloyd’s (or Company) Market
• Familiarity with Lloyd’s regulatory framework and underwriting processes
• Strong understanding of bordereau types: premium, claims and risk

Skills & Competencies:

• Strong Excel skills (pivot tables, lookups, data cleaning)
• Experience with data integration/mapping tools
• Understanding of bordereaux formats, mapping and validation techniques
• Ability to interpret risk, premium and claims datasets
• Strong analytical and problem-solving skills
• Excellent attention to detail and organisational skills
• Good communication with internal and external stakeholders
• Ability to manage deadline, proactive approach to data quality and improvements

Qualifications & Experience:

• Experience in delegated authority, bordereaux management, insurance data analysis
• Knowledge of Lloyd’s and/or company market bordereaux practices including experience with systems such as Atlas, DCOM, IMR & Crystal
• Educated to at least A-level standard
• Relevant professional qualifications e.g. CII, LM1/LM2 preferrable (or desire to work towards)

This job description describes the general nature and level of work performed in this role. It is not intended to be an exhaustive list of all duties, skills, responsibilities, knowledge, etc. These may be subject to change and additional functions may be assigned as needed by management. #WSPI