Data Warehouse Architect

Nigel Frank; Greater Manchester; On-site; GBP 68,000 - 92,000; Full time

Benefits offered by this job

Hybrid and flexible working

Budget for certifications

Career progression

Autonomy on technology decisions

Investment-backed growth environment

Job summary

Nigel Frank in Greater Manchester is seeking a Data Warehouse Architect to lead a greenfield data platform in a hybrid environment. You will shape modern Data Warehouse and Lakehouse architectures using Microsoft Fabric and Medallion patterns, with autonomy on technology decisions.

You will collaborate with senior stakeholders and Microsoft partners to deliver scalable data pipelines, governance and enterprise analytics, paving the way for AI-enabled insights.

Qualifications

• Experience designing and delivering modern Data Warehouse, Lakehouse or Enterprise Data Platform solutions.
• Strong knowledge of Microsoft Azure and Microsoft Fabric.
• Commercial experience with Databricks would be highly beneficial.
• Expert understanding of Medallion Architecture principles.
• Experience designing API and batch data integrations at scale.
• Strong data modelling knowledge including Star Schema and Data Vault.
• Experience implementing data governance, security and access control frameworks.
• Knowledge of Delta Lake, PySpark, Databricks SQL or T-SQL.
• Ability to engage with both technical teams and senior business stakeholders.
• Previous architecture experience preferred, though strong Senior Data Engineers stepping into architecture will be considered.

Responsibilities

• Design and implement a modern Data Warehouse and Lakehouse architecture.
• Build scalable data platforms using Microsoft Fabric.
• Create and govern Medallion Architecture frameworks across the organisation.
• Develop data ingestion solutions through API and batch integrations.
• Design robust data pipelines using Fabric Data Factory, Databricks Workflows and Delta technologies.
• Define data modelling standards including Star Schema and Data Vault.
• Establish data governance, security, lineage and access control frameworks.
• Collaborate with senior stakeholders across finance, operations, marketing and technology.
• Work with Microsoft partners to deliver a best-in-class data capability.
• Support future ambitions around advanced analytics, reporting and AI.

Skills

Data Warehouse architecture

Medallion Architecture

Azure & Fabric

Databricks

Data modelling

API & batch data integrations

Governance & security

Stakeholder engagement

Architectural leadership

Greenfield data platform

Tools

Microsoft Azure

Microsoft Fabric

Databricks

Delta Lake

PySpark

Databricks SQL

T-SQL

Job description

Data Warehouse Architect - Greater Manchester (Hybrid) - Microsoft Fabric - Medallion Architecture - Up to £80,000

This is a rare opportunity to join a business at the very start of its data transformation journey.

Backed by significant investment and led by a senior leadership team that genuinely understands the value of data, the organisation is making a major commitment to building a modern, enterprise-grade data platform from the ground up. Rather than inheriting legacy systems and technical debt, you'll have the opportunity to design and shape the future-state architecture from day one.

Working closely with a newly established data leadership team and leading Microsoft partners, you'll play a central role in creating a scalable, secure and high-performing data platform that will become the single source of truth for the organisation. This is a genuine greenfield environment with the autonomy, backing and budget needed to make a lasting impact.

The business is known for its people-first culture, long-term investment in employee development and commitment to professional growth through training, certifications, and accreditations.

You Will Work With

• Designing and implementing a modern enterprise Data Warehouse and Lakehouse architecture
• Building scalable data platforms using Microsoft Fabric
• Creating and governing Medallion Architecture frameworks across the organisation
• Developing data ingestion solutions through API and batch integrations
• Designing robust data pipelines using Fabric Data Factory, Databricks Workflows and Delta technologies
• Defining data modelling standards including Star Schema and Data Vault approaches
• Establishing data governance, security, lineage and access control frameworks
• Collaborating with senior stakeholders across finance, operations, marketing and technology
• Working alongside Microsoft partners to deliver a best-in-class data capability
• Supporting the organisation's future ambitions around advanced analytics, reporting and AI

Benefits

• Hybrid and flexible working environment
• Opportunity to architect a platform from a blank slate
• Significant autonomy and influence on technology decisions
• Investment-backed business with ambitious growth plans
• Dedicated budget for Microsoft certifications and professional accreditations
• Excellent opportunities for career progression within a growing data function
• Supportive leadership team that actively invests in its people
• Work with the latest Microsoft Fabric and Azure technologies

Key Experience

• Experience designing and delivering modern Data Warehouse, Lakehouse or Enterprise Data Platform solutions
• Strong knowledge of Microsoft Azure and Microsoft Fabric
• Commercial experience with Databricks would be highly beneficial
• Expert understanding of Medallion Architecture principles
• Experience designing API and batch data integrations at scale
• Strong data modelling knowledge including Star Schema and/or Data Vault methodologies
• Experience implementing data governance, security and access control frameworks
• Knowledge of Delta Lake, PySpark, Databricks SQL or T-SQL
• Ability to engage with both technical teams and senior business stakeholders
• Previous architecture experience preferred, though strong Senior Data Engineers looking to step into an architecture-focused role will also be considered

Ready to Build Something from Scratch?

Opportunities to lead the architecture of a greenfield Microsoft Fabric platform are rare.