Bordereaux Contractor (3-6 Months)

New Role: Bordereaux Contractor (3-6 Months)MGACity of London / Hybrid / RemoteI 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 ResponsibilitiesBordereaux ManagementOwn 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 and SQLExtract 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 ReconciliationReconcilebordereaux against:Policy administration systemsClaims systemsFinance/ledger dataCapacity provider reportsInvestigate discrepancies and trace issues back to source systems.Produce reconciliation packs with clear audit ..... full job details .....