Insurance Data Professional - Bordereaux & Snowflake
Contract | 6 months | Outside IR35 | Hybrid, Central London | Start ASAP
The role
A UK insurer needs a hands-on, pragmatic insurance data professional to join its data team on an interim basis. This is a business-and-technical hybrid, not a pure data engineering role. You will own the monthly flow of bordereaux data from a large panel of MGAs and TPAs, keep it clean and reconciled, and turn it into trusted reporting, working across data operations, data quality, reconciliation, governance and BI.
You will be operating in a fast-moving, lightweight environment where data arrives in varied and non-standard formats and needs real judgement to sort out. There is no time to coach, so you will need to be self-sufficient and comfortable getting your hands dirty from day one.
What you'll be doing
- Managing the monthly collection, validation and ingestion of policy, claims and quote bordereaux from multiple MGAs and TPAs
- Working directly with MGAs and partners to chase and resolve data submission issues, handling non-standard files and manual interventions
- Maintaining and enhancing Snowflake data structures, marts and reporting datasets, and writing and optimising the SQL behind ingestion, transformation and reporting
- Running end-to-end reconciliation (raw through to reporting output), control-total checks, roll-forwards and variance analysis, with handover to Finance
- Defining and improving data quality controls, lineage and governance, and helping remediate existing audit and control findings
- Building and maintaining Power BI (and Metabase) reporting for business users
- Supporting onboarding of new distribution partners and defining their data requirements
What we're looking for
The primary requirement is genuine insurance data operations experience. You must have worked hands-on with insurance operational data, ideally one or more of:
- Bordereaux processing
- MGA / TPA data management
- Delegated authority operations
- Insurance policy, claims, premium or exposure data
- Insurance reconciliation processes
This can come from a carrier, MGA, broker, insurtech or specialty environment, personal lines, commercial or specialty.
Alongside that, strong technical capability:
- Snowflake data warehousing, hands-on
- Advanced SQL (ingestion, transformation, reconciliation)
- Azure
- Power BI (Metabase useful)
- Data quality management, reconciliation, control frameworks, data lineage and governance
Just as important, the right approach: pragmatic, hands-on, self-directing, and able to operate across both business and technical conversations in a small, fast-paced team with an immature data estate.
The detail
Six months, Outside IR35. hybrid with time on-site in central London, immediate start. Moving very quickly, profiles reviewed within 24 hours.
#J-18808-Ljbffr
Insurance Data Consultant in London employer: SR2 REC LTD
SR2 REC LTD is an exceptional employer, offering a dynamic work environment in the heart of London where innovation thrives. With a strong focus on employee growth and development, we provide opportunities for our team members to enhance their skills while working on cutting-edge authentication and identity projects. Our collaborative culture fosters teamwork and creativity, making it a rewarding place for professionals looking to make a meaningful impact in the tech industry.
