Business Intelligence (BI) Developer Job at National Lottery Community Fund – 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)
Job description
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
Person specification
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.
Closing Date: Friday 24th October 2025