Power BI Developer Analyst

3 month contract role with a Local Authority

Job Summary:

• We are seeking a skilled Power BI Developer/Analyst to join the Data Insight team within Health and Social Care at a London Borough.

• This role will focus on designing, developing, and deploying high-quality Power BI dashboards to support data-driven decision-making across the organisation.

• You will play a key role in advancing the council’s data strategy by transforming complex datasets into meaningful insights that improve services and outcomes for residents.

• This is a hybrid role requiring 2 days in the office and 3 days remote working.

Key Duties/Accountabilities (Sample):

• Design, develop and deploy interactive Power BI dashboards and reports across multiple service areas

• Define key metrics and build robust data models to support performance reporting

• Develop calculations and measures using DAX for large and complex datasets

• Extract, transform and load data using Power Query and M code

• Write and optimise SQL queries to support data transformation and reporting

• Collaborate with data engineers on Azure-based data platforms

• Manage Power BI environments including datasets, workspaces, security and refresh schedules

• Gather and document stakeholder requirements for reporting and analytics solutions

• Ensure dashboards are user-friendly, accessible (WCAG compliant), and visually engaging

• Promote best practice and support the wider analyst community in Power BI development

• Develop QA processes and standards for dashboard development

• Ensure compliance with GDPR and data governance standards

• Act as a champion for data visualisation and data-driven decision making

Skills/Experience:

• Strong experience developing end-to-end Power BI reporting solutions

• Proven ability to design and deliver impactful dashboards

• Advanced knowledge of DAX and when to apply it effectively

• Strong SQL skills for querying and transforming data

• Solid data modelling experience within Power BI

• Experience working with Azure data platforms

• Knowledge of Power Query and M code

• Understanding of data governance, GDPR and data security best practices

• Experience gathering and translating stakeholder requirements

• Strong analytical and problem-solving skills

• Ability to manage multiple priorities and meet tight deadlines

• Experience working collaboratively with analysts and technical teams

• Public sector or local authority experience (desirable)

• Power BI certification (e.g. PL-300) desirable

• Experience with WCAG accessibility standards

Additional Information:

• Bi-Weekly Payments.

• Duration: 12 weeks (maternity cover).

• Hours: 35 hours per week.

• Location: Hybrid (2 days office – Islington, 3 days remote).

• Rate: Umbrella: £34.29 per hour.