Data Warehouse Architect

Posted 12 hours 46 minutes ago by Robert Walters

£70,000 - £75,000 Annual
Permanent
Full Time
Factory Jobs
Lancashire, Bury, United Kingdom, BL8 1
Job Description

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