Power BI Developer

Power BI Developer

Department: Web & Data

Salary: £45,000 - £50,000

Location: Euston / Hybrid

Hours: Monday to Friday, 9am - 5pm

Role Purpose

To support the delivery of high quality Power BI reporting across the group by building dashboards, reports, semantic models and measures, and by contributing to a consistent and trusted reporting layer.

The role will focus primarily on Power BI development, with supporting SQL work where required. The successful candidate will be expected to develop their skills over time and follow best practice guidance from the Analytics Engineer (Power BI lead) and Senior Data Engineer.

Main Responsibilities

Stakeholder engagement and delivery

Work with stakeholders across the business to define, scope and deliver new reporting functionality in Power BI by translating business questions into clear reporting requirements, including KPIs, definitions and expected outputs

Manage reporting requests through a structured delivery lifecycle, including development, testing and release

Power BI semantic model ownership

• Support the maintenance and enhancement of the underlying semantic models in Power BI, including developing and maintaining DAX measures in line with agreed business definitions
• Ensure semantic models are well structured, reusable and high performing, supporting both dashboards and self-service reporting
• Support the Analytics Engineer in maintaining consistent reporting standards across the group

Reporting layer within the data warehouse

• Support the development and maintenance of the reporting layer within the data warehouse, primarily through SQL views and reporting tables
• Work closely with data engineering to ensure warehouse outputs are fit for reporting and aligned to dimensional modelling principles
• Support investigation of data quality issues and ensure reporting outputs reconcile to source systems where required
• Identify opportunities to improve reporting performance by optimising SQL logic and semantic model design

Skills and Experience (Essential)

• Strong experience with Microsoft Power BI, including DAX
• Experience working with Power BI Service including publishing, workspaces and scheduled refresh
• Strong Microsoft T-SQL skills, including views and stored procedures, Common Table Expressions and window functions
• Basic understanding of data modelling principles including facts, dimensions and star schema

Skills and Experience (Desirable)

• Experience working with Azure Synapse
• Experience using Power Query and M
• Understanding of performance tuning in Power BI datasets and reports
• Experience working with Git and structured release processes