At a Glance
- Tasks: Design and develop impactful Power BI reports to drive data-driven decisions.
- Company: Join Cancer Research UK, a leading organisation dedicated to beating cancer.
- Benefits: Enjoy a competitive salary, flexible working, and generous personal development opportunities.
- Other info: Collaborative environment with a focus on wellbeing and career growth.
- Why this job: Make a real difference in the fight against cancer while enhancing your data skills.
- Qualifications: Experience with Power BI, SQL, and strong analytical skills required.
The predicted salary is between 37338 - 41000 £ per year.
£35,000 - £40,000 plus benefits
Reports to: Reporting Manager (Reporting, Analytics, Digital, and Data Science)
Directorate: Marketing, Fundraising & Engagement
Contract: 12 month fixed-term contract
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: 4 August 2026 23:55.
In line with our organisation policy we will keep this open until 31 May for internals.
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:
- First stage: Task.
- 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 and finds 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.
How do I apply?
We operate an anonymised shortlisting process in our commitment to equality, diversity and inclusion. CVs are required for all applications; but we won't be able to view them until we invite you for an interview. Instead, we ask you to complete the work history section of the online application form for us to be able to assess you fairly and objectively.
For more information on this career opportunity please visit our website or contact us.
For more updates on our work and careers, follow us on: Linked In, Facebook, Instagram, X and YouTube.
Power BI Reporting Analyst in London employer: Cancer Research UK
Cancer Research UK is an exceptional employer, offering a dynamic work environment in Stratford, London, where you can make a meaningful impact on health partnerships. With a strong emphasis on employee well-being, we provide flexible working arrangements and a comprehensive benefits package that supports a healthy work/life balance, alongside ample opportunities for professional growth and development within the organisation.
StudySmarter Expert Advice🤫
We think this is how you could land Power BI Reporting Analyst in London
✨Tap into Online Data Science Communities
Join online communities focused on data science like Kaggle, LinkedIn groups, or Reddit threads. These are goldmines for temporary gigs, as you can network with professionals and potentially hear about opportunities at companies like Cancer Research UK before they're even advertised!
✨Show Off Your Skills With Projects
Got some cool data science projects? Showcase them on platforms like GitHub or create a personal portfolio website. This visibility is crucial for landing temporary roles—let recruiters see your actual skills in action, which can set you apart from the crowd.
✨Check Out Specialist Job Boards
For temp roles, hit up job boards dedicated to tech and data science, like Stack Overflow Jobs or DataJobs. These platforms often feature openings that you won’t find on general job sites, including contracts with companies like Cancer Research UK.
✨Leverage University Resources
If you're currently at uni or recently graduated, tap into your school's career services. They often have connections with companies looking for temporary data science interns or contract workers, and they might even host job fairs with employers like Cancer Research UK.
We think you need these skills to ace Power BI Reporting Analyst in London
Some tips for your application 🫡
Highlight Your Data Projects:When applying for a temporary data science role at Cancer Research UK, make sure to showcase any relevant projects you've worked on. Whether it's a personal project, an academic undertaking, or contributions to an open-source initiative, detailing these experiences can really set you apart and demonstrate your practical skills.
Emphasise Your Analytical Skills:In your CV and cover letter, focus on the specific analytical skills that are key to data science. Mention any experience with statistical tools, programming languages like Python or R, and data visualisation software. Don't forget to include any certifications that may bolster your expertise!
Show Your Flexibility:Since this is a temporary role, it's important to convey your adaptability and willingness to learn. In your cover letter to Cancer Research UK, emphasise how quickly you can get up to speed with new tools or projects. Highlight any previous experiences where you've had to adjust to new environments or challenges.
Craft a Unique Data-Driven Cover Letter:Instead of the usual generic cover letter, spice it up with some data! Maybe you’ve improved a process by 20% in a past role or cleaned a dataset with over a million entries. Use these stats to your advantage to grab Cancer Research UK’s attention and show the tangible impact of your work.
How to prepare for a job interview at Cancer Research UK
✨Showcase Your Analytical Skills
For a data science gig, it's crucial to demonstrate your analytical abilities. Be ready to discuss previous projects and the methodologies you used. Think about how you can quantify your impact—did your analysis improve efficiency or save costs? These are the stories that will stick with interviewers at Cancer Research UK.
✨Brush Up on Technical Skills
You might face technical questions on tools relevant to data science, like Python, R, or SQL. Prepare to solve a problem live—perhaps they'll ask you to write a simple query or code snippet. It’s cool to talk about them, but we need to show we can do it in practice, especially in a temporary role where quick results matter.
✨Highlight Your Adaptability
Since this is a temporary position, emphasise your ability to learn quickly and adapt to new tools or workflows. Share examples of how you've thrived in fast-paced environments before, and how you can hit the ground running at Cancer Research UK.
✨Prepare a Portfolio of Your Work
Bring your portfolio to the table—showcase projects where you've leveraged data science techniques to solve problems. Whether it’s a GitHub repository or a set of case studies, having tangible examples of your work will help you stand out and show what you bring to the team at Cancer Research UK.
