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

Government Digital and Data; United Kingdom; Hybrid; GBP 35,000 - 55,000; Full time

Job summary

A prominent public sector organization is seeking a Business Intelligence Developer to create impactful BI solutions that empower data-driven decision making. You will design dashboards, develop data models, and work collaboratively in a hybrid environment. The ideal candidate will have strong skills in Power BI and SQL, with a passion for using data to support equity and community resilience.

Qualifications

• Experience in transforming user requirements into BI products.
• Hands-on data visualization experience.
• Skilled in BI and database coding languages.

Responsibilities

• Design and build dashboards and reports using Power BI.
• Develop efficient, scalable data models.
• Lead the transition to automated reporting.

Skills

Power BI

SQL

Data visualization

User-centric design

Education

Bachelor's degree in a relevant discipline

Tools

DAX

Power Query/M

Job description

Job summary

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.

This role is especially exciting as it supports our work with dormant assets, 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.

Job description

As a BI Developer, you’ll:

1. Design and build engaging dashboards and reports using Power BI
2. Develop efficient, scalable data models in collaboration with our Data Architect and Technology teams
3. Lead the transition to automated, self-service reporting across the Fund
4. Work closely with analysts, business users, and stakeholders to ensure insights are accessible and actionable
5. Apply user-centric design principles and continuously improve your products based on feedback and usage data

We’re looking for someone who:

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

Interview Date: 27th August, 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 UK offices: Belfast, Birmingham, Cardiff, Exeter, Glasgow, Leeds, London, Newcastle, and Newtown.

If you would like an informal conversation about the role specifically, please contact: [e-mail]

Any questions about the recruitment process, please email: [e-mail]

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
• Experience in transforming user requirements and functional designs into BI products for diverse users
• Hands-on data visualization experience, with a strong background in developing enterprise BI products that meet user needs
• Skilled in BI and database coding languages including Power BI (DAX and Power Query/M) and SQL, with demonstrable experience and/or professional certifications
• Awareness of data quality best practices and their application in enterprise BI
• Experience in developing and maintaining productionized BI solutions, including the full development lifecycle
• Knowledge of industry-recognized data modeling patterns and standards

Desirable criteria

• Knowledge of project management techniques and their application in relevant environments

Equity, Diversity, and Inclusion

We are committed to ensuring our funding reaches everyone and that our team reflects the communities we serve. We welcome applications from all backgrounds, including ethnic minorities, individuals with disabilities or health conditions, LGBTQ+ individuals, and those from diverse socio-economic and educational backgrounds.

As a Disability Confident Employer, we proactively make reasonable adjustments throughout the recruitment process and employment, if needed.