Bordereaux Data Analyst - Lloyd's Market

G MASS; Greater London; On-site; GBP 24,000 - 40,000; Full time

Job summary

G MASS Consulting is seeking a Bordereaux Analyst to be deployed into a London Market client’s delegated authority operations team. You will own receipt, validation and processing of premium and claims bordereaux from coverholders, MGAs and TPAs and ensure data quality in line with contract terms.

With 1–3 years in insurance and strong Excel skills, you will work within a supportive environment offering CII study support and ongoing training. This is a permanent contract based in London.

Qualifications

• 1–3 years' insurance experience, Lloyd's or London Market preferred.
• Exposure to bordereaux or binding authority processing preferred.
• Proficient in Excel and data reconciliation.

Responsibilities

• Track receipt of monthly premium and claims bordereaux against reporting schedules and chase late or incomplete submissions.
• Validate bordereaux data against binding authority terms, including limits, territories and binder periods.
• Check submissions against Lloyd's Coverholder Reporting Standards and internal data requirements; raise data quality issues with coverholders.
• Load and process validated bordereaux into policy administration and bordereaux management systems.
• Reconcile premium bordereaux to cash received and to written premium; investigate discrepancies.
• Flag potential contract breaches or unusual trends to delegated authority, underwriting and compliance teams.
• Produce internal reporting on bordereaux timeliness, data quality and outstanding issues.
• Support coverholder audits, renewals and wider delegated authority oversight activity as required.

Skills

Advanced Excel (VLOOKUP, pivot tables)

Data analysis

Communication skills

Attention to detail

Education

Bachelor's degree or equivalent experience

Tools

Bordereaux management systems

Policy administration systems

Excel data reconciliation

Job description

G MASS Consulting is seeking a Bordereaux Analyst to be deployed into a London Market client’s delegated authority operations team. You will own receipt, validation and processing of premium and claims bordereaux from coverholders, MGAs and TPAs and ensure data quality in line with contract terms.

With 1–3 years in insurance and strong Excel skills, you will work within a supportive environment offering CII study support and ongoing training. This is a permanent contract based in London.