At a Glance
- Tasks: Manage and validate bordereaux data, ensuring accuracy and compliance.
- Company: Leading MGA in the heart of London with a hybrid work model.
- Benefits: Flexible remote work, competitive pay, and valuable industry experience.
- Other info: Join a dynamic team with opportunities for professional growth.
- Why this job: Dive into data management and make a real impact on key projects.
- Qualifications: Experience in bordereaux management and SQL data extraction required.
The predicted salary is between 58500 - 71500 £ per year.
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, identifying and resolving data quality issues, extracting 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.
- 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, and capacity provider reports.
- Investigate discrepancies and trace issues back to source systems.
- Produce reconciliation packs with clear audit trails.
- 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.
Bordereaux Contractor (3-6 Months) in City of London employer: High Finance (UK) Limited
Join a leading specialty insurer in London, where you will thrive in a collaborative and innovative work culture that values your expertise as a Specialty & Property Pricing Actuary. With competitive salaries and bonuses, along with ample opportunities for professional growth and mentorship, this role offers a unique chance to influence pricing strategies in a dynamic Lloyd's market while working closely with senior stakeholders. Experience a supportive environment that encourages your development and rewards your contributions.
