Graduate Bordereaux Analyst
Core
Processing and validating premium and claims bordereaux from coverholders, MGAs, and TPAs to ensure data accuracy and compliance with contract terms for London Market insurance clients.
Role type
Graduate Bordereaux Analyst
Builds
Accurate bordereaux data feeds into policy administration and bordereaux management systems for delegated authority operations.
Domain
Insurance, London Market, Delegated Authority
Required skills
Advanced Excel (VLOOKUPs, pivot tables, reconciliation), Data validation, Contract compliance checking, Data reconciliation, Internal reporting, Audit support
Preferred skills
Insurance internship experience, Lloyd's or London Market exposure, Policy administration systems knowledge
Technologies
Policy administration systems, Bordereaux management systems, Excel
Responsibilities
Tracking receipt of monthly premium and claims bordereaux against reporting schedules, Validating bordereaux data against binding authority contract terms, Loading and processing validated bordereaux into systems, Reconciling premium bordereaux to cash received and written premium, Flagging potential contract breaches or unusual trends, Producing internal reporting on bordereaux timeliness and data quality
Seniority
Graduate, entry-level IC