Lead Analytics Engineer

AJ Bell
M53Ee, M5 3EE, United Kingdom
Last month
Job Type
Contract
Work Pattern
Full-time
Work Location
On-site
Seniority
Lead
Education
Degree
Contract Duration
6 months
Posted
30 Apr 2026 (Last month)

Benefits

26 days holiday, increasing with service + buy/sell scheme + bank holidays 7% Pension with matched contributions Discretionary bonus scheme Share schemes (including free shares and BAYE) Health Cash Plan and discounted private healthcare Free onsite gym Enhanced family leave (subject to qualifying criteria) Travel and bike loan schemes Employee Assistance Programme
Job Description

We are undertaking a strategic migration of our reporting and analytics estate from SSRS to a modern cloud data platform (Snowflake). This role will support the design and delivery of that transformation—establishing best-in-class practices while remaining hands-on in building models, pipelines, and reporting layers.

You will play a critical role in not just migrating existing assets, but improving how we model, govern, and deliver data across the organisation.

Why This Role Matters

This is a high-impact role at the centre of a major data transformation. The successful candidate will shape how data is modelled, accessed, and trusted across the organisation for years to come.

What does the job involve?

Support the Migration from Legacy BI to Modern Data Platform

  • Support the end-to-end migration of reporting assets from SSRS into Snowflake
  • Assess and rationalise existing reports (remove duplication, improve logic, simplify where possible)
  • Redesign reporting structures to align with modern data modelling principles

Define and Implement Best Practice

  • Establish scalable standards for:
    • Data modelling (e.g. dimensional modelling, layered architecture)
    • Transformation workflows (ELT patterns)
    • Testing and validation
    • Documentation and governance
  • Introduce modern development practices (e.g. version control, CI/CD where appropriate)

Hands-On Delivery

  • Build and optimise data models, transformations, and reporting datasets
  • Write high-quality, performant SQL in Snowflake
  • Develop reusable data assets for downstream reporting and analytics
  • Troubleshoot and resolve data quality or performance issues

Improve the Reporting & Analytics Layer

  • Design a clean, scalable semantic layer for reporting
  • Standardise key business metrics and definitions
  • Support transition away from legacy report-first design toward model-first design

Mentor and Uplift the Existing Team

  • Provide technical guidance and coaching to BI developers and analysts
  • Raise engineering standards across the team
  • Promote consistency and good practices without over-engineering

Stakeholder Collaboration

  • Work closely with business stakeholders to understand reporting needs
  • Translate requirements into robust, scalable data solutions
  • Challenge and refine requirements where needed to improve outcomes

Essential

  • Strong SQL expertise (advanced level)
  • Proven experience working with Snowflake (or similar cloud data warehouse)
  • Experience migrating from legacy BI/reporting tools (e.g. SSRS, Cognos, Business Objects)
  • Strong data modelling experience (dimensional modelling, star schemas, etc.)
  • Experience building transformation layers in ELT environments
  • Track record of delivering in hands-on roles (not purely architectural)

Highly Desirable

  • Experience with dbt or similar transformation frameworks
  • Familiarity with modern data stack principles
  • Experience implementing testing and data quality frameworks
  • Exposure to CI/CD in data environments
  • Experience rationalising large, complex reporting estates

About AJ Bell

AJ Bell is one of the UK’s fastest-growing investment platform businesses, providing award-winning solutions for everyone, from professional financial advisers to first-time investors.

Today, over 723,000 customers trust us to manage more than £108billion of assets. By continually striving to make investing simpler and more accessible, we’re helping more people take control of their financial futures.

We’re proud to be recognised as one of the UK’s Best 100 Companies to Work For, for six consecutive years, and a Great Place to Work in 2025 and 2026 a reflection of our supportive and collaborative culture.

What we offer

  • 26 days holiday, increasing with service + buy/sell scheme + bank holidays
  • 7% Pension with matched contributions
  • Discretionary bonus scheme
  • Share schemes (including free shares and BAYE)
  • Health Cash Plan and discounted private healthcare
  • Free onsite gym
  • Enhanced family leave (subject to qualifying criteria)
  • Travel and bike loan schemes
  • Employee Assistance Programme

