Data Warehouse Architect

Data Warehouse Architect

Full-Time 60000 - 80000 £ / year (est.) No working from home possible
Leonard Curtis Recovery Limited

At a Glance

  • Tasks: Design and optimise data architectures for impactful decision-making.
  • Company: Dynamic tech company focused on data-driven solutions.
  • Benefits: Competitive salary, 27 days holiday, hybrid work, and birthday leave.
  • Other info: Inclusive workplace with opportunities for personal and professional growth.
  • Why this job: Shape the future of data with innovative technologies and strategies.
  • Qualifications: Expertise in Microsoft Fabric and Databricks, strong data pipeline skills.

The predicted salary is between 60000 - 80000 £ per year.

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.

Data Warehouse Architect employer: Leonard Curtis Recovery Limited

Join a forward-thinking company that values innovation and inclusivity, offering a dynamic work culture where your expertise as a Data Warehouse Architect will directly influence data-driven decision-making. With competitive salaries, generous holiday allowances, hybrid working options, and unique benefits like birthday leave and giving back days, we foster an environment that prioritises employee well-being and professional growth. Our commitment to diversity ensures that every team member has the opportunity to thrive in a supportive and engaging workplace.

Leonard Curtis Recovery Limited

Contact Details:

Leonard Curtis Recovery Limited Recruitment Team

We think you need these skills to ace Data Warehouse Architect

Microsoft Fabric (OneLake)
Databricks (Unity Catalog)
Databricks SQL
Fabric SQL
Databricks Workflows
Delta Live Tables (DLT)
Fabric Data Factory