Senior Data Analyst

Senior Data Analyst

Full-Time 36000 - 60000 £ / year (est.) Home office (partial)
R

At a Glance

  • Tasks: Transform data into impactful insights that drive community support and decision-making.
  • Company: Join Kensington and Chelsea Council, dedicated to serving diverse communities with care and integrity.
  • Benefits: Enjoy skill development, training opportunities, and a collaborative work environment.
  • Why this job: Make a real difference in residents' lives while working on meaningful projects post-Grenfell.
  • Qualifications: Advanced analytical skills in Excel and Power BI; experience in data-driven decision-making.
  • Other info: This is a 12-month maternity cover role with a focus on community impact.

The predicted salary is between 36000 - 60000 £ per year.

Turn data into clarity, trust and accountability - for a community that deserves nothing less. As a Senior Data Analyst, you'll use your skills to make sure every number tells a story, every report supports better decisions, and every insight helps move us forward with honesty and care.

In this full-time role, you'll be based in the Borough three days a week, playing a key role in serving the local community. Whether you're working on the frontline or behind the scenes, you'll be part of a dedicated team making a real difference to residents' lives.

In this role, you'll help monitor and evaluate the support provided to those affected by the Grenfell tragedy. You'll work with both quantitative and qualitative data to build clear, meaningful reports that speak to a wide range of audiences - from internal teams and partners, to resident steering groups and the Independent Scrutiny Function.

Using Power BI, you'll design and develop reporting tools that go beyond the numbers - giving visibility to progress, identifying where we can do better and helping others understand the impact of our work. You'll also lead projects to improve data quality, respond to Freedom of Information requests and contribute to our annual impact evaluation.

Your work won't sit in the background. It will help shape how support is delivered, how decisions are made and how we stay accountable to the people at the heart of this journey.

What you'll bring

You'll bring advanced analytical skills, particularly in Microsoft Excel and Power BI, and experience turning complex data into insights that drive action. You know how to design dashboards and reports that speak clearly to different audiences - and how to work sensitively in environments where accuracy, tone and transparency really matter.

You'll be confident working independently, solving problems creatively and using data to support change - even when information is incomplete or evolving. You'll also bring a strong understanding of data protection and confidentiality, especially in contexts involving trauma and public scrutiny.

Above all, you'll bring care and commitment to your work - and a belief in the power of data to do good.

Why join us

At RBKC, we're all in - investing in our people, our communities and our future. This 12-month maternity cover role sits within a team that is compassionate, collaborative and focused on meaningful progress.

You'll be supported to develop your skills, access training and grow your impact - all while contributing to one of the Council's most important priorities: learning from Grenfell and placing those lessons at the heart of everything we do.

The work is complex. The expectations are high. But so is the value of what you'll help us achieve.

About us

Kensington and Chelsea is home to diverse communities, thriving businesses and unique local places. Everything we do is focused on supporting our residents, strengthening our approach and creating a fairer borough.

As a competent and caring Council, we take pride in our work every day, ensuring our services are delivered with care and competence. We listen to our residents, act with integrity and work together to build a borough that is greener, safer and fairer for all.

This role is a clear example of what 'we're all in' really means. You'll work with purpose, getting stuck into the detail of the data while never losing sight of the bigger picture. Your insights will guide decisions, shape conversations and help ensure we remain accountable to the communities we serve - not just in words, but in measurable, visible outcomes.

Interview Details:

4th July 2025. The interview will consist of a formal interview with the panel followed by an excel exercise.

Ready to join us? We're all in - are you? If you share our values and have the skills to contribute, we'd love to hear from you.

Senior Data Analyst employer: ROYAL BOROUGH OF KENSINGTON AND CHELSEA

At RBKC, we pride ourselves on being an exceptional employer dedicated to fostering a compassionate and collaborative work environment. As a Senior Data Analyst, you'll not only have the opportunity to develop your skills and grow your impact but also play a vital role in supporting our community through meaningful data insights. With a strong commitment to employee development and a focus on making a real difference in residents' lives, working with us means being part of a team that values integrity, care, and accountability.
R

Contact Detail:

ROYAL BOROUGH OF KENSINGTON AND CHELSEA Recruiting Team

StudySmarter Expert Advice 🤫

We think this is how you could land Senior Data Analyst

✨Tip Number 1

Familiarise yourself with the specific data tools mentioned in the job description, particularly Power BI and Excel. Consider creating sample dashboards or reports that showcase your ability to turn complex data into clear insights, as this will demonstrate your practical skills during the interview.

✨Tip Number 2

Research the Grenfell tragedy and its impact on the community. Understanding the context will not only help you relate to the role but also allow you to speak knowledgeably about how data can support recovery and accountability during your interview.

✨Tip Number 3

Prepare for the Excel exercise by brushing up on your data analysis skills. Practice common functions and data manipulation techniques that are likely to be relevant, such as pivot tables, VLOOKUP, and data visualisation methods, to ensure you're ready to impress.

✨Tip Number 4

Think about examples from your past work where you've used data to drive change or improve processes. Be ready to discuss these experiences in detail, focusing on how your analytical skills made a tangible difference, as this aligns perfectly with the values of care and commitment highlighted in the job description.

We think you need these skills to ace Senior Data Analyst

Advanced Analytical Skills
Microsoft Excel Expertise
Power BI Proficiency
Data Visualisation
Report Design
Quantitative and Qualitative Data Analysis
Dashboard Development
Problem-Solving Skills
Understanding of Data Protection and Confidentiality
Effective Communication Skills
Ability to Work Independently
Attention to Detail
Creativity in Data Interpretation
Experience with Freedom of Information Requests
Commitment to Community Impact

Some tips for your application 🫡

Tailor Your CV: Make sure your CV highlights your advanced analytical skills, particularly in Microsoft Excel and Power BI. Include specific examples of how you've turned complex data into actionable insights, as this is crucial for the Senior Data Analyst role.

Craft a Compelling Cover Letter: In your cover letter, express your commitment to using data for good and how you align with the values of the organisation. Mention your experience in sensitive environments and your understanding of data protection, especially in contexts involving trauma.

Showcase Relevant Projects: If you have previous projects where you've designed dashboards or reports that catered to different audiences, be sure to include these in your application. Highlight how these projects contributed to decision-making processes.

Prepare for the Excel Exercise: Since the interview includes an Excel exercise, brush up on your Excel skills. Be ready to demonstrate your ability to analyse data and create meaningful reports, as this will be a key part of your role.

How to prepare for a job interview at ROYAL BOROUGH OF KENSINGTON AND CHELSEA

✨Showcase Your Analytical Skills

Be prepared to discuss your experience with data analysis, particularly using Microsoft Excel and Power BI. Highlight specific projects where you turned complex data into actionable insights, as this will demonstrate your ability to meet the role's requirements.

✨Understand the Context

Familiarise yourself with the Grenfell tragedy and its impact on the community. Showing that you understand the sensitivity of the work and the importance of data in supporting those affected will resonate well with the interview panel.

✨Prepare for the Excel Exercise

Since the interview includes an Excel exercise, practice common functions and data manipulation techniques. Be ready to showcase your ability to create meaningful reports and dashboards that communicate effectively to different audiences.

✨Demonstrate Care and Commitment

Emphasise your passion for using data to make a positive impact. Share examples of how you've approached previous roles with care and commitment, especially in sensitive environments, to align with the values of the organisation.

R
Similar positions in other companies
UK’s top job board for Gen Z
discover-jobs-cta
Discover now
>