Graduate Bordereaux Analyst

G MASS; Greater London; On-site; GBP 27,000 - 33,000; Full time

Job summary

G MASS Consulting is a specialist Lloyd's and London Market consultancy. We are seeking a Graduate Bordereaux Analyst to be embedded with a London Market client, working within their delegated authority operations team.

You will be employed by G MASS and supported with training and CII study. This role suits someone with up to three years of insurance experience who wants to build specialist data and bordereaux skills.

Qualifications

• Up to three years' insurance experience preferred.
• Advanced Excel skills and ability to work with large data sets.
• Degree educated or equivalent experience.

Responsibilities

• Track receipt of monthly premium and claims bordereaux and chase late submissions.
• Validate bordereaux data against binding authority terms incl. limits, territories, classes and binder periods.
• Check submissions against Lloyd's Coverholder Reporting Standards and internal data requirements; raise data quality issues.
• 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.
• Produce internal reporting on bordereaux timeliness, data quality and outstanding issues.
• Support coverholder audits, renewals and wider delegated authority oversight.

Skills

Advanced Excel

Data analysis

Attention to detail

Communication skills

Self-sufficient

Education

Degree educated or equivalent experience

Tools

Bordereaux management systems

Policy administration systems

Job description

G MASS Consulting is a specialist Lloyd's and London Market consultancy. We are looking for a Graduate 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.

• Demonstrable interest in insurance and the London Market.
• An internship in insurance would be advantageous, particularly within Lloyd's or the London Market (e.g. managing agent, syndicate, MGA, broker or TPA).
• 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: £30,000