Find a job 
Featured Companies 
Featured Universities 
For Companies At a Glance
- Tasks: Analyse data to enhance services for young people and support decision-making.
- Company: Join a leading charity dedicated to empowering youth through data-driven insights.
- Benefits: Generous pension, healthcare plan, 25 days holiday, and additional leave options.
- Why this job: Make a real impact by using data to drive positive change for young people.
- Qualifications: Strong SQL skills, experience with Power BI, and a passion for data analysis.
- Other info: Flexible working environment with opportunities for professional growth.
The predicted salary is between 36000 - 60000 £ per year.
About the role
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.
- 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
We’re looking for someone with the following knowledge:
- 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.
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 recruitment@dofe.org.
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 Bank Holidays and an additional 3 days paid leave between Christmas and the New Year. Buy additional annual leave, benefits discount website, death in service benefit 4 x salary, incapacity benefit, generous family leave and sick leave.
The DofE are committed to safeguarding and promoting the welfare of young people. All successful applicants will be required to undergo an Enhanced Disclosure and Barring Service check, including references covering any gaps of employment/education, confirm eligibility to work in the UK and complete a health check.
The geographical allowance is based on a member of staff having a home or office-based postcode within 30 miles (as the crow flies) from Charing Cross, WC2N 5HS. The allowance is 7% capped at £4,000 per annum.
Senior Data and Insights Analyst 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 and Insights Analyst
✨Tip Number 1
Get to know the company and its mission. When you’re preparing for interviews, dive deep into the DofE's values and how they use data to make a difference. This will help you tailor your responses and show that you’re genuinely interested in contributing to their goals.
✨Tip Number 2
Practice your SQL skills! Since this role requires strong SQL knowledge, brush up on your querying techniques. You might even want to prepare a few examples of how you've used SQL to solve problems or improve processes in past roles.
✨Tip Number 3
Showcase your Power BI prowess. If you’ve built dashboards before, be ready to discuss them in detail. Bring along examples of your work or even create a mini portfolio to demonstrate your skills during the interview.
✨Tip Number 4
Don’t forget to apply through our website! It’s the best way to ensure your application gets noticed. Plus, it shows you’re proactive and serious about joining the team at DofE.
We think you need these skills to ace Senior Data and Insights Analyst
Some tips for your application 🫡
Show Off Your SQL Skills: Make sure to highlight your strong SQL skills in your application. We want to see how you've used SQL to prepare datasets for analysis, so share specific examples that demonstrate your expertise.
Power BI Dashboards are Key: Since building Power BI dashboards is a big part of this role, include any relevant experience you have with Power BI or similar tools. Tell us about the dashboards you've created and how they provided actionable insights.
Tailor Your Application: Take the time to tailor your application to the job description. We love seeing candidates who understand our mission and can connect their experience to the charity sector, especially in data roles.
Apply Through Our Website: Don't forget to apply through our website! It's the best way for us to receive your application and ensures you’re considered for the role. Plus, it’s super easy to do!
How to prepare for a job interview at The Duke of Edinburgh's Award
✨Know Your SQL Inside Out
Make sure you brush up on your SQL skills before the interview. Be ready to discuss how you've used SQL to prepare datasets for analysis in previous roles. You might even be asked to solve a problem on the spot, so practice writing queries and think about how you can explain your thought process clearly.
✨Show Off Your Power BI Skills
Since this role involves building Power BI dashboards, come prepared with examples of your work. If possible, bring a portfolio or screenshots of dashboards you've created. Be ready to talk about the data modelling and DAX techniques you used, as well as how your reports provided actionable insights.
✨Understand the Charity Sector
Familiarise yourself with the charity, public, or education sectors, especially how they use data to inform decisions. Research the DofE's mission and values, and think about how your skills can contribute to their goals. This will show your genuine interest in the role and the organisation.
✨Prepare for Stakeholder Engagement
This role requires working closely with various stakeholders, so be ready to discuss how you've successfully collaborated with others in the past. Think of examples where you understood reporting needs and delivered effective solutions. Highlight your communication skills and your ability to promote self-service reporting among colleagues.
