Data Warehouse Architect

Robert Walters
Bury, United Kingdom
yesterday

Role details

Contract type
Permanent contract
Employment type
Full-time (> 32 hours)
Working hours
Regular working hours
Languages
English
Compensation
£ 75K

Job location

Bury, United Kingdom

Tech stack

Artificial Intelligence
Architectural Patterns
Azure
Computer Programming
Continuous Integration
Data Architecture
Data Governance
Data Vault Modeling
Data Warehousing
Github
Performance Tuning
Raw Data
Power BI
SQL Databases
T-SQL
Data Strategy
Microsoft Fabric
Data Lake
PySpark
Star Schema
Data Pipelines
Databricks

Job description

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., * 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

Requirements

  • 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)

Apply for this position