Skip to main content
CFC UNDERWRITING LIMITED
Financial Services

Principle BI Architect & Engineer

Sponsorable London Full-time Posted 4 days ago
Licensed sponsorA-ratedsince at least 2021 6 visas sponsored in 202522 in 2021–24 Sponsor check

The advert

As posted by CFC UNDERWRITING LIMITED

CFC is looking for an experienced BI Architect & Engineer to help establish a single source of truth for our underwriting performance reporting.

Sitting within our MI & Data Insights team, you’ll assess and redesign our existing BI ecosystem, creating a more streamlined, scalable and efficient reporting service. This is a hands-on role combining data engineering and BI architecture, with the opportunity to shape how data products and reporting solutions are designed and delivered across the business.

Working closely with our Data team, BI Developers and Quality Assurance & Controls Lead, you’ll take the lead on assessing and modernising our existing BI architecture, streamlining pipelines and creating a scalable model that’s fit for the future. 

You’ll design the semantic layer within Databricks, reshape reporting and ETL processes, and enhance our tooling to improve both functionality and the user experience. You’ll also develop a governed sandbox model that gives colleagues greater freedom to undertake ad hoc analysis and self-service reporting, while ensuring the right controls are in place. Alongside this, you’ll support release management and deployment, helping us build a more efficient, reliable and scalable reporting environment.

You’ll bring advanced expertise across both data engineering and BI architectural design, alongside the judgement to balance long-term technical ambition with practical delivery.

You’ll ideally have

  • Strong data-modelling expertise, including dimensional modelling and star and snowflake schemas.
  • Experience architecting and delivering governed sandbox environments within visualisation tools.
  • Demonstrable experience within the company or Lloyd’s insurance market.
  • Experience within delegated business or an MGA, although this is preferred rather than essential.
  • Strong SQL skills, alongside experience with languages such as DAX, M or Python.
  • Experience with visualisation platforms such as Qlik, ThoughtSpot, Tableau or Power BI.
  • Familiarity with medallion data architecture and Databricks or an equivalent data lake.
  • Familiarity with Azure DevOps or GitHub.
  • An understanding of underwriting performance KPIs and the calculations behind them.
  • The ability to interpret complex data and identify anomalies.

Our estimate from the job title

Likely occupation
SOC 2133 · IT business analysts, architects and systems designers
Going rate
£54,900 a year (£28.15/h)estimate
Visa route
Likely eligible for Skilled Worker sponsorship
Visa salary for this occupation
£54,900 · new entrants £38,400estimate
Typical UK pay
£60,288 median full-time

The employer picks the real occupation code on the Certificate of Sponsorship. If it picks a different one, the visa salary changes. How we read this

CFC UNDERWRITING LIMITED

Sponsor licence
A-rated · Worker
Visa sponsorships
22 · 2021–24
Visa route
Skilled Worker
Industry
Financial Services
Location
London

CFC UNDERWRITING LIMITED is a licensed UK visa sponsor (A-rated). Home Office figures released under the Freedom of Information Act show CFC UNDERWRITING LIMITED assigned 22 Certificates of Sponsorship in 2021–24 and 6 in 2025 for Skilled Worker and Global Business Mobility visas.

Source: FOI 2025/12841, OGL v3.0.

All roles at CFC UNDERWRITING LIMITED
4 days ago Free account
Apply