Senior PowerBI Developer

Eden Scott; Glasgow; Hybrid; GBP 65,000 - 90,000; Full time

Job summary

Eden Scott is recruiting a Senior PowerBI Developer in Glasgow. The role focuses on owning the semantic layer, building scalable data models and AI-ready data products within a hybrid setup.

You will collaborate with a market-leading SaaS business, shaping BI strategy, governance and reusable analytics solutions. Strong Power BI, SQL and data modelling skills required; hybrid working in Glasgow offered.

Qualifications

• Proven experience as BI Developer, Analytics Engineer, or Data Modelling specialist.
• Strong understanding of semantic modelling, metric layers, star schema and Kimball.
• Advanced SQL skills including query optimisation and stored procedure development.
• Strong Power BI experience including DAX, M Query and dataset modelling.
• Experience building governed, reusable BI solutions rather than solely producing reports.
• Knowledge of data quality, lineage, governance and documentation.

Responsibilities

• Own the Semantic Layer: design, build and maintain governed semantic models, datasets and metric layers.
• Develop BI Solutions: build and optimise SQL queries, views and stored procedures; create Power BI datasets and semantic models.
• Build Repeatable Data Products: transform recurring requests into self-service, reusable BI solutions; enable AI-ready outputs.
• Drive Governance & Best Practice: establish core metrics, governance, data quality, and documentation; partner with Data Engineering and Product teams.

Skills

Business Intelligence

Analytics engineering

Data modelling

SQL

Power BI

DAX

AI data products

Mentoring

Tools

Power BI

Power Automate

SQL databases

Job description

Senior PowerBI Developer | Competitive Salary | Hybrid – Glasgow

Join a market-leading SaaS business building AI-ready data products and transforming how organisations use data

Are you an experienced BI professional who thrives on creating scalable, governed data models rather than simply building reports? Do you enjoy turning complex business questions into reusable data products that power analytics, automation and AI?

We are partnering with a high-growth SaaS organisation where data is central to their product strategy. With a strong Data Engineering function already in place, they're looking for a Senior Business Intelligence Developer to own the semantic layer that sits between raw data and the insights, dashboards and AI tools relied upon across the business.

What You will Be Doing

• Own the Semantic Layer
  • Design, build and maintain governed semantic models, datasets and metric layers
  • Create reusable business-ready data models built on Kimball and star-schema principles
  • Ensure data definitions are consistent, trusted and scalable across reporting, analytics and AI use cases
• Develop BI Solutions
  • Build and optimise SQL queries, views and stored procedures
  • Develop Power BI datasets, DAX measures and semantic models
  • Create intelligent, scalable reporting solutions that deliver trusted business insight
• Build Repeatable Data Products
  • Transform recurring requests into self-service, reusable BI solutions
  • Reduce reliance on manual reporting and ad-hoc analysis
  • Drive automation of repetitive analytical processes using tools such as Power Automate
  • Prepare semantic models for Copilot, AI agents and natural-language querying
  • Create descriptions, metadata, guardrails and business context that improve AI-generated insights
  • Use AI tools to accelerate development, documentation and optimisation while applying rigorous validation and quality control
• Drive Governance & Best Practice
  • Establish and document core business metrics and definitions
  • Own standards around data quality, lineage, documentation and governance
  • Partner with Data Engineering, Product and Commercial teams to deliver scalable solutions
  • Provide technical leadership and mentoring within the BI and analytics function

What We are Looking For

• Proven experience as a Business Intelligence Developer, Analytics Engineer or Data Modelling specialist
• Strong understanding of semantic modelling, metric layers, star schema and Kimball methodology
• Advanced SQL skills including query optimisation and stored procedure development
• Strong Power BI experience including DAX, M Query and dataset modelling
• Experience building governed, reusable BI solutions rather than solely producing reports
• Strong understanding of data quality, lineage, governance and documentation
• Experience identifying and automating manual analytical processes
• Confident use of AI tools with the ability to validate outputs and ensure production readiness
• Ability to translate complex business requirements into scalable data models
• Experience preparing data platforms for Copilot, AI agents or natural-language analytics
• Experience with Power Automate and workflow automation tools
• Previous experience working with complex master-data environments
• Experience mentoring developers, analysts or BI professionals
• Play a pivotal role in shaping the organisation's AI and analytics capabilities
• Move the business from reactive reporting to productised, self-service analytics
• Own the semantic layer that powers reporting, dashboards and AI-driven insights
• Work alongside a highly capable Data Engineering team
• Join a culture that values innovation, autonomy, ownership and continuous improvement
• Have genuine influence on BI strategy and technical standards across the business

You will Thrive If You

• Enjoy building systems, standards and reusable solutions rather than one-off reports
• Think in terms of data products, models, metrics and governance
• Challenge assumptions and validate outputs, especially when AI is involved
• Continuously seek opportunities to automate and improve analytical processes
• Can bridge the gap between technical teams and business stakeholders
• Take ownership and make sound technical decisions with confidence