Power BI Reporting Analyst

Cancerresearchuk; Stratford-upon-Avon; Hybrid; GBP 35,000 - 40,000; Full time

Job summary

Cancer Research UK is seeking a Power BI Reporting Analyst to design, develop and maintain high-quality Power BI reporting and data models across the organisation.

Based in Stratford with hybrid working and 1–2 days in the office, you will collaborate with digital, marketing and operational teams to translate reporting needs into robust BI solutions that support data-driven decision making and fundraising activity.

Qualifications

• Significant experience using Power BI and data modelling.
• SQL querying experience; Snowflake a plus.
• Advanced MS Excel skills.
• Experience leading BI projects with impact.
• Strong communication and stakeholder management.

Responsibilities

• Understand business objectives with stakeholders and document BI solutions.
• Design, develop and maintain Power BI datasets and reports.
• Build robust data models (star schemas) for scalable reporting.
• Write and optimise SQL queries to prepare data for reporting.
• Develop DAX measures to deliver reliable insights.
• Lead BI projects and deliver KPI reporting to stakeholders.
• Communicate insights clearly to drive informed decisions.
• Resolve data inconsistencies and ensure governance and documentation.
• Collaborate across teams to improve data quality and tooling.

Skills

Power BI

Data modelling

DAX

SQL

Excel

Stakeholder management

Tools

Snowflake

Job description

Power BI Reporting Analyst

£35,000 - £40,000 plus benefits

Reports to: Reporting Manager (Reporting, Analytics, Digital, and Data Science)

Directorate: Marketing, Fundraising & Engagement

Contract: Permanent

Hours: Full time 35 hours per week (we are open to compressed hours)

Location: Stratford, London Office-based with high flexibility (1-2 days per week in the office)

Closing date: 13 November 2026 23:55
Visa sponsorship: You must be eligible to work in the UK to apply for this vacancy. Cancer Research UK is not able to offer visa sponsorship.

Recruitment process: The interview process consists of two stages. The first stage is a task-based assessment. Depending on the outcome, successful candidates will be invited to a second-stage competency-based interview.

At Cancer Research UK, we exist to beat cancer.

We have an exciting opportunity for you to join us as a Power BI reporting Analyst within our data team. In this role, you will design, develop and maintain high-quality Power BI reporting and data models that enable teams across the organisation to make informed, data-driven decisions.

You’ll work closely with stakeholders across digital, marketing, supporter and operational teams to understand their reporting needs and translate these into robust Power BI solutions. Alongside leading your own projects, you will contribute to the delivery of impactful reporting and business intelligence that supports the optimisation and innovation of our fundraising activity and helps maximise the contribution we make towards beating cancer.

This role combines strong Power BI development expertise with stakeholder engagement and project ownership, giving you the opportunity to shape how data is used across the organisation.

What will I be doing?

• Working with stakeholders to understand business objectives, gather reporting and business intelligence requirements, and document solutions.
• Designing, developing and maintaining Power BI datasets and reports that support decision-making across the organisation.
• Building and optimising robust data models (including star schemas) to support scalable and high-performing reporting solutions.
• Writing and optimising SQL queries in Snowflake to extract, transform and prepare data for reporting and analysis.
• Developing and maintaining DAX measures and calculations to deliver reliable and insightful reporting outputs.
• Leading your own BI and reporting development projects, delivering high-quality KPI reporting and analysis that ensures teams have access to the most relevant and up-to-date information.
• Communicating reporting and insights clearly to stakeholders in a way that drives understanding, impact and informed decision-making.
• Investigating and resolving data inconsistencies, ensuring reporting outputs remain accurate, consistent and trusted across the organisation.
• Ensuring all work follows established processes, governance standards and documentation requirements.
• Identifying opportunities to improve reporting, data quality and governance, and collaborating with team members to implement improvements.
• Building and maintaining strong working relationships across the organisation, sharing knowledge and supporting colleagues to increase the effective use of data and reporting tools.
  

What are we looking for?

• Significant experience of using Power BI, familiar with creating advanced data models (including star schema), data flows and DAX language, using outputs to make actionable reports and insights.
• Relevant experience of manipulating a broad range of data sets and writing complex queries for reporting needs or driving out insight using SQL. Experience Snowflake or similar platforms advantageous but not essential
• Significant experience of reporting and data analysis techniques and statistics gained in an organisation or agency, ideally with complex marketing and comms landscape.
• Advanced knowledge of MS Excel (experience in creating macros advantageous but not essential).
• Experience of leading and delivering projects with proven impact and demonstrating excellent project management and planning skills with ability to prioritise workload
• Proven ability to act as a trusted partner to stakeholders, leading requirements-gathering sessions, challenging assumptions, balancing business needs and translating requirements into reporting/ business intelligence solutions.
• Strategic skills (including analysis, structured thinking and logical reasoning) and strong accuracy and numeracy, with good attention to detail
• Evidence of proactive behaviours, and ability to work independently, challenges own performance, invests in own development andfinds innovative solutions to problems
• Excellent communication and presentation skills with ability to convey expertise in a way that engages and builds their knowledge
• Ability to build and maintain strong working relationships with others and work as part of a team.

Our organisation values are designed to guide all that we do.

Bold:Act with ambition, courage and determination

Credible:Act with rigour and professionalism

Human: Act to have a positive impact on people

Together:Act inclusively and collaboratively

We’re looking for people who can believe in and embody these organisation values and can use them to drive forward progress against our mission to beat cancer.

If you’re interested in applying and excited about working with us but are unsure if you have the right skills and experience we’d still love to hear from you.

What will I gain?

We create a working environment that supports your wellbeing and provide a generous benefits package, a wide range of career and personal development opportunities and high-quality tools. Our policies and processes enable you to improve your work-life balance, take positive steps in your career and achieve your personal wellbeing goals.

You can explore our benefits by visiting our careers web page.