At a Glance
- Tasks: Design and develop impactful Power BI reports to drive data-driven decisions.
- Company: Join Cancer Research UK, the leading charity dedicated to beating cancer.
- Benefits: Enjoy a competitive salary, flexible working, and generous benefits.
- Other info: Collaborative environment with opportunities for personal and professional growth.
- Why this job: Make a real difference in cancer research while developing your analytical skills.
- Qualifications: Experience with Power BI, SQL, and strong project management skills required.
The predicted salary is between 35000 - 40000 £ per year.
At Cancer Research UK, we exist to beat cancer. 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.
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 at . For more updates on our work and careers, follow us on: Linked In, Facebook, Instagram, X and YouTube.
Our vision is to create a charity where everyone feels like they belong, benefits from and participates in, the work we do. We actively encourage applications from people of all backgrounds and cultures, in particular those from ethnic minority backgrounds who are currently under-represented.
We want to see every candidate performing at their best throughout the job application process, interview process and whilst at work. We therefore ask you to inform us of any concerns you have or any adjustments you might need to enable this to happen. Please contact or 020 3469 8400 as soon as possible. Unfortunately, we are unable to recruit anyone below the age of 18, so that we can protect young people from health & safety and safeguarding risks.
About Us: We’re the world’s leading cancer charity, dedicated to saving and improving lives with our research. We work to reduce the impact of cancer on people’s day-to-day lives through our research, influence and are beating cancer – step by step, day by day. Our work means that people with cancer live better lives through earlier diagnosis and kinder, more effective treatments. Find a purposeful career that will empower you to grow and collaborate with like-minded experts.
Analyst in London employer: Cancer Research UK
At Cancer Research UK, we pride ourselves on being an exceptional employer, offering a supportive work culture that prioritises employee wellbeing and professional growth. Located in the vibrant Stratford area, our office provides high flexibility with the option to work from home, allowing you to balance your personal and professional life while contributing to our mission of beating cancer. With a generous benefits package and opportunities for career development, you'll find a meaningful and rewarding environment where your skills as an Analyst can truly make a difference.
StudySmarter Expert Advice🤫
We think this is how you could land Analyst in London
✨Tip Number 1
Get to know the company! Research Cancer Research UK and understand their mission. This will help you tailor your conversations during interviews and show that you're genuinely interested in being part of their team.
✨Tip Number 2
Practice your Power BI skills! Since this role heavily relies on data visualisation, make sure you can confidently discuss your experience with Power BI and showcase any projects you've worked on. Bring examples to the table!
✨Tip Number 3
Network like a pro! Connect with current employees on LinkedIn or attend relevant events. Building relationships can give you insider knowledge about the company culture and potentially lead to referrals.
✨Tip Number 4
Don’t forget to apply through our website! It’s the best way to ensure your application gets seen. Plus, it shows you’re serious about joining us in our mission to beat cancer.
We think you need these skills to ace Analyst in London
Some tips for your application 🫡
Tailor Your Application:Make sure to customise your CV and cover letter for the Analyst role. Highlight your experience with Power BI, SQL, and any relevant projects you've led. We want to see how your skills align with our mission to beat cancer!
Showcase Your Stakeholder Engagement:In your application, emphasise your ability to work with stakeholders. Share examples of how you've gathered requirements and translated them into actionable insights. This is key for us as we value collaboration and communication.
Be Clear and Concise:When filling out the online application form, keep your responses clear and to the point. We appreciate straightforwardness, so make sure your achievements and experiences shine without unnecessary fluff!
Apply Through Our Website:Don’t forget to submit your application through our careers page! It’s the best way for us to receive your details and ensure you’re considered for the role. Plus, it’s super easy to navigate!
How to prepare for a job interview at Cancer Research UK
✨Know Your Power BI Inside Out
Make sure you brush up on your Power BI skills before the interview. Be ready to discuss your experience with creating advanced data models, DAX measures, and how you've used these tools to drive insights in previous roles. Practising a few examples of reports you've created can really help you stand out.
✨Understand the Stakeholder Perspective
Since this role involves working closely with various teams, it’s crucial to demonstrate your understanding of stakeholder needs. Think about how you’ve gathered requirements in the past and be prepared to share specific examples of how you translated those into actionable reporting solutions.
✨Show Off Your SQL Skills
Be ready to talk about your experience with SQL, especially if you've worked with Snowflake or similar platforms. Prepare to discuss complex queries you've written and how they contributed to effective reporting. If possible, bring along a sample query to showcase your skills.
✨Communicate Clearly and Confidently
During the interview, focus on your communication skills. Practice explaining technical concepts in a way that’s easy to understand for non-technical stakeholders. This will show that you can bridge the gap between data and decision-making, which is key for this Analyst role.
