Data Warehouse Architect

Leonard Curtis Ltd

Manchester

On-site

GBP 90,000 - 120,000

Full time

4 days ago
Be an early applicant

A complete application in a minute

Tailored resume and cover letter, ready to send.

Get past ATS filters

Benefits offered by this job

27 days holiday
Birthday leave
Giving back days
Great team environment
Family friendly policies

Job summary

Leonard Curtis Ltd. is seeking a Data Warehouse Architect to design and govern a unified enterprise data platform that enables data‑driven decision making.

The role bridges raw data to business insights, building scalable Lakehouse and data warehouse architectures and removing data silos for a single source of truth. The candidate will implement robust security, drive data governance, and optimise performance across Fabric and Databricks ecosystems, including Power BI Direct Lake integration, to

Qualifications

  • Expertise in Microsoft Fabric OneLake and Databricks Unity Catalog architecture
  • Experience building scalable lakehouse and warehouse solutions with Databricks SQL and 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
  • 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

Skills

Cloud data architecture
Data governance
PySpark
Delta Lake

Tools

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

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

Leonard Curtis is a market leading professional services provider operating across the UK and offshore. Since our formation we’ve supported business owners and advisors by listening and offering practical solutions and tailored advice. Our expert team of specialists deliver positive strategic advice across restructuring and insolvency, funding, legal, business services and M&A advisory across 30 offices. A career with Leonard Curtis will open the door to varied career pathways.

We have built an environment that empowers you to express yourself to have confidence in who you are and what you’re capable of and develop the career you want.

Learning and Development
Leonard Curtis has a wealth of resources available to help you develop your career from the moment you join. Activities range from on-line learning modules to external training and qualifications.

Diversity and Inclusion
Diversity is a core business imperative of the Group. We are an equal opportunities employer which promotes inclusiveness and always employ the best professional for the job. Having a diverse workforce allows the Group to draw upon a range of different ideas and experiences which supports our business’s growth and creates an environment where everyone has an equal opportunity for success.

Express
yourself

Be yourself every day, in everything you do. Have confidence in what you’re capable of and what you bring to the team.

Be the
difference

Care about the work you do and the people we do it for. Treat people with compassion and strive to get the best outcomes.

Inspire
each other

Bring positivity to your work and your working relationships. Collaborate with an open mind and a commitment to achieve great things together.

LCBSG Limited Registered in England No. 09209265. Registered office: Leonard Curtis House, Elms Square, Bury New Road, Whitefield, M45 7TA
Leonard Curtis is a trading style of Reach Commercial Finance Limited, registered at Leonard Curtis House, Elms Square, Bury New Road, Whitefield, M45 7TA. Company Register number is 09056450. Reach Commercial Finance Limited is authorised and regulated by the Financial Conduct Authority, FRN: 753686. Reach Commercial Finance Limited is an authorised credit broker and not a lender. We work with an unrestricted number of lenders to find a potentially suitable arrangement for your consideration. ICO registration ZA069234 and you can check via www.ico.org.uk. We will receive commission from lenders. Different lenders pay different amounts depending on different commission models. For transparency we work with the following commission models: fixed fee, fixed rate of commission, percentage of the amount you borrow and rate for risk (this is based on the risk profile of the business). Further details of the commission model, calculation and amount will be disclosed to you throughout your customer journey. Privacy notice .

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Data Engineer
Data Engineer

Leonard Curtis Ltd • United Kingdom

Hybrid
GBP 60,000 - 90,000
27 days holiday
Birthday leave
Giving back days
+2
Assistant Manager - Insolvency
Assistant Manager - Insolvency

Leonard Curtis Ltd • Birmingham

On-site
GBP 40,000 - 56,000
25 days holiday
Birthday leave
Giving back days
+1
Receptionist
Receptionist

Leonard Curtis Ltd • Salford

On-site
GBP 21,000 - 28,000
25 days holiday
Public holidays
LTIP
+4
Business Advisory Manager - National
Business Advisory Manager - National

Leonard Curtis Ltd • South Kiscadale

Remote
GBP 60,000 - 90,000
Birthday leave
25 days holiday
2 giving back days per year
+2
Lifecycle Business Development Manager - South Coast
Lifecycle Business Development Manager - South Coast

Leonard Curtis Ltd • South Kiscadale

On-site
GBP 70,000 - 95,000
27 days holiday
Birthday leave
Giving back days
+2
L&D Manager
L&D Manager

Leonard Curtis Ltd • United Kingdom

Hybrid
GBP 42,000 - 64,000
27 days holiday
Birthday leave
Giving back days
+1
Restructuring and Insolvency Assistant Manager
Restructuring and Insolvency Assistant Manager

Leonard Curtis Ltd • Manchester

Hybrid
GBP 55,000 - 75,000
Birthday leave
Giving back days
Flexible benefit schemes
+2
Corporate Senior Associate/Associate Director
Corporate Senior Associate/Associate Director

Leonard Curtis Ltd • Manchester

Hybrid
GBP 75,000 - 110,000
27 days holiday
Private medical insurance
Birthday leave
+2
Junior Insolvency Administrator
Junior Insolvency Administrator

Leonard Curtis • Fareham

Hybrid
GBP 25,000 - 35,000
25 days holiday allowance
Birthday leave
2 giving back days
+1
Head of CRE Origination & Structuring
Head of CRE Origination & Structuring

LLOYDS BANK PLC • City Of London

Hybrid
GBP 150,000 - 210,000
Generous pension contribution
Annual performance bonus
Share schemes
+3