Graduate Bordereaux Analyst

. Own the receipt, validation and processing of premium and claims bordereaux from coverholders, MGAs and TPAs .

Posted 9/26/2026full-timeLondon • United KingdomEntry Level💰 £30,000 per yearWebsite

Key responsibilities & impact

Own the receipt, validation and processing of premium and claims bordereaux from coverholders, MGAs and TPAs
Track receipt of monthly premium and claims bordereaux against reporting schedules and chase late or incomplete submissions
Validate bordereaux data against binding authority contract terms, including limits, territories, classes of business and binder periods
Check submissions against Lloyd's Coverholder Reporting Standards and internal data requirements, raising data quality issues with coverholders
Load and process validated bordereaux into policy administration and bordereaux management systems
Reconcile premium bordereaux to cash received and written premium, investigating and resolving 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

What you’ll need

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

Comp & perks