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