Business Intelligence (BI) Developer

The National Lottery Community Fund; Cardiff; On-site; GBP 40,000 - 60,000; Full time

Job summary

A prominent UK charity organization is seeking a BI Developer to ensure data tools and reporting solutions meet real-world needs. In this role, you will design dashboards, develop ETL pipelines, and engage with stakeholders to translate data into insights that drive decisions. Strong background in Power BI, SQL, and a related degree required. The position supports a commitment to equity and community resilience.

Qualifications

• Experience turning user needs into BI solutions that drive decision-making.
• Hands-on data visualization experience.
• Experience developing and maintaining productionized BI solutions.

Responsibilities

• Design and build engaging dashboards and reports using Power BI.
• Develop efficient, scalable data models.
• Build and maintain ETL pipelines.

Skills

Power BI

SQL

Python

Data visualization

Agile methodologies

Education

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

Tools

Azure Synapse

AWS Redshift

Job description

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

• 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.
• Have experience turning user needs into BI solutions that drive decision‑making.
• Be skilled in Power BI (DAX, Power Query/‑M), SQL, and/or Python.
• Have experience with ETL development.
• Have experience with data modeling, UI/UX best practices, and enterprise BI development.
• Understand data engineering principles and have worked with tools or platforms for data integration and transformation.
• Be a confident communicator who can translate data into compelling narratives and actionable insights.
• Work collaboratively across teams and build strong relationships with stakeholders at all levels.
• Be passionate about using data to support equity, sustainability, and community resilience.
• Thrives in a collaborative, agile environment and is eager to keep learning.
• Hold a professional qualification or a bachelor’s degree (or equivalent experience) in a relevant discipline such as mathematics, statistics, or data analysis.
• Be experienced in taking user requirements and functional designs and turning these into BI products for a wide range of users.
• Have hands‑on data visualisation experience, with a strong background in developing enterprise BI products that meet the needs of a wide range of users.
• Be skilled in data coding languages and practical techniques with demonstrable experience and/or professional certifications.
• Be aware of data quality best practice and how it should apply to enterprise BI.
• Have experience of developing and maintaining productionised BI solutions, including the full development lifecycle.
• Be aware 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.
• Experience with Agile or Waterfall project management frameworks.
• Knowledge of BI governance, data cataloguing, and metadata management.
• Familiarity with cloud data platforms such as Azure Synapse, Snowflake, or AWS Redshift.
• Experience with Python or R for advanced analytics and data science use cases.

Our Commitment to Diversity and Inclusion

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 are committed to equity, diversity, and inclusion, and we work hard to ensure our funding reaches where it is needed. You 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.