HFG Insurance Recruitment
Bordereaux Contractor (3-6 Months)
How your CV stacks up
Upload your CV to see how well it fits this job role
?%
New Role: Bordereaux Contractor (3-6 Months)
MGA
City of London / Hybrid / Remote
I am currently partnered with a leading MGA who are seeking a Bordereaux Contractor to join their business on a contract project basis.
This role will be assisting with bordereaux related work including but not limited to; ensuring records are accurate and up to date, identify and resolve data quality issues, extract large datasets from SQL, reconciling bordereaux data, and more.
My client is looking for someone with extensive bordereaux/data mapping experience who can come in and get stuck into the project.
Key Responsibilities
Bordereaux Management
- Own the production, validation and delivery of premium, claims and exposure bordereaux.
- Review bordereaux received from coverholders, TPAs and internal underwriting systems.
- Ensure bordereaux comply with binder and capacity provider reporting requirements.
- Identify and resolve data quality issues before reports are issued.
Reasons to use Rodeo
Start with a chat, not a search bar
Grad scheme, placement, apprenticeship? Not sure what you want yet — that's fine. Your agent talks it through with you and turns "I have no idea" into a shortlist.
It searches the market for you
Every day your agent scans the market matching roles against what actually matters to you, not just keywords on a CV.
Only hits
No noise. No "maybe this fits." Just roles with a clear explanation of why they're right — and where to focus when applying.
Data Extraction & SQL
- Extract large datasets directly from SQL databases.
- Write or modify SQL queries to obtain underwriting, premium, claims and exposure data.
- Build repeatable extraction processes where possible.
- Support ad hoc reporting requests from underwriting, actuarial and finance teams.
Data Reconciliation
- Reconcile bordereaux against:
- Policy administration systems
- Claims systems
- Finance/ledger data
- Capacity provider reports
- Investigate discrepancies and trace issues back to source systems.
- Produce reconciliation packs with clear audit trails.
Get help with your application
Your very own career expert that helps elevate your application to the next level.
Data Quality & Cleansing
- Identify missing or inconsistent data.
- Standardise fields and formats.
- Improve data integrity ahead of migration or reporting exercises.
- Recommend process improvements to reduce future errors.
Capacity Transition Support
- Prepare historical data for a new capacity provider.
- Understand reporting requirements under the outgoing arrangement.
- Map existing data to the incoming carrier's requirements.
- Produce historical loss and premium triangles or datasets for due diligence.
- Answer queries from the new carrier regarding historical performance.
“It took my CV and asked me questions relevant to understanding what kind of jobs to suggest for me. Suggestions were almost perfect. Jobs were exactly what I’ve been looking for.”
Jessica, London
Skills