Business intelligence analyst jobs in birmingham

Help Us Turn Data into Action for Communities

 At The National Lottery Community Fund, we believe in the power of communities to change lives. Our Evidence and Impact team plays a vital role in making sure our funding decisions are informed, equitable, and impactful. We’re looking for a Business Intelligence (BI) Developer who’s passionate about data, storytelling, and creating tools that empower others inside and outside of the Fund to make data driven decisions. You will report into Head of Business Intelligence (BI)

This role is especially exciting as it supports our work with dormant assets. Whereby the Fund will be unlocking unclaimed financial resources and directing them to where they can make the greatest difference. You’ll help us understand the impact of these funds, identify areas of need, and ensure that insights from dormant asset investments are accessible and actionable across the Fund.

As a BI Developer, you’ll work closely with stakeholders across the organisation—from analysts and operational teams to senior leadership—ensuring that our data tools and reporting solutions meet real-world needs. You’ll be instrumental in building scalable data models, developing ETL pipelines, and designing intuitive dashboards that empower users to explore and understand our data independently.

This role is ideal for someone who thrives in a collaborative, agile environment, values stakeholder engagement, and is passionate about using data to make a positive difference in people’s lives.

What You'll Do

As a BI Developer, you’ll:

• Design and build engaging dashboards and reports using Power BI
• Develop efficient, scalable data models in collaboration with our Data Architect and Technology teams
• Build and maintain ETL pipelines to support robust, reliable data flows
• Lead the transition to automated, self-service reporting across the Fund
• Work closely with analysts, business users, and stakeholders to ensure insights are accessible, actionable, and aligned with strategic goals
• Facilitate workshops, demos, and feedback sessions to gather requirements and improve BI products
• Apply user-centric design principles and continuously improve your products based on feedback and usage data
• Communicate complex data concepts clearly and effectively to technical and non-technical audiences

We’re looking for someone who:

• Has experience turning user needs into BI solutions that drive decision-making
• Is skilled in Power BI (DAX, Power Query/M), SQL and or python
• Has experience with ETL development
• Has experience with data modelling, UI/UX best practices, and enterprise BI development
• Understands data engineering principles and has worked with tools or platforms for data integration and transformation
• Is a confident communicator who can translate data into compelling narratives and actionable insights
• Works collaboratively across teams and builds strong relationships with stakeholders at all levels
• Is passionate about using data to support equity, sustainability, and community resilience
• Thrives in a collaborative, agile environment and is eager to keep learning

Why Join Us?

You’ll be part of a team that:

• Harnesses data to make a tangible, positive impact on communities
• Champions an equity-based approach to funding
• Supports devolved, community-led decision-making
• Values innovation, compassion, and adaptability
• Is committed to professional development and shared learning
• Encourages open communication, teamwork, and cross-functional collaboration

Any questions about the recruitment process, please email us.

Interview Date: Virtual, 6th November

Location: UK-wide - We have a hybrid approach to working, work pattern and location will be agreed with the successful candidate. The role can be based at any of our UK offices, these are Belfast, Birmingham, Cardiff, Exeter, Glasgow, Leeds, London, Newcastle and Newtown.

On application, please align your supporting statement to the criteria below

Essential Criteria

• A professional qualification, bachelor's degree or equivalent level of experience in a relevant discipline such as mathematics, statistics or data analysis.
   
• Experienced in taking user requirements and functional designs and turning these into BI products for a wide range of users.
   
• Hands on data visualisation experience, with a strong background in developing enterprise BI products that meet the needs of a wide range of users.
   
• Skilled in data coding languages and practical techniques with demonstrable experience and/or professional certifications.
   
• Awareness of data quality best practice and how it should apply to enterprise BI.
   
• Experience of developing and maintaining productionised BI solutions, including the full development lifecycle.
   
• Awareness of industry-recognised data modelling patterns and standards.

Desirable Criteria

