Data Warehouse Architect

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.

• Design global architectural blueprints combining Microsoft Fabric One Lake 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 Dev Ops, Git Hub, and Databricks Asset Bundles.

• Expertise in Microsoft Fabric (One Lake) 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 Dev Ops, Git Hub, 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).

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