Life at AJ Bell

  • Regular social events including summer and Christmas parties
  • Learning and development opportunities tailored to you
  • Casual dress code
  • Friendly, supportive team environment

Our ways of working

We offer hybrid working, with a minimum of 60% of your working time per month spent in the office. For new starters, there’s an initial period of full-time office working to help you settle in and build relationships.

Inclusion & diversity

We’re committed to creating an inclusive environment where everyone feels respected and able to be themselves at work. We welcome applications from all backgrounds and make hiring decisions based on skills, experience and potential.

Related Jobs

View all jobs

Analytics Manager

Harnham - Data and Analytics Recruitment London, United Kingdom
£100,000 – £120,000 pa Permanent

Data Architect

DCV Technologies London, United Kingdom
£400 – £500 pd Contract

Data Platform Manager

Deerfoot Recruitment Solutions Luton, Bedfordshire, United Kingdom
£70,000 pa Hybrid

Data Architect

ARC IT Recruitment London, United Kingdom
£100,000 – £110,000 pa Remote

Senior Data Scientist

Opus Recruitment Solutions London, United Kingdom
£60,000 – £80,000 pa Remote

Finance Data Engineering Lead

Experis London, United Kingdom
£750 – £950 pd Hybrid

Industry Insights

Discover insightful articles, industry insights, expert tips, and curated resources.

Where to Advertise Data Science Jobs in the UK (2026 Guide)

Where to advertise data science jobs UK in 2026: the specialist boards, communities and channels that actually reach senior and lead data science talent. Data science spans a broad and often misunderstood spectrum — from statistical modelling and experimental design through to machine learning engineering, product analytics and AI research. The strongest candidates identify firmly with specific subdisciplines and are frustrated by adverts that conflate data scientist with data analyst, business intelligence developer or machine learning engineer. General job boards produce high application volumes for data roles but consistently fail to match specialist data science profiles with the right opportunities. This guide, published by DataScienceJobs.co.uk, covers where to advertise data science roles in the UK in 2026, how the main platforms compare, what employers should expect to pay, and what the data says about hiring across different role types.

Data Science Jobs UK 2026: What to Expect Over the Next 3 Years

Data Science Jobs UK 2026: roles, salaries and the trends shaping UK data science hiring over the next three years — from MLE crossover to GenAI workflows. Data science has spent the past decade being described as the sexiest job of the twenty-first century. By 2026, the reality is both more nuanced and more interesting than that label ever suggested. The discipline has matured, fragmented, deepened, and in some respects reinvented itself — and the jobs market has changed with it in ways that create genuine opportunity for those who understand what employers actually want, and genuine difficulty for those still operating on assumptions formed five years ago. The data science jobs market of 2026 is not simply a larger version of what it was three years ago. The generalist data scientist — equally comfortable wrangling data, building models, and presenting insights to the board — is giving way to a more specialised landscape where employers know exactly what problem they are trying to solve and are looking for candidates with the specific depth to solve it. Machine learning engineering, causal inference, experimentation, AI product development, and domain-specific applied science have all emerged as distinct career tracks within what was previously a single, loosely defined profession. At the same time, the arrival of large language models and the broader AI capability wave has both threatened and created data science roles in equal measure. Some of the work that junior data scientists spent their early careers doing — data cleaning, exploratory analysis, basic model building — is being partially automated by AI tooling. But the demand for practitioners who can evaluate AI systems rigorously, apply statistical thinking to complex business problems, and build the data foundations on which AI depends has grown considerably. The candidates who will thrive over the next three years are those who understand where the discipline is heading — which specialisms are attracting the most investment, which technologies are reshaping what data scientists are expected to build and know, and how to position a data science career that will remain valuable as the field continues to evolve around them. This article breaks down what the UK data science jobs market is likely to look like through to 2028 — covering the titles emerging right now, the technologies driving employer demand, the skills that will matter most, and how to position your career ahead of the curve.