Lead Analytics Engineer
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
- 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
- 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)
- 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
- Directory of Social Change’s UK Guides to Company Giving 2017-26