2 days ago
London, United KingdomStaff+
Responsibilities
- Assess and modernise the existing BI architecture and reporting ecosystem.
- Design the semantic layer within Databricks and reshape reporting and ETL processes.
- Develop scalable, governed sandbox environments for ad hoc analysis and self-service reporting.
- Enhance BI tooling, functionality, user experience, and reporting reliability.
- Support release management and deployment for the reporting environment.
- Work with the Data team, BI Developers, and Quality Assurance & Controls Lead to deliver the future BI model.
- Interpret complex data, identify anomalies, and support underwriting performance KPI reporting.
Requirements
- Advanced expertise in data engineering and BI architectural design.
- Strong data-modelling expertise, including dimensional modelling and star and snowflake schemas.
- Demonstrable experience within the company or the Lloyd’s insurance market.
- Experience architecting and delivering governed sandbox environments within visualisation tools.
- Experience within a delegated business or MGA is preferred but not essential.
- Strong SQL skills and experience with DAX, M, or Python.
- Experience with Qlik, ThoughtSpot, Tableau, or Power BI.
- Familiarity with medallion data architecture and Databricks or an equivalent data lake.
- Familiarity with Azure DevOps or GitHub.
- Understanding of underwriting performance KPIs and their calculations.
About CFC
CFC is a London‑headquartered specialist insurer that builds technology‑driven products for businesses, with particular strength in cyber and other emerging risks. Founded in 1999, it underwrites lines including cyber, intellectual property, management liability, medical malpractice, product recall, and property & casualty, distributed primarily through brokers worldwide. CFC serves customers in over 90 countries and offers coordinated incident response to help clients manage cyber incidents from notification to resolution.
