At a Glance
- Tasks: Create impactful Power BI reports and support data-driven decisions for a charity.
- Company: Join a leading charity focused on enhancing services for young people.
- Benefits: Generous pension, healthcare plan, 25 days holiday, and volunteer leave.
- Why this job: Make a real difference using data to improve lives and influence positive change.
- Qualifications: Strong SQL skills, experience with Power BI, and a passion for data analysis.
- Other info: Flexible home-based role with opportunities for regional travel and career growth.
The predicted salary is between 35300 - 41000 £ per year.
Overview
This job is brought to you by Jobs/Redefined, the UK's leading over-50s age inclusive jobs board.
Application Deadline: 8 February 2026
Department: Strategy Impact & Planning
Employment Type: Permanent
Location: Home based / with some regional travel
Compensation: GBP 41,328 - GBP 48,621 / year
Description
Working closely with teams across the DofE, the Senior Data & Insights Analyst will play a vital role in strengthening how the charity uses data to inform decisions, enhance services for young people, and demonstrate impact to funders and partners. The role involves developing and maintaining high-quality Power BI reports and dashboards, building reliable SQL-based datasets, and supporting colleagues in accessing, interpreting, and applying data from Microsoft Dynamics and other core systems. You will also contribute to improving data governance and data quality practices across the organisation.
Responsibilities
- Build and maintain Power BI dashboards and reports that provide clear, actionable insight.
- Work with stakeholders to understand reporting needs and deliver effective solutions.
- Produce KPI and performance reports with trend analysis and commentary.
- Carry out ad-hoc analysis to support decision-making and continuous improvement.
- Use SQL to extract and prepare data from Dynamics 365 and other systems.
- Support data quality, data governance, and improvements to CRM processes.
- Help colleagues interpret data, run basic training, and promote self-service reporting.
- Contribute to data migration, system enhancements, and new reporting layers.
What we are looking for
- Strong SQL skills and knowledge in preparing datasets for analysis.
- Strong understanding in a data or BI role, ideally in the charity, public, education or youth sector.
- Proven ability to build Power BI dashboards (or similar tools) including data modelling/DAX.
- Knowledge with Microsoft Dynamics 365 or similar CRM systems.
- Advanced Excel skills.
- Strong analytical, problem-solving and communication skills.
- High attention to detail and ability to manage multiple priorities.
How to apply and interview dates
If you feel excited by this role and believe you have the necessary skills and experience to become a valued team member, please go to our website and apply. The deadline for applying for this role is: 8th February - Midnight. 1st interviews will take place on: WC 23rd February - to be held virtually via Teams. 2nd interviews will take place on: WC 2nd March - To be held virtually via Teams.
Contact
If you would like to access the application form in a different format or if you would like any assistance that might help improve your experience while completing the application, please contact us by email.
Benefits
We offer excellent staff benefits including a generous pension contribution, an employee assistance programme, healthcare cash plan and volunteer leave. Also, 25 days holiday, plus.
Senior Data & Insights Analyst in London employer: The Duke of Edinburgh's Award
Contact Detail:
The Duke of Edinburgh's Award Recruiting Team
StudySmarter Expert Advice 🤫
We think this is how you could land Senior Data & Insights Analyst in London
✨Tip Number 1
Network like a pro! Reach out to people in the industry, especially those already working in data and insights roles. A friendly chat can lead to valuable insights and even job referrals.
✨Tip Number 2
Show off your skills! Create a portfolio showcasing your Power BI dashboards and SQL projects. This gives potential employers a taste of what you can do and sets you apart from the crowd.
✨Tip Number 3
Prepare for interviews by brushing up on common data-related questions. Think about how you've used data to drive decisions in past roles and be ready to share specific examples.
✨Tip Number 4
Don't forget to apply through our website! It’s the best way to ensure your application gets noticed. Plus, we love seeing candidates who are genuinely excited about joining our team.
We think you need these skills to ace Senior Data & Insights Analyst in London
Some tips for your application 🫡
Tailor Your Application: Make sure to customise your CV and cover letter for the Senior Data & Insights Analyst role. Highlight your SQL skills, Power BI experience, and any relevant work in the charity or education sectors. We want to see how your background aligns with what we do!
Showcase Your Analytical Skills: In your application, don’t just list your skills—demonstrate them! Use specific examples of how you've used data to drive decisions or improve processes. This will help us see your analytical prowess in action.
Be Clear and Concise: When writing your application, keep it straightforward. Use clear language and avoid jargon unless it's relevant. We appreciate a well-structured application that gets straight to the point—just like the reports you’ll be creating!
Apply Through Our Website: Don’t forget to submit your application through our website! It’s the best way for us to receive your details and ensures you’re considered for the role. Plus, it’s super easy to do—just follow the prompts!
How to prepare for a job interview at The Duke of Edinburgh's Award
✨Know Your Data Tools
Make sure you brush up on your SQL skills and Power BI knowledge before the interview. Be ready to discuss how you've used these tools in past roles, as well as any specific projects where you built dashboards or reports. This will show that you're not just familiar with the tools, but that you can leverage them effectively.
✨Understand the Charity Sector
Since this role is within a charity, it’s crucial to understand the unique challenges and opportunities in this sector. Research the organisation's mission and values, and think about how data can enhance their services for young people. This will help you align your answers with their goals during the interview.
✨Prepare for Scenario Questions
Expect questions that ask you to solve hypothetical problems or analyse data scenarios. Practice articulating your thought process clearly, focusing on how you would approach data quality issues or stakeholder reporting needs. This will demonstrate your analytical skills and problem-solving abilities.
✨Showcase Your Communication Skills
As a Senior Data & Insights Analyst, you'll need to explain complex data insights to non-technical colleagues. Prepare examples of how you've successfully communicated data findings in the past, and be ready to discuss how you would support training and promote self-service reporting among team members.