Lead Power BI & Semantic Modeling Architect

SSE plc; United Kingdom; Hybrid; GBP 72,000 - 86,000; Full time

Benefits offered by this job

Flexible working options

Private healthcare discounts

Gym memberships discounts

Cycle to Work scheme

Maternity and adoption pay

Job summary

SSE plc in the United Kingdom is seeking a hands‑on Data and Analytics specialist to design, develop and optimise reusable analytical datasets and Power BI semantic models.

You will consolidate standalone datasets into scalable products, support multiple reports and Copilot‑enabled analytics, and collaborate with Power BI developers, data engineers, architects and business stakeholders to align solutions with standards.

Qualifications

• Extensive hands-on experience developing and optimising complex Power BI solutions, including reusable semantic models.
• Proven ability to consolidate multiple datasets into shared analytical products that support several reports or teams.
• Strong Power BI expertise, including DAX, relationships, storage modes, security and performance optimisation.
• Advanced SQL skills and experience with a modern data platform for data preparation and modelling, ideally including Microsoft Fabric.

Responsibilities

• Lead the hands‑on design and development of reusable analytical datasets and Power BI semantic models for BI and analytics use cases.
• Assess and consolidate standalone semantic models, bringing common data, measures and business logic into shared analytical products that support multiple reports and BI use cases.
• Translate complex business questions into clear data requirements, definitions, measures and practical Power BI solutions.
• Diagnose and resolve Power BI performance issues through effective semantic‑model design, DAX optimisation and appropriate storage choices.
• Work with Power BI developers, data engineers, architects and business stakeholders to align solutions with agreed standards and take them through testing, documentation, deployment and ongoing improvement.

Skills

Power BI

DAX

SQL

Data modelling

Stakeholder communication

Tools

Microsoft Fabric

SQL

Job description

SSE plc in the United Kingdom is seeking a hands‑on Data and Analytics specialist to design, develop and optimise reusable analytical datasets and Power BI semantic models.

You will consolidate standalone datasets into scalable products, support multiple reports and Copilot‑enabled analytics, and collaborate with Power BI developers, data engineers, architects and business stakeholders to align solutions with standards.