Bordereaux Analyst

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 a specialist Lloyd's and London Market consultancy. We are looking for a Bordereaux Analyst to be deployed as a G MASS consultant into one of our London Market insurance clients, working embedded within their delegated authority operations team.

You will be employed by G MASS and supported by us throughout the assignment, with ongoing oversight, development and access to insurance training and CII study support. This role suits someone with up to three years' insurance experience who wants to build specialist delegated authority and data skills.

You will own the receipt, validation and processing of premium and claims bordereaux from coverholders, MGAs and TPAs, making sure data is accurate, complete and compliant with contract terms.

Key Responsibilities:

• Tracking receipt of monthly premium and claims bordereaux against reporting schedules, and chasing late or incomplete submissions.
• Validating bordereaux data against binding authority contract terms, including limits, territories, classes of business and binder periods.
• Checking submissions against Lloyd's Coverholder Reporting Standards and internal data requirements, and raising data quality issues with coverholders.
• Loading and processing validated bordereaux into policy administration and bordereaux management systems.
• Reconciling premium bordereaux to cash received and to written premium, investigating and resolving discrepancies.
• Flagging potential contract breaches or unusual trends to delegated authority, underwriting and compliance teams.
• Producing internal reporting on bordereaux timeliness, data quality and outstanding issues.
• Supporting coverholder audits, renewals and wider delegated authority oversight activity as required.

• 1-3 years' experience within insurance, ideally in the Lloyd's or London Market (e.g. managing agent, syndicate, MGA, broker or TPA).
• Exposure to bordereaux, delegated authority or binding authority processing is strongly preferred.
• Advanced Excel skills (VLOOKUPs, pivot tables, reconciliation logic) and confidence working with large data sets.
• Comfortable learning policy administration and bordereaux management systems quickly.
• Methodical, detail-oriented and self-sufficient, able to deliver accurate work to fixed monthly and quarterly deadlines.
• Clear, professional communicator, able to manage queries with coverholders, brokers and underwriters.
• Degree educated or equivalent experience.

Permanent Contract

Salary: up to £40,000, depending on experience