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