Bordereaux Data & Reporting Analyst

The Hartford; City Of London; On-site; GBP 45,000 - 65,000; Full time

Job summary

The Hartford in London is seeking an INTL Bordereaux Analyst to manage end-to-end bordereaux data, validation and reporting for delegated authority, ensuring regulatory and Lloyd’s compliance while collaborating with Underwriting, Claims and Finance.

The role requires advanced Excel skills, data analysis and experience with Lloyd’s market systems; progress toward insurance qualifications (CII LM1/LM2) is desirable and a commitment to ongoing professional development.

Qualifications

• Experience with bordereaux, delegated authority or underwriting operations.
• Understanding of Lloyd's market processes and regulatory requirements.
• Ability to validate, reconcile and quality-check data.

Responsibilities

• Manage receipt, validation and processing of bordereaux data.
• Produce reporting and MI dashboards for underwriting and governance.
• Support governance and regulatory reporting with data quality checks.

Skills

Advanced Excel (Pivot Tables, XLOOKUP)

Data analysis

Attention to detail

Strong communication

Problem solving

Education

A-Level or equivalent

Degree-level education advantageous

Insurance qualifications (CII LM1/LM2) desirable

Tools

Atlas

DCOM

IMR

Crystal

Job description

The Hartford in London is seeking an INTL Bordereaux Analyst to manage end-to-end bordereaux data, validation and reporting for delegated authority, ensuring regulatory and Lloyd’s compliance while collaborating with Underwriting, Claims and Finance.

The role requires advanced Excel skills, data analysis and experience with Lloyd’s market systems; progress toward insurance qualifications (CII LM1/LM2) is desirable and a commitment to ongoing professional development.