Back to jobs

Principal BI Architect & Engineer

London, United Kingdom, UK - London

Actively hiring, first seen by us 1 day ago
Pay
Pay not listed
Work setting
Hybrid — work setting source
Work setup in the employer’s posting: Hybrid
From the employer’s posting
Employment
Fixed-term — employment source
Employment type Fixed Term - Full Time
Read the full posting

What you’ll work on

Full posting

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.

  • Design the semantic layer within Databricks

  • Reshape reporting and ETL processes and enhance BI tooling

  • Develop a governed sandbox model for ad hoc analysis and self-service reporting

  • Support release management and deployment of reporting solutions

From the employer’s posting
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 design the semantic layer within Databricks
reshape reporting and ETL processes, and enhance our tooling
develop a governed sandbox model that gives colleagues greater freedom to undertake ad hoc analysis and self-service reporting
support release management and deployment

What you’ll bring

All qualifications

Core experience

  • Experience architecting and delivering governed sandbox environments within visualisation tools.
  • Experience within delegated business or an MGA, although this is preferred rather than essential.
  • Strong Python and SQL skills - alongside experience with languages such as DAX, M etc.
  • 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 GitHub.
Qualification wording
Experience architecting and delivering governed sandbox environments within visualisation tools.
Experience within delegated business or an MGA, although this is preferred rather than essential.
Strong Python and SQL skills - alongside experience with languages such as DAX, M etc.
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 GitHub.
Apply at Cfc

Posting record

Report an error

Actively hiringFirst seen by us 1 day ago, still listed, and not a repost of an earlier posting.

Status in our records
Live
First seen by us
Nov 18, 20261 day ago
Recorded sightings
2
Last seen by us
Nov 19, 2026

These dates show when we found the posting. Check the employer’s website to confirm it is still accepting applications.

How this job compares

Time since we first saw it

Day 1

Early. Similar jobs usually come down between day 6 and day 56.

At Cfc, jobs usually come down by about day 32.

From 14,152 similar postings that came down, and 6 of Cfc’s. Coming down is not always a hire.

Cfc is hiring

6 open jobs

Open jobs by the week we first saw them, last 12 weeks.

  • Hiring at a steady pace
  • Takes jobs down at a usual pace
Hiring record

See how this role fits your experience

Add your resume and we’ll mark which of these tools you already use, and point out anything in the posting that could rule you out.

  • Python
  • SQL
  • Azure
  • Databricks
  • Power BI
  • Qlik
  • Tableau
Where the posting names them
- Experience within delegated business or an MGA, although this is preferred rather than essential. - Strong Python and SQL skills - alongside experience with languages such as DAX, M etc. - 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 GitHub. - An understanding of underwriting performance KPIs and the calculations behind them.
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. About you
- 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 GitHub.
- Strong Python and SQL skills - alongside experience with languages such as DAX, M etc. - Experience with visualisation platforms such as Qlik, ThoughtSpot, Tableau or Power BI. - Familiarity with medallion data architecture and Databricks or an equivalent data lake.

Your next step

Complete your application on cfc.pinpointhq.com. The employer’s form will show what is required.

Applying through Pinpoint

  • Only .pdf and .docx are accepted. Older .doc files are turned away.

Already applied? Track this application

Job description

View original posting ↗

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.

About the role

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.

About you

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 Lloyd's insurance market
  • Experience within delegated business or an MGA, although this is preferred rather than essential.
  • Strong Python and SQL skills - alongside experience with languages such as DAX, M etc.
  • 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 GitHub.
  • An understanding of underwriting performance KPIs and the calculations behind them.
  • The ability to interpret complex data and identify anomalies.

Employment type

Fixed Term - Full Time

Demand for Data Engineer roles

New Data Engineer postings at the employers we follow are up 14% over the last 6 weeks compared with the 6 before.

Weekly new Data Engineer postings at the same employers, from the week of August 17 to the week of November 9. The fewest in a week was 860, the most 1,353, and the latest week had 1,020.
August 17Last week

Each bar is one week of new postings. The darkest bars are the last 6 weeks.

Counted from the hiring pages we’ve followed for at least five weeks, so employers we add don’t look like growth. Updated weekly.

About the role

We file this job under Data Engineer, by the work the posting describes.

Data engineers build and run the pipelines that copy data out of apps and outside services into a warehouse or lake, and fix them when a source changes or a load fails.

Expect SQL, Python, a cloud platform, a scheduler such as Airflow, and often tools for large data such as Spark or Kafka.

An analytics engineer works one step later, turning the raw data a data engineer lands into clean tables people can query.

US government figures for database architects

Median yearly pay, May 2025
$139,500
Expected change, 2025 to 2035
9.4% more jobsagainst 3.5% for all jobs

The government has no code for data engineers, so these figures are for the closest group, database architects, which includes data integration and data warehousing specialists.

Source: US Bureau of Labor Statistics, Occupational Employment and Wage Statistics (May 2025) and Employment Projections (2025 to 2035). Occupation code 15-1243.

Source details

View original posting ↗

Source notes

Source excerpts

Selected passages from the saved posting. Check the full description for conditions and exceptions.

Pay

No pay amount identified in the saved description.

Location & working pattern

London, United Kingdom, UK - London

Working pattern and location restrictions need checking in the full posting.

Work authorization

No clear work-authorization passage found. Eligibility is unconfirmed.

Find answers in the posting

AI
How answers work

AI selects complete passages from this posting. Check them for conditions and exceptions.

Uses this posting and your question. No profile needed.