Power BI Reporting Analyst, Cancer Research
12 Month FTC
£35-40k
More information about location
1-2 days a week in office (Stratford, London )
Cancer prevention, awareness and research charity
Open for applications
Cancer prevention, awareness and research charity
1001+ employees
Open for applications
£35-40k
More information about location
1-2 days a week in office (Stratford, London )
1001+ employees
Company mission
To prevent, control and cure cancer through ground-breaking research.
Role
Who you are
- 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
- 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 the job involves
- Reports to: Reporting Manager (Reporting, Analytics, Digital, and Data Science)
- Contract: 12 month fixed-term contract
- We have an exciting opportunity for you to join us as an 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
- 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
Application process
- End Date: May 27, 2026
- Recruitment process: First stage: Task
- Second stage: Competency based interview
Salary benchmarks
Our take
The world’s largest independent cancer research charity, Cancer Research UK (CRUK) was founded from a merger between the Cancer Research Campaign and the Cancer Research Fund in 2002. CRC and ICRF had been long-standing pinnacles of the British medical institution, their work dating back to 1902 and 1923 respectively, and the merger signalled a strong step forward for UK medical institutes’ global influence.
A multi-armed charity, CRUK uses both grant-funded researchers and its own employed staff to research the treatments and causes of cancer, whilst its striking advertising and marketing campaigns are responsible for influencing public policy on the causes, prevention, and treatment of the disease. An example of a significant public campaign was Stoptober, which appeared to have triggered a third of a million smokers at the time to try quit tobacco throughout the month of October.
Alongside its pharmaceutical efforts, in 2023 CRUK funded clinical trials for the first-ever proton beam therapy for breast cancer, indicating a focus on technological innovations in the fight against cancer. On this subject, CRUK has also taken part in a billion-pound investment in the Francis Crick Institute, a biomedical research institute that is aiming to make England an international leader in the industry.
Steph
Company Specialist at Welcome to the Jungle
Insights
9% employee growth in 12 months
Company
Company HQ
Stratford, London, UK
Leadership
Michelle is a Trustee at the Francis Crick Institute and an Advisory Council Member at The King's FUnd. Previously, she served as a Non-Executive Director at NHS England and as CEO at the MS Society.
Share this job
View 6 more jobs at Cancer Research