Power BI Report Engineer (Azure / Databricks)
Glasgow | 3-4 days onsite | Exclusive Opportunity with a Leading UK Consumer Brand
Are you a Power BI specialist who loves clean, governed data and high-performance semantic models? Do you want to work with a business that’s rebuilding its entire BI estate the right way-proper Lakehouse architecture, curated Gold tables, PBIP, Git, and end-to-end governance? If so, this is one of the most modern, forward-thinking Power BI engineering roles in Scotland. Our Glasgow-based client is transforming its reporting platform using Azure + Databricks, with Power BI sitting on top of a fully curated Gold Layer. They develop everything using PBIP + Git + Tabular Editor 3, and semantic modelling is treated as a first-class engineering discipline. This is your chance to own the creation of high-quality datasets and dashboards used across Operations, Finance, Sales, Logistics and Customer Care‑turning trusted Lakehouse data into insights the business relies on every day.
? Why This Role Exists
To turn clean, curated Gold Lakehouse data into trusted, enterprise‑grade Power BI insights. You’ll own semantic modelling, dataset optimisation, governance and best‑practice delivery across a modern BI ecosystem.
? What You’ll Do
Semantic Modelling with PBIP + Git
* Build and maintain enterprise PBIP datasets fully version‑controlled in Git.
* Use Tabular Editor 3 for DAX, metadata modelling, calc groups and object governance.
* Manage branching, pull requests and releases via Azure DevOps.
Lakehouse‑Aligned Reporting (Gold Layer Only)
* Develop semantic models exclusively on top of curated Gold Databricks tables.
* Work closely with Data Engineering on schema design and contract‑first modelling.
* Maintain consistent dimensional modelling aligned to the enterprise Bus Matrix.
High‑Performance Power BI Engineering
* Optimise performance: aggregations, composite models, incremental refresh, DQ/Import strategy.
* Tune Databricks SQL Warehouse queries for speed and cost efficiency.
* Monitor PPU capacity performance, refresh reliability and dataset health.
Governance, Security & Standards
* Implement RLS/OLS, naming conventions, KPI definitions and calc groups.
* Apply dataset certification, endorsements and governance metadata.
* Align semantic models with lineage and security policies across the Azure/Databricks estate.
Lifecycle, Release & Best Practice Delivery
* Use Power BI Deployment Pipelines for Dev ? UAT ? Prod releases.
* Enforce semantic CI/CD patterns with PBIP + Git + Tabular.
* Build reusable, certified datasets and dataflows enabling scalable self‑service BI.
Adoption, UX & Collaboration
* Design intuitive dashboards with consistent UX across multiple business functions.
* Support BI adoption through training, documentation and best‑practice guidance.
* Use telemetry to track usage, performance and improve user experience.
? What We For
Required Certifications
To meet BI engineering standards, candidates must hold:
* PL-300: Power BI Data Analyst Associate
* DP-600: Fabric Analytics Engineer Associate
Skills & Experience
* 3‑5+ years building enterprise Power BI datasets and dashboards.
* Strong DAX and semantic modelling expertise (calc groups, conformed dimensions, role‑playing dimensions).
* Strong SQL skills; comfortable working with Databricks Gold‑layer tables.
* Proven ability to optimise dataset performance (aggregations, incremental refresh, DQ/Import).
* Experience working with Git‑based modelling workflows and PR reviews via Tabular Editor.
* Excellent design intuition‑clean layouts, drill paths, and KPI logic.
Nice to Have
* Python for automation or ad‑hoc prep; PySpark familiarity.
* Understanding of Lakehouse patterns, Delta Lake, metadata‑driven pipelines.
* Unity Catalog / Purview experience for lineage and governance.
* RLS/OLS implementation experience.
#J-18808-Ljbffr