Lead Data Analyst - BI and Semantic Modelling

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

Base Location: You'll be expected to spend 50% of your working week in one of the following locations : Glasgow, Perth, Inverness or Aberdeen

Salary: £71,869 - £85,880 and a range of benefits to support your finances, wellbeing and family.

Working Pattern: Permanent | Full Time | Flexible First options available

The role

Join the Data and Analytics team in Transmission Digital in a hands‑on technical role focused on designing, developing and optimising reusable analytical datasets and Power BI semantic models.

Working across our data platform and Power BI, you will consolidate standalone datasets and models into scalable, high‑performing analytical products that support multiple reports, self‑service analytics and emerging Copilot-enabled experiences.

You will

• 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

You have

• Extensive hands‑on experience developing and optimising complex Power BI solutions, including reusable semantic models rather than only individual reports or dashboards
• Proven experience consolidating multiple standalone datasets or semantic models into shared analytical products supporting several reports, teams or business use cases
• Strong Power BI expertise, including DAX, relationships, storage modes, security and performance optimisation
• Advanced SQL skills and practical experience using a modern data platform for data preparation, transformation and analytical modelling, ideally including Microsoft Fabric
• Strong analytical and stakeholder skills, with the ability to turn ambiguous requirements and fragmented data into scalable, maintainable solutions; experience preparing models for Copilot or natural‑language querying would be advantageous

About SSE

SSE’s purpose is to provide energy needed today while building a better world of energy for tomorrow. We do this by developing, building, operating and investing in electricity infrastructure and businesses needed in the energy transition. Our Transforming for Growth investment plansees us investing £33bn in critical electricity infrastructure across the five years to 2030.

Our IT division powers growth across all SSE business areas by making sure we have the systems, software and security needed to take the lead in a low carbon world. They provide expertise, advice and day‑to‑day support in emerging technologies, data and analytics, cyber security and more.

Flexible benefits to fit your life

Enjoy discounts on private healthcare and gym memberships. Wellbeing benefits like a free online GP and 24/7 counselling service. Interest‑free loans on tech and transport season tickets, or a new bike with our Cycle to Work scheme. As well as generous family entitlements such as maternity and adoption pay, and paternity leave.

Work with an equal opportunity employer

SSE will make any reasonable adjustments you need to ensure that your application and experience with us is positive. Please contact [e-mail] / 01738 275 846 to discuss how we can support you.

We're dedicated to fostering an open and inclusive workplace where people from all backgrounds can thrive. We create equal opportunities for everyone to succeed and especially welcome applications from those who may not be well represented in our workforce or industry.

#LI-DB1

#LI-Hybrid