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