Full Stack BI Engineer

Neilson Financial Services; Windsor; Hybrid; GBP 90,000 - 125,000; Full time

Job summary

Neilson Financial Services in Windsor is seeking a Staff Full-Stack BI Engineer to own data products across performance marketing and call-centre analytics. You will lead the transition to a cloud-native lakehouse on Azure Databricks, define Python-first standards, and keep Power BI reports sharp for stakeholders.

You’ll design governed data models, semantic layers, and scalable reporting, mentor engineers, and partner with regional and sales leaders to shape BI solutions that truly drive

Qualifications

• Significant experience in BI or data engineering with end-to-end accountability.
• Advanced Power BI skills including complex model design, RLS, and performance tuning.
• Hands-on production experience with Azure Databricks and Python.
• Experience designing and owning core data models and semantic layers.

Responsibilities

• Own complex data products from model to report layer.
• Architect a cloud-native lakehouse on Azure Databricks with Delta Lake and Unity Catalog.
• Rationalise KPIs and enforce semantic-layer definitions.
• Govern and secure data access with robust security controls and documentation.
• Lead across functions by partnering with regional heads and sales/ops directors.
• Mentor engineers and build reusable data patterns and libraries.

Skills

BI engineering

Platform design

Stakeholder leadership

Data governance

Mentoring

Education

Bachelor's degree in a relevant field

Tools

Azure Databricks

Delta Lake

Unity Catalog

Python

Power BI

SQL

Job description

Staff Full-Stack BI Engineer

Location: Windsor / Hybrid

Team: Data, Analytics & BI

Reports to: BI Manager

Level: Staff

About The Role

We're looking for a seasoned BI engineer who thinks in platforms, not just dashboards — someone who brings deep domain expertise in performance marketing or call-centre operations and turns it into data products the business genuinely trusts.

This isn't "Senior but older." It's a different job — focused on design, standards, and cross-domain impact. You'll lead NFS's transition from a SQL Server-centric environment to a modern, scalable platform built on Azure Databricks and Python, while keeping Power BI delivery sharp and stakeholder-ready.

Your domain knowledge is the differentiator. You ask better questions, catch errors faster, and build products users trust — because you understand what the metrics mean and why they matter to the business.

What You'll Do

• Own complex data products — Take vague, multi-stakeholder asks (like "we need a single view of revenue across all regions") and turn them into governed, trusted BI products from model to report layer.
• Architect the platform — Lead the shift to a cloud-native lakehouse on Azure Databricks with Delta Lake and Unity Catalog. Establish Python-first standards and reusable framework patterns for the team.
• Rationalise KPIs — Drive "one version of the truth" for core metrics. Work with senior stakeholders to agree definitions and enforce them in the semantic layer.
• Govern and secure — Design access controls, RLS frameworks, and documentation standards. Spot risks early — security gaps, interpretability issues, maintainability debt — and resolve them before they compound.
• Lead across functions — Partner with Regional Heads and Sales/Ops Directors to shape BI products that align with how the business actually runs. Negotiate the trade-offs that matter.
• Raise the team's bar — Define what "good" looks like in modelling, design, and reporting. Mentor Senior and Associate engineers. Build patterns, templates, and libraries others can reuse.

Your toolkit

You'll need deep, hands-on fluency across the modern Azure data stack — and strong bridging skills for the legacy environment you're migrating from.

Python, PySpark, Azure Databricks (Delta Lake, Unity Catalog, pipelines, notebooks, jobs), Azure Data Lake Storage Gen2, Azure Data Factory, Azure Key Vault, Power BI (complex model design, advanced DAX, RLS, performance tuning), SQL / SSMS, Git & CI/CD. Familiarity with Microsoft Fabric is a plus.

Domain expertise

You'll need hands-on experience in at least one of these domains — ideally both. This isn't a nice-to-have; it's what allows you to build data products people actually trust.

Performance Marketing Analytics

Martech infrastructure, lead attribution, campaign optimisation. You're fluent in funnel metrics (impressions, clicks, lead volume, quality indicators) and comfortable with CPL optimisation, A/B testing, creative testing, bid management, and privacy/consent compliance.

Call Centre Operations

Agent performance dashboards, coaching analytics, and conversion funnel analysis from lead to policy. You understand agent-level KPIs, Grade of Service, First-Call Resolution, and how lead quality, experience, product, and time of day drive conversion.

Ideally, you can connect marketing and sales metrics end-to-end — translating lead volume and quality into sales performance expectations and identifying where friction exists in the lead-to-policy journey.

What We're Looking For

Significant experience in BI or Data Engineering roles with end-to-end accountability. A track record of designing and owning core data models, semantic layers, and critical business reports. Hands-on production experience with Azure Databricks. Advanced Power BI skills including complex model design, RLS, performance tuning, and measure authoring.

You think platform-first — you build solutions others can reuse, not just point fixes. You raise the bar on documentation, interpretability, and maintainability. You operate well in mid-transition environments where legacy and modern patterns coexist. You use AI tools as leverage for design, code review, and documentation, with critical judgement.

Azure Databricks certifications are a must. A formal degree is beneficial but strong experience and evidence of impact carry equal weight.

NFS is an equal opportunity employer. We welcome applications from all qualified candidates.