Business Intelligence (BI) Developer - The National Lottery Community Fund - SEO

Manchester Digital; London; Hybrid; GBP 41,000 - 52,000; Full time

Job summary

A public funding organization is seeking a passionate Business Intelligence (BI) Developer to create impactful BI solutions. This full-time position includes designing dashboards using Power BI, developing scalable data models, and ensuring insights are actionable. Ideal candidates will have strong skills in Power BI, SQL, and a background in data visualizations. The role supports an equitable and inclusive work environment and offers a hybrid working model.

Qualifications

• Experience turning user needs into BI solutions that drive decision-making.
• Hands-on data visualization experience.
• Skilled in BI coding languages including Power BI and SQL.

Responsibilities

• Design and build dashboards and reports using Power BI.
• Develop scalable data models in collaboration with teams.
• Lead the transition to automated self-service reporting.

Skills

Power BI (DAX, Power Query/M)

SQL

Data visualization

Data modeling

User-centered design

Education

Bachelor's degree or equivalent in mathematics, statistics or data analysis

Tools

Power BI

SQL Databases

Job description

Business Intelligence (BI) Developer - The National Lottery Community Fund - SEO

Full-time (Permanent) National: £38,366 - £46,891, London: £41,885 to £51,193
Published on 6 August 2025 Deadline 15 August 2025

Job summary

At The National Lottery Community Fund, we believe in the power of communities to change lives. Our Evidence and Impactteam plays a vital role in making sure our funding decisions are informed,equitable, and impactful.We’relooking for aBusiness 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.

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’llhelp us understand the impact of these funds,identifyareas of need, and ensure that insights from dormant asset investments are accessible and actionable across the Fund.

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
• Lead the transition to automated, self-service reporting across the Fund
• Work closely with analysts, business users, and stakeholders to ensure insights are accessible and actionable
• Apply user-centric design principles and continuously improve your products based on feedback and usage data

We’relooking for someone who:

• Has experience turning user needs into BI solutions that drive decision-making
• Is skilled in Power BI (DAX, Power Query/M)and SQL
• Experienced in data modelling, UI/UX best practices, and enterprise BI development
• Is passionate about using data to support equity, sustainability, and community resilience
• Thrives in a collaborative, agile environment and is eager to keep learning

Interview Date:27thAugust, virtual

Location: 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 UKoffices, these are Belfast, Birmingham, Cardiff, Exeter, Glasgow, Leeds, London,Newcastleand Newtown.

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

• A professional qualification, bachelor'sdegreeor equivalent level of experience in a relevant discipline such as mathematics,statisticsor 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 BI and database coding languages including PowerBI (DAX and Power Query/M Formula) and SQL, 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.
• 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.)

Apply Now