Analytics Engineer

Woodgreen Pets Charity has been helping pets and their owners live happier, healthier lives for over 100 years. From rehoming and community support to education and advocacy, our work is powered by dedicated people and a data-led approach.

We're seeking an Analytics Engineer who wants to help define how Woodgreen understands its performance. This role focuses on developing and maintaining trusted semantic models and consistent KPI definitions within the Microsoft platform, ensuring reporting is reliable, scalable and aligned across the charity. You'll work closely with business stakeholders, the Senior BI Analyst and Woodgreen's Data Engineer to ensure models reflect real operational needs, not just technical design. We want someone who enjoys working with people and helping colleagues gain confidence in their data.

Our successful candidate will bring experience designing and building analytical data models on a modern cloud platform, ideally Power BI, Microsoft Fabric and Azure Synapse, with a strong grounding in dimensional modelling principles and semantic layer design. Your SQL and DAX skills will be well-developed, and you'll understand what it takes to build models that are not just technically correct, but genuinely usable and trustworthy at scale.

A key part of this role is maintaining the logic that sit beneath our reporting and making sure these stay consistent and well-documented as the organisation evolves. You'll understand that inconsistent definitions undermine confidence in data, and confidence in data is what we're here to build.

You'll also have an eye on self-serve analytics: designing models and datasets that empower colleagues to answer their own questions rather than creating dependency on the data team. That means thinking about usability and accessibility alongside technical precision and being willing to invest time in helping people understand and trust what they're looking at. You'll be comfortable engaging with stakeholders across the charity to understand their reporting needs, translating those into sound analytical solutions, and communicating clearly throughout.

This role will operate in a hybrid working environment and although much of it can be done remotely our successful candidate must be able to attend our offices near Godmanchester, Cambridgeshire (PE29 2NH) for an average of once or twice a month.

The starting salary for this position is £46,876 - £52,085 per annum depending on experience. In addition, you will receive:

• 36 days annual leave per year (inclusive of bank holidays) rising by 1 day each year to a maximum of 40 days after five years
• Up to 8% employer pension contributions
• Support towards healthcare costs (cashplan)
• Employee wellbeing package to include free access to Headspace
• Life assurance (4x salary)
• Enhanced parental leave (subject to qualifying period)
• Benefits hub – exclusive discounts on popular brands
• 25% discount in our charity shops

Please note that you will need to have existing Right to Work in the UK to apply for this opportunity as we are unable to provide visa sponsorship.

Woodgreen is committed to making our recruitment processes accessible to all and, as part of this, we are flexible in the ways we give and receive information. If you would like to apply using a different format, please contact the Recruitment Team and we will do our best to put any reasonable adjustments in place.

Early application is encouraged as this position may close sooner than the stated deadline if a suitable candidate is found.

Woodgreen is committed to safeguarding children and adults at risk and protecting anyone that comes into contact with us from harm. We expect all employees and volunteers to share this commitment.