Power BI Developer
Department: Web & Data
Salary: £45,000 - £50,000
Location: Euston / Hybrid
Hours: Monday to Friday, 9am - 5pm
Reporting To: Senior Data Engineer
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