Bordereaux Analytics & Reporting Specialist

The Hartford; Greater London; Hybrid; GBP 45,000 - 65,000; Full time

Job summary

The Hartford is seeking a disciplined Bordereaux Analyst to join our London team. You will manage the full lifecycle of bordereaux data, ensure accuracy, and support regulatory reporting for delegated authority arrangements.

You will work with Underwriting, Finance and external stakeholders to deliver high-quality analysis, dashboards and management information, driving data quality improvements and timely reporting.

Qualifications

• Strong understanding of bordereaux management and governance.
• Experience with Lloyd's and delegated authority reporting.
• Advanced Excel skills for data analysis and reconciliation.

Responsibilities

• Manage end-to-end bordereaux receipt, validation, processing and upload.
• Maintain bordereaux schedules and perform data quality checks.
• Analyse bordereaux data and investigate anomalies with stakeholders.
• Produce reporting dashboards and MI for underwriting and governance.
• Support EPI reporting and quarterly review processes.

Skills

Excel skills

Pivot Tables

XLOOKUP/VLOOKUP

Data cleansing

Reconciliation

Data analysis

Data mapping

Data integration

Reporting

Stakeholder communication

Problem solving

Education

A-Levels or equivalent

Insurance qualifications (CII/LM1/LM2) desirable

Tools

Atlas

DCOM

IMR

Crystal

Job description

The Hartford is seeking a disciplined Bordereaux Analyst to join our London team. You will manage the full lifecycle of bordereaux data, ensure accuracy, and support regulatory reporting for delegated authority arrangements.

You will work with Underwriting, Finance and external stakeholders to deliver high-quality analysis, dashboards and management information, driving data quality improvements and timely reporting.