Lead Analytics Engineer

Benefact Group plc; Bradley Stoke; Hybrid; GBP 60,000 - 80,000; Full time

Job summary

A leading financial services group is seeking a Lead Analytics Engineer to join their Gloucester office. You will lead the development of scalable analytics solutions and collaborate with various teams to drive data-driven decision making. The ideal candidate will have strong SQL skills and experience with tools like dbt and Snowflake. This role offers a competitive salary and a hybrid working model.

Benefits

Competitive salary

Hybrid working

Generous annual bonus scheme

25 days annual leave plus holidays

Health and wellbeing benefits

Charity personal grant

Volunteering day

Employee Assistance Programme

Study support for qualifications

Qualifications

• Strong proficiency in SQL and experience with dimensional modelling.
• Hands-on experience with dbt for transformation and documentation.
• Experience with cloud-based analytics platforms.

Responsibilities

• Model business logic in the data layer using dbt and SQL.
• Build and maintain semantic layers for analytics.
• Deliver intuitive dashboards and data models.

Skills

SQL proficiency

dimensional modelling

dbt experience

Power BI proficiency

excellent communication

Tools

Snowflake

BigQuery

Looker

Tableau

Job description

Working hours: 35 hours per week, Monday to Friday

Duration: Permanent

Location: Gloucester

Job Ref: 204410

About the role

Benefact Group are looking for a Lead Analytics Engineer to join our Gloucester office.

Join us at the forefront of data-driven transformation, where you’ll lead the development of trusted, scalable analytics solutions using tools like dbt, Snowflake, and Power BI. As a Lead Analytics Engineer, you’ll shape how data is modelled, governed, and consumed across the organisation, enabling smarter decisions through clean, reusable datasets and intuitive dashboards. You’ll collaborate closely with analysts, engineers, and business teams to deliver high-impact data products that drive insight and innovation.

This is a hands-on leadership role where your technical expertise and strategic thinking will directly influence our data culture. With access to cutting-edge platforms and a team passionate about continuous improvement, you’ll be empowered to make a lasting impact. If you're excited by the challenge of turning raw data into meaningful insight, this is your opportunity to lead from the front.

Why join us?

Join a collaborative and inclusive culture that’s committed to making a difference and building a more sustainable future. Ranked amongst the UK's 15 Best Big Companies to Work For in 2025, we offer fantastic career and development opportunities within a rapidly growing, innovative Group — where all profits go to charity and good causes.

What you'll be doing

• Model business logic in the data layer, transforming raw data into clean, reusable datasets using dbt and SQL
• Build and maintain semantic layers and data marts to support self-serve analytics and consistent reporting
• Deliver intuitive, performant dashboards and well-documented data models that empower decision-making
• Collaborate with analysts, engineers, and business teams to translate data needs into scalable technical solutions
• Champion best practices in data modelling, transformation, and governance across cloud analytics platforms

What you'll need to have

• Strong proficiency in SQL and experience with dimensional modelling (star/snowflake schemas)
• Hands-on experience with dbt for transformation, testing, and documentation
• Experience working with cloud-based analytics platforms such as Snowflake or BigQuery
• Proficiency in Power BI, Looker, or Tableau for dashboard development and visual storytelling
• Excellent communication skills and the ability to translate business needs into technical solutions

What makes you stand out

• Experience integrating data from APIs, SaaS platforms, and cloud databases
• Familiarity with Power Platform tools (Power Automate, Power Apps)
• Exposure to CI/CD pipelines and Azure DevOps for analytics deployments
• Experience with data cataloguing and metadata management tools (e.g. Purview, Alation, Collibra)
• Background in SaaS or scale-up environments with KPIs like Monthly Recurring Revenue (MRR), Churn Rate, Customer Acquisition Cost (CAC), and Customer Lifetime Value (CLTV)

What we offer

• A competitive salary - let's discuss it
• Hybrid working
• Group Personal Pension - up to 12% employer contribution
• Generous annual bonus scheme between 6% and 24%
• 25 days annual leave plus bank holidays, and a holiday buy and sell scheme
• An array of health and wellbeing benefits, including private healthcare, income protection and life assurance
• £200 annual personal grant to a charity of your choice
• Encouraged to take at least one volunteering day per year
• Employee Assistance Programme
• Full study support to gain professional qualifications
• Access to virtual GP
• Enhanced maternity and paternity pay

Hear from the hiring manager

"This role is a fantastic opportunity to shape how analytics is delivered and consumed across the organisation. We’re investing in scalable, governed data products that empower teams to make smarter decisions, faster. You’ll be working with modern tools and a supportive team that values collaboration, curiosity, and continuous improvement. If you enjoy solving complex problems and translating data into real business impact, we’d love to have you on board."

About us

Benefact Group is a unique international financial services Group made up of over 30 businesses. We are owned by a charity and have been the 3rd largest UK corporate donor over a decade*, having given away £250 million since 2014. We have ambitious plans to become the UK’s number one corporate donor, with strategic objectives in place to double the Group’s size.

We believe it’s essential to attract, empower, grow and reward talented people, offering fantastic opportunities for career and personal development. Our giving ethos, 135-year history and the diversity of what we do, has enabled us to build a culture of kindness, great ambition, and of passionate people driven to do better and be better.

At Benefact Group, we are committed to creating an inclusive culture and building an environment where each and every one of us feels valued and respected. We are a community made up of people with a range of different backgrounds, abilities, perspectives, beliefs and interests and we value the strength this brings to us as a Group. We welcome applications from everyone.
If you need any additional support during the recruitment process, then please let us know.

*Directory of Social Change’s UK Guides to Company Giving 2017-26