Data Warehouse Architect

Leonard Curtis Recovery Limited; Manchester; Hybrid; GBP 65,000 - 90,000; Full time

Benefits offered by this job

27 days holiday plus public holidays

Birthday leave

Car allowance

Well-being schemes

Enhanced family friendly policies

Job summary

Leonard Curtis Recovery Limited is seeking a Data Warehouse Architect to establish and optimise their enterprise data platform. The successful candidate will bridge raw data and business insights by designing high-performance Lakehouse and data warehouse architectures.

Key responsibilities include architecting global blueprints with Microsoft Fabric and Databricks, establishing data governance, and building data pipelines. This role offers a hybrid working model and various benefits like enhanced leave and a car allowance.

Qualifications

• Expertise in Microsoft Fabric and Databricks architecture.
• Experience managing compute across Fabric and Databricks environments.
• Strong understanding of modern data modelling.

Responsibilities

• Design global architectural blueprints combining Microsoft Fabric OneLake and Databricks Unity Catalog.
• Establish data pipelines using Databricks Workflows and Delta Live Tables.
• Implement unified data governance and access controls.

Skills

Microsoft Fabric (OneLake)

Databricks (Unity Catalog)

Databricks SQL

PySpark

Data governance

CI/CD with Azure DevOps

Tools

Azure DevOps

GitHub

Power BI

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.

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.

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

Benefits

• Salary aligned with your skills and expertise.
• 27 days holiday allowance plus statutory public holidays and the option to purchase more.
• Birthday leave.
• Hybrid working.
• Car allowance.
• Flexible benefit and well‑being schemes.
• 2 giving back days per year – paid leave to work with local charities or good causes.
• Enhanced family friendly policies, including enhanced Maternity pay.
• A hard working, fun and professional working environment.

We are an equal opportunities employer which promotes inclusiveness and always employs the best professional for the job. We value a diverse workforce and provide an environment where everyone has an equal opportunity for success.