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