Senior Analytics Engineer: Semantic Layer & Data Products

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

Job summary

Eden Scott in Glasgow partners with a market-leading SaaS business to recruit a Senior Analytics Engineer. You will own the semantic layer between raw data and insights, dashboards and AI tools, building scalable, governed data products.

The role focuses on semantic modelling, metrics governance and repeatable data products, with strong SQL, Power BI and automation skills, in a hybrid Glasgow setting.

Qualifications

• Proven experience as an 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 turning ad-hoc reporting requirements into governed, reusable solutions.
• Strong understanding of data quality, lineage, governance and documentation.
• Ability to translate complex business requirements into scalable data models.
• Comfort with AI tools and preparing models for Copilot or NL analytics.

Responsibilities

• Design, build and maintain governed semantic models and datasets.
• 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.
• Establish and document core business metrics and definitions.
• Own standards around data quality, lineage, documentation and governance.
• Transform recurring requests into self-service, reusable analytical products.
• Reduce reliance on manual reporting and ad-hoc analysis.
• Drive automation of repetitive analytical processes using Power Automate.
• Prepare semantic models for Copilot, AI agents and natural-language querying.
• Create descriptions, metadata, guardrails and business context to improve AI-generated insights.
• Use AI tools to accelerate development, documentation and optimisation while applying rigorous validation and QA.
• Set best practices for analytics engineering and data modelling.
• Mentor Analytics Engineers and support the wider data team.
• Partner closely with Data Engineering, Product and Commercial teams to deliver scalable solutions.

Skills

Semantic modelling

Star schema

Kimball methodology

SQL

Power BI

DAX

M Query

Data governance

Tools

Power Automate

Job description

Eden Scott in Glasgow partners with a market-leading SaaS business to recruit a Senior Analytics Engineer. You will own the semantic layer between raw data and insights, dashboards and AI tools, building scalable, governed data products.

The role focuses on semantic modelling, metrics governance and repeatable data products, with strong SQL, Power BI and automation skills, in a hybrid Glasgow setting.