Lead Power BI & Semantic Data Architect

Scottish and Southern Energy; Glasgow; Hybrid; GBP 50,000 - 90,000; Full time

Benefits offered by this job

Private healthcare

Gym discounts

Free online GP

24/7 counselling

Cycle to Work

Generous family entitlements

Job summary

Scottish and Southern Energy is seeking a senior Power BI specialist to design and deliver reusable semantic models, consolidating data sources and optimising DAX performance.

You will work with BI developers and stakeholders to translate complex questions into scalable analytic products, leveraging Fabric, Copilot and SQL on a modern data platform. This permanent hybrid role offers flexible options with UK locations Glasgow, Perth, Inverness or Aberdeen.

Qualifications

• Extensive hands-on experience developing and optimising complex Power BI solutions including reusable semantic models.
• Proven experience consolidating multiple datasets into shared analytical products supporting several reports/use cases.
• Strong Power BI expertise including DAX, relationships, storage modes, security and performance optimisation.
• Advanced SQL skills and experience with a modern data platform (ideally Microsoft Fabric).
• Strong analytical and stakeholder skills to turn ambiguous requirements into scalable solutions.

Responsibilities

• Lead hands-on design and development of reusable datasets and Power BI semantic models for BI use cases.
• Consolidate standalone semantic models into shared analytical products supporting multiple reports.
• Translate complex business questions into clear data requirements, definitions, and measures.
• Diagnose and resolve Power BI performance issues via semantic-model design and optimization.
• Collaborate with BI developers, data engineers, architects and stakeholders to align with standards and drive testing/deployment.

Skills

Power BI

Stakeholder management

Data modelling

Analytical thinking

Translating requirements

Tools

Power BI

DAX

Fabric

SQL

Copilot

Security

Job description

Scottish and Southern Energy is seeking a senior Power BI specialist to design and deliver reusable semantic models, consolidating data sources and optimising DAX performance.

You will work with BI developers and stakeholders to translate complex questions into scalable analytic products, leveraging Fabric, Copilot and SQL on a modern data platform. This permanent hybrid role offers flexible options with UK locations Glasgow, Perth, Inverness or Aberdeen.