Principal BI Architect & Engineer 12m FTC in London

Principal BI Architect & Engineer 12m FTC in London

London Temporary 59400 - 72600 £ / year (est.) On-site
CFC

At a Glance

  • Tasks: Lead the redesign of our BI ecosystem and streamline reporting services.
  • Company: Join a forward-thinking company focused on data insights and innovation.
  • Benefits: Competitive salary, flexible working options, and opportunities for professional growth.
  • Other info: Dynamic role with a chance to work on cutting-edge data solutions.
  • Why this job: Shape the future of data reporting and make a real impact in the insurance sector.
  • Qualifications: Expertise in data engineering, BI architecture, and strong skills in Python and SQL.

The predicted salary is between 59400 - 72600 £ per year.

CFC is looking for an experienced BI Architect & Engineer to help establish a single source of truth for our underwriting performance reporting on a 12m FTC basis. 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.

Principal BI Architect & Engineer 12m FTC in London employer: CFC

CFC in London is an exceptional employer, offering a vibrant work culture that fosters collaboration and innovation. As a Cyber Catastrophe & Portfolio Risk Actuary, you'll benefit from unparalleled growth opportunities while working at the forefront of cyber risk management, all within a supportive environment that values your insights and contributions.

CFC

Contact Details:

CFC Recruitment Team

StudySmarter Expert Advice🤫

We think this is how you could land Principal BI Architect & Engineer 12m FTC in London

✨Join Business Intelligence Meetups

We can’t stress enough how beneficial it is to attend local Business Intelligence meetups and events. These gatherings often bring together industry professionals and can lead to short-term, temporary roles—perfect if you’re looking to land something quickly. Plus, you’ll get to learn some insider tips and tricks from those already in the game!

✨Leverage Online Freelancing Platforms

Since you’re searching for a temporary gig, check out freelancing platforms like Upwork or Freelancer where businesses often post short-term BI projects. This can be a great way to build your portfolio and gain experience while also showcasing your skills to potential future employers.

✨Show Off Your BI Projects

Whether you’re working on a personal project or a past endeavour, put your work out there! Create a public portfolio that highlights your best Business Intelligence analyses or visualisations. It’ll give you a leg up when you’re approaching companies like CFC, showing exactly what you can bring to the table.

✨Tap Into University or College Networks

If you're currently studying or recently graduated, make sure to use your university's career services. Many educational institutions have partnerships with companies looking for temporary talent in Business Intelligence, so keep an eye out for exclusive job postings or internship fairs that could lead to a quick placement.

We think you need these skills to ace Principal BI Architect & Engineer 12m FTC in London

BI Architecture
Data Engineering
Data Modelling
Dimensional Modelling
Star and Snowflake Schemas
Governed Sandbox Environments
Visualisation Tools

Some tips for your application 🫡

Show Off Your Data Skills:In business intelligence, it's crucial to highlight your analytical skills and experience with data tools. Make sure your CV showcases any relevant software you’ve used, like SQL, Tableau, or Power BI. Add specific examples of how you've used data to drive insights or improvements in previous roles, even if they were in academic projects or internships.

Keep it Concise and Impactful:For a temporary role like this, hiring managers often have limited time to sift through applications. Get straight to the point in your CV and cover letter. Use bullet points for your achievements, showcasing the impact you've made, like percentage increases in efficiency or specific results from your analyses.

Flexibility is Key:Since this is a temporary position, make sure to emphasise your adaptability. Mention your quick learning abilities and experiences where you adapted to new tools or processes rapidly. This will show that you can jump in and start contributing effectively from day one at CFC.

Craft a Tailored Motivation Statement:In your cover letter, focus on why you’re excited about this temporary role at CFC. Talk about your interest in business intelligence and how this position aligns with your career goals. Remember, it’s not just about what you can offer, but why you’re passionate about becoming part of their team, even for a short time!

How to prepare for a job interview at CFC

✨Brush Up on Your Data Skills

For a business intelligence role, you'll want to showcase your analytical skills and familiarity with data visualisation tools like Tableau or Power BI. Be ready to tackle technical questions or case studies demonstrating your ability to interpret data and make insightful recommendations.

✨Plan Your Portfolio of Projects

Since this is a temporary position, we should highlight any past projects you've worked on in business intelligence. Prepare a portfolio that includes a couple of key pieces where you've effectively utilised data to drive decisions—this will show that you're not just a quick fix but someone who can deliver immediate value.

✨Demonstrate Your Adaptability

Temporary roles often require us to hit the ground running, so be ready to discuss how you quickly adapt to new tools, teams, and environments. Share specific examples from previous experiences where you thrived under pressure or had to learn a new system or process in a short time frame.

✨Have Your Metrics Ready

In business intelligence, quantifying your impact is key. Come prepared to share metrics from your past work: think percentages, growth figures, or efficiency improvements. This will really help us paint a picture of how your contributions directly benefited those previous roles.