BI Developer & Data Analyst
Role details
Job location
Tech stack
Job description
Data, dashboards, AI, and analysis are critical in our 5-year strategy. You will be integral to the delivery of that strategy. Your work will improve performance, prove our efficacy and credibility, maximise the improvement in people's lives, and increase our influence nationally.
The BI Dashboards and adhoc data analysis you carry out will be used every day by dozens of colleagues, and external stakeholders. You will turn findings into actionable recommendations that tell clear stories with the data. Your work will be at the heart of our decision making. You'll influence what we do, why we do it, and improve the lives of the people we support.
We're a small team. You'll work directly with our Director of Data & Insights, wearing multiple hats across BI development, data engineering, analytics and AI. There's plenty of variety and opportunity to enhance your skills.
What you'll do
- Build and evolve our Microsoft-centric data platform alongside internal colleagues and trusted partners.
- Design robust pipelines (ELT/ETL) for new data sources, and manage existing ones.
- Create insightful Power BI reporting, working with stakeholders to co-create the requirements.
- Deliver analysis that drives decisions. From exploratory deep-dives to forecasting and clear recommendations, you will tell memorable stories with data - not just numbers.
- Champion governance and quality. Be a steward of our definitions and metric catalogues, improve data quality, document as you go and keep privacy/GDPR front-of-mind.
- Produce evidence packs and impact summaries for tenders and grants, and automate recurring reporting where possible.
- Deliver lightweight training and 1-to-1 support to build confident self-serve capability across the enterprise.
Requirements
Do you have experience in SQL?, * Strong Power BI (datasets, DAX, modelling, RLS, performance) and Azure / Fabric experience.
- Hands-on SQL and pipeline development (e.g. Fabric Data Pipelines / Data Factory).
- Git/Azure DevOps, automated testing and environment promotion.
- Python for wrangling, notebooks, APIs and basic ML; Advanced M/Power Query.
- Sound data architecture knowledge (star schemas, medallion architecture, semantic layers, dictionaries and lineage).
- Confidence in stakeholder engagement - gathering requirements, writing clear specs, prioritising a shared backlog and communicating simply.
- Comfortable switching between BI developer, analyst and engineer personas in a fast-moving, mission-led setting.
Don't have all the skills or experience?
We're looking for someone with enthusiasm and passion for the role, who can learn quickly and fill in their skill and experience gaps. Even if you don't have all the skills or experience for this role, use your application to tell us how you'll overcome that. We're seeking a colleague who wants to transform lives and is motivated to make a tangible difference through effective use of data.