Data Warehouse Architect

Data Warehouse Architect £75,000+ benefits Bury (Hybrid) We are seeking a Data Warehouse Architect to design, establish, and govern a modern enterprise data platform. This role will bridge complex raw data and business insights by creating scalable, high-performance lakehouse and data warehouse architectures. You will play a key role in consolidating data assets, eliminating silos, and ensuring a single, source of truth to support advanced analytics and AI. Data Warehouse Architect Responsibilities: • Design and implement enterprise-wide data architecture across Microsoft Fabric (OneLake) and Databricks (Unity Catalog) • Build scalable lakehouse and warehouse solutions using Databricks SQL and Fabric SQL endpoints • Develop robust data pipelines with Databricks Workflows, Delta Live Tables (DLT), and Fabric Data Factory • Define and implement cross-platform data strategies using Delta Lake to minimise duplication • Establish data governance frameworks, including access controls, lineage, and Row-Level Security (RLS) • Manage and optimise compute resources across Fabric and Databricks environments • Lead CI/CD implementation using Azure DevOps, GitHub, and Databricks Asset Bundles • Drive adoption of best practices in data modelling and architecture patterns As Data Warehouse Architect, you will have: • Strong expertise in Microsoft Fabric (OneLake) and Databricks (Unity Catalog) architecture • Proven experience building modern lakehouse and data warehouse platforms • Hands-on experience with: • Databricks SQL & Fabric SQL • Databricks Workflows & Delta Live Tables (DLT) • Fabric Data Factory • Deep knowledge of Delta Lake and cross-platform data strategies • Solid experience in data governance, including lineage, access control, and RLS • Experience managing multi-engine compute environments • CI/CD experience with Azure DevOps, GitHub, and Databricks Asset Bundles • Strong programming skills in PySpark, Databricks SQL, and T-SQL • Understanding of Medallion Architecture and modern data modelling approaches (Star Schema, Data Vault 2.0) • Experience with performance optimisation in Databricks and integration with Power BI (Direct Lake) Robert Walters Operations Limited is an employment business and employment agency and welcomes applications from all candidates