Data Warehouse Architect

Leonard Curtis; Bury; On-site; GBP 100,000 - 150,000; Full time

Benefits offered by this job

27 days holiday + statutory holidays

Birthday leave

Giving back days

Enhanced maternity pay

Hard working, fun and professional env

Job summary

Leonard Curtis is seeking a Data Warehouse Architect to establish and optimise a unified enterprise data platform that enables data‑driven decisions. You will bridge raw data to business insight, designing scalable Lakehouse and data warehouse architectures with robust security and governance.

Focus on eliminating silos and creating a single source of truth for analytics and AI initiatives. The role requires expertise in Fabric OneLake, Databricks Unity Catalog, Delta Lake, and modern data

Qualifications

• Expertise in Microsoft Fabric OneLake and Databricks Unity Catalog architecture.
• Experience building scalable lakehouse and warehouse solutions (Databricks SQL, Fabric SQL).
• Strong data pipeline development using Databricks Workflows, DLT, and Fabric Data Factory.
• Knowledge of Delta Lake and cross-platform data strategies to reduce duplication.
• Data governance expertise, including Unity Catalog, RLS, and data lineage.
• Experience managing compute across Fabric and Databricks environments.
• CI/CD knowledge using Azure DevOps, GitHub, and Databricks Asset Bundles.
• Proficiency in PySpark, Databricks SQL, T-SQL, and Delta Lake internals.
• Strong understanding of Medallion Architecture and modern data modelling (Star Schema, Data Vault 2.0).
• Experience optimising Databricks performance and integrating with Power BI (Direct Lake).

Responsibilities

• Design global architectural blueprints combining Microsoft Fabric OneLake and Databricks Unity Catalog.
• Build optimised Lakehouse and warehouse structures using Databricks SQL and Fabric SQL endpoints.
• Establish data pipelines using Databricks Workflows, Delta Live Tables (DLT), and Fabric Data Factory.
• Formulate cross-platform data strategies utilising shared Delta Lake formats to eliminate data duplication.
• Implement unified data governance, access controls, and Row‑Level Security (RLS) via Unity Catalog.
• Direct multi‑engine computation strategies using Fabric capacities alongside Databricks clusters.
• Define CI/CD deployment frameworks across both platforms using Azure DevOps, GitHub, and Databricks Asset Bundles.
• Salary aligned with your skills and expertise
• 27 days holiday allowance plus statutory public holidays and the option to purchase more
• Birthday leave
• 2 giving back days per year. We encourage our team to support the wider community by providing paid leave to work with local charities or good causes
• A hard working, fun and professional working environment
• Enhanced family friendly policies, including enhanced Maternity pay

Skills

Lakehouse architecture

Data governance

Data modelling

Cross-platform data strategies

Security frameworks

Power BI integration (Direct Lake)

CI/CD best practices

Compute orchestration across Fabric/DT

Databricks Databricks SQL

Fabric SQL

Delta Lake internals

Medallion Architecture

PySpark

T-SQL

Tools

Azure DevOps

GitHub

Databricks Asset Bundles

Databricks Unity Catalog

Databricks Workflows

Delta Live Tables (DLT)

Fabric Data Factory

OneLake (Microsoft Fabric)

Job description

We're currently seeking a Data Warehouse Architect who will be responsible for establishing, optimising, and governing a unified enterprise data platform that enables data-driven decision-making. Acting as a bridge between complex raw data and meaningful business insight, the role involves designing scalable, high-performance Lakehouse and data warehouse architectures. By centralising data assets, implementing robust security frameworks, and removing data silos, the architect ensures the organisation has a single, reliable source of truth to support advanced analytics and AI initiative.

Job requirements

• Expertise in Microsoft Fabric (OneLake) and Databricks (Unity Catalog) architecture
• Experience building scalable lakehouse and warehouse solutions (Databricks SQL, Fabric SQL)
• Strong data pipeline development using Databricks Workflows, DLT, and Fabric Data Factory
• Knowledge of Delta Lake and cross-platform data strategies to reduce duplication
• Data governance expertise, including Unity Catalog, RLS, and data lineage
• Experience managing compute across Fabric and Databricks environments
• CI/CD knowledge using Azure DevOps, GitHub, and Databricks Asset Bundles
• Proficiency in PySpark, Databricks SQL, T‑SQL, and Delta Lake internals
• Strong understanding of Medallion Architecture and modern data modelling (Star Schema, Data Vault 2.0)
• Experience optimising Databricks performance and integrating with Power BI (Direct Lake)

Job responsibilities

• Design global architectural blueprints combining Microsoft Fabric OneLake and Databricks Unity Catalog.
• Build optimised Lakehouse and warehouse structures using Databricks SQL and Fabric SQL endpoints.
• Establish data pipelines using Databricks Workflows, Delta Live Tables (DLT), and Fabric Data Factory.
• Formulate cross-platform data strategies utilising shared Delta Lake formats to eliminate data duplication.
• Implement unified data governance, access controls, and Row‑Level Security (RLS) via Unity Catalog.
• Direct multi‑engine computation strategies using Fabric capacities alongside Databricks clusters.
• Define CI/CD deployment frameworks across both platforms using Azure DevOps, GitHub, and Databricks Asset Bundles.
• Salary aligned with your skills and expertise
• 27 days holiday allowance plus statutory public holidays and the option to purchase more
• Birthday leave
• 2 giving back days per year. We encourage our team to support the wider community by providing paid leave to work with local charities or good causes
• A hard working, fun and professional working environment
• Enhanced family friendly policies, including enhanced Maternity pay