> Markdown version of [/jobs/ext/2789760-lead-data-analyst-bi-and-semantic-modelling](https://www.wearedevelopers.com/jobs/ext/2789760-lead-data-analyst-bi-and-semantic-modelling). Every page supports `.md` or `Accept: text/markdown`. Links point to the HTML versions so they work for humans too. Agent guide: [/agents.md](https://www.wearedevelopers.com/agents.md).

---

# Lead Data Analyst - BI and Semantic Modelling

- **Company:** SSE plc
- **Location:** Aberdeen, UK
- **Experience:** Expert
- **Salary:** £71,869.0 - £85,880.0
- **Contract:** Permanent contract
- **Skills:** Business Logic, Data Cleansing, Data Infrastructure, Performance Tuning, Power BI, Sql Optimization, Microsoft Fabric, Data Analytics
- **Published:** September 8, 2026
- **Apply:** https://www.collegerecruiter.com/job/2845698357-lead-data-analyst-bi-and-semantic-modelling

## About the Role

* 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

## Description

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


## Related Videos

- [Beyond Dashboards: Fixing Text-to-SQL with Semantic RAG](https://www.wearedevelopers.com/videos/2036-beyond-dashboards-fixing-text-to-sql-with-semantic-rag)
- [RPA in the Public Sector](https://www.wearedevelopers.com/videos/86-rpa-in-the-public-sector)
- [The Algorithm That Nearly Killed Me: When Testing Isn't Enough](https://www.wearedevelopers.com/videos/2110-the-algorithm-that-nearly-killed-me-when-testing-isn-t-enough)
- [Data Analytics with Microsoft Fabric: End-to-End Use Case with Data Agents](https://www.wearedevelopers.com/videos/1547-data-analytics-with-microsoft-fabric-end-to-end-use-case-with-data-agents)
- [Beyond SQL Generation: How to Teach Agents What Your Database Actually Means](https://www.wearedevelopers.com/videos/100127-beyond-sql-generation-how-to-teach-agents-what-your-database-actually-means)
- [Anomaly Detection - Using unsupervised Machine Learning for detecting anomalies in customer base](https://www.wearedevelopers.com/videos/6-anomaly-detection-using-unsupervised-machine-learning-for-detecting-anomalies-in-customer-base)

## Related Articles

- [Data Analyst Salary in the UK](https://www.wearedevelopers.com/magazine/278-data-analyst-salary-in-the-uk)
- [Making Data Warehouses Fast: A Developer’s Story](https://www.wearedevelopers.com/magazine/107-making-data-warehouses-fast-a-developer-s-story)
- [Data Engineer Salary UK](https://www.wearedevelopers.com/magazine/253-data-engineer-salary-uk)
- [MLops – Deploying, Maintaining And Evolving Machine Learning Models in Production](https://www.wearedevelopers.com/magazine/115-mlops-deploying-maintaining-and-evolving-machine-learning-models-in-production)
- [Coffee with Developers - Maria Apazoglou - Making AI understandable for all in production](https://www.wearedevelopers.com/magazine/475-coffee-with-developers-maria-apazoglou-making-ai-understandable-for-all-in-production)
- [Graph and AI Trends 2026: Why Is AI Running but Not Yet Delivering?](https://www.wearedevelopers.com/magazine/680-graph-and-ai-trends-2026-why-is-ai-running-but-not-yet-delivering)