Principle BI Architect & Engineer (Hiring Immediately)
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 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.
Recommended Jobs
Third Party Risk Analyst
G MASS is partnering with a global bank as it builds out its register of material third-party arrangements under the new UK regime for third-party reporting. This is a client-side contract role, rep…
Partner Development Manager- System Integrators
Who we are About Stripe Stripe is a financial infrastructure platform for businesses. Millions of companies—from the world’s largest enterprises to the most ambitious startups—use Stripe to acc…
Freelance Senior Account Manager - Consumer PR
At Splendid we care deeply and are passionate about inclusion at every level of our business. We believe that team diversity enriches our collaborative culture and our work for clients. We are keen t…
HR Project Manager (IT)
Oracle HR Transformation Project Manager Needed! An exciting opportunity is available for an experienced HR Project Manager to join a major HR transformation programme based in London for a Financia…
Head of Engineering and Infrastructure, Cornwall
Lead engineering & infrastructure for a complex, multi-site industrial organisation. Shape future models, enhance reliability, and drive continuous improvement. Influence senior leadership team and d…
Internal Audit Assistant Manager (Hiring Immediately)
Company Description About Playtech Founded in 1999, the company has a premium listing on the Main Market of the London Stock Exchange and is focused on regulated and regulating markets across its…
Legal Counsel - International Bank (3-5 PQE)
Key responsibilities will include: Advising on a range of banking and finance transactions, identifying legal and regulatory risks and delivering practical solutions. Drafting, reviewing and ne…
Associate, Finance Analytics
Company Description We’re Checkout.com . You might not know our name, but companies like eBay, Spotify, Klarna, Uber, and Sony do, because we’re behind many of the digital experiences you use ev…
CDM Manager / Principal Designer
A CDM Manager / Principal Designer is required to join an architectural practice working on a range of office and residential developments, including mid- to high-rise buildings. You will play a key r…
Accounts Payable Assistant
Our client, an established property management company based in North West London, is looking to recruit an Accounts Payable Assistant to join their finance team. This is an excellent opportunit…