• Awareness of project management techniques, and an appreciation of how they are applied in the environment.

Equity, Diversity and Inclusion 

 Communities in the UK come in all shapes and sizes. National Lottery funding is for everyone – therefore, we are committed to equity, diversity and inclusion and we work hard to ensure our funding reaches where it is needed.  

We also believe our people should represent the communities, organisations and individuals we work with. That’s why The National Lottery Community Fund is committed to being an inclusive employer and a great place to work. We recognise and celebrate the fact that our people come from diverse backgrounds. We positively welcome applications from people from ethnic minority backgrounds, people with disabilities or longstanding health conditions, people who are LGBTQ+, and people from different socio-economic and educational backgrounds, as well as people of all ages. 

As a Disability Confident Employer, we take a proactive approach in making reasonable adjustments, if needed, throughout the recruitment process and during employment. (This can be related to a physical and mental health condition.) 

Location: Birmingham (Hybrid working - minimum of 2 days in the office) 

Interviews: 27th and 28th October

For more information, or to apply, please click 'apply now' to be directed to our website.

Join Our Mission – Drive Impact Through Financial Excellence 

We’re looking for a qualified accountant with a strong understanding of charity fund accounting to play a pivotal role in our mission to change the lives of young people. As our Financial & Funding Accountant, you’ll lead our financial accounting team and ensure our financial processes are effective, accurate, and aligned with charity governance standards.

This is a senior accounting role, so we’re specifically looking for candidates who are:

• Professionally qualified (e.g. ACA, ACCA, CIMA or equivalent) 

• Experienced in charity financial reporting, including restricted and unrestricted fund accounting 

• Confident managing complex funding streams, statutory accounts and regulatory returns.

From owning the balance sheet and managing audits to preparing statutory accounts and regulatory returns, you'll play a key role in maintaining the integrity and transparency of our finances. You’ll work closely with colleagues across the organisation to ensure we maximise every pound of charitable funding in support of our work.  

This is more than just numbers, it's about making a real difference. If you're a qualified accountant, who brings charity fund accounting experience, excellent communication skills, and a collaborative mindset, we’d love to hear from you. We welcome applicants from all backgrounds and experiences. 

What happens next?  

Please submit a CV, and Cover Letter that includes your experience, transferrable skills and motivation to work for The King's Trust! The Team will be in touch about the next steps shortly after the closing date. 

Why do we need Financial & Funding Accountants? 

Last year, we helped more than 40,000 Young People, with three in four young people on our programmes moving into a positive outcome in work, education or training. The young people we help face a range of challenges, such as unemployment, mental health issues or some who have been in trouble with the law. We believe all young people should have the chance to succeed, and that young people are the key to a positive and prosperous future for all of us. We want to continue having a positive impact on young people’s lives and we couldn’t do this without the important work of Financial & Funding Accountants! 

Perks for working at The Trust! 

• Great holiday package! 30 days annual leave entitlement, plus bank holidays. Office closure on the days between Christmas and New Year 
• Flexible working! Where operationally possible, our roles require a combination of office days and working from home (please speak to the hiring manager about this particular role)
• You can volunteer for and/or attend events – The King's Trust Awards, Pride, active events etc. 
• In-house learning platform! Develop your skills for your career and your role 
• Benefits platform! Everything from health and financial well-being support to discounts on your favourite restaurants, shops and cinemas. 
• Personal development opportunities through our Networks – KT CAN (Cultural Awareness Network), KT GEN (Gender Equality Network), KT DAWN (Disability & Wellbeing Network), and PULSE (LGBTQIA+ Network). 
• Fantastic Family leave! Receive 13 weeks of full pay and 13 weeks of half pay for maternity and adoption leave. Receive 8 weeks of full pay for paternity leave. 
• Interest-free season ticket loans 
• The Trust will contribute 5% of your salary to the Trust Pension Scheme 
• Generous life assurance cover (4 x annual salary)