Lead Power BI & Semantic Modeling

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

Benefits offered by this job

Private healthcare discounts

Gym memberships discounts

Online GP

Cycle to Work

Job summary

SSE plc is seeking a highly skilled data analytics specialist to join the Transmission Digital team. You will design, develop and optimise reusable analytical datasets and Power BI semantic models to support multiple reports and self‑service analytics.

Working across our data platform, you will consolidate standalone models into shared analytical products, tackle performance issues with DAX optimisation and collaborate with engineers, architects and stakeholders to deliver robust, scalable BI

Qualifications

• Extensive hands-on experience developing and optimising Power BI solutions.
• Experience consolidating datasets into shared analytical products.
• Strong SQL skills and data platform experience.
• Ability to translate business questions into data requirements.

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 management

Tools

Microsoft Fabric

Power BI Service

Job description

SSE plc is seeking a highly skilled data analytics specialist to join the Transmission Digital team. You will design, develop and optimise reusable analytical datasets and Power BI semantic models to support multiple reports and self‑service analytics.

Working across our data platform, you will consolidate standalone models into shared analytical products, tackle performance issues with DAX optimisation and collaborate with engineers, architects and stakeholders to deliver robust, scalable BI