Data Warehouse Architect

Jefferson Frank; Manchester; On-site; GBP 48,000 - 80,000; Full time

Benefits offered by this job

Hybrid working model

Executive exposure

Professional development

Job summary

Jefferson Frank is seeking an experienced Data Warehouse Architect to lead the design and governance of a modern enterprise data platform. The role offers hybrid working with strong senior stakeholder exposure and significant impact on strategic data initiatives.

You'll own data warehouse and Lakehouse architectures, shaping reporting, analytics, AI, and future innovations using Microsoft Fabric OneLake, Databricks, and related technologies.

Qualifications

• Enterprise data warehouse architecture and design.
• Databricks, Unity Catalog and Delta Lake.
• PySpark, Databricks, SQL.
• Medallion Architecture implementation.
• Data modelling approaches including Star Schema and Data Vault.
• Data governance, security and access management.

Responsibilities

• Design enterprise-scale data warehouse and Lakehouse architectures.
• Develop data platform strategies using Microsoft Fabric OneLake and Databricks.
• Build scalable data models and storage frameworks.
• Establish governance, security, lineage and access control frameworks.
• Create modern data integration and transformation pipelines.
• Define CI/CD and deployment standards for data products.
• Drive best practices across architecture, performance and scalability.
• Collaborate with senior stakeholders to translate objectives into technical solutions.

Job description

Data Warehouse Architect

Location: Hybrid (UK)

Salary: £80,000

We're partnering with a highly successful, private equity-backed organisation that is embarking on a major data transformation journey.

The business has recognised data as a strategic asset and has recently invested in leadership and technology to create a modern, enterprise-wide data capability. As part of this greenfield transformation, they're looking for an experienced Data Architect to take ownership of the organisation's data platform strategy and design.

This is a role offering autonomy, visibility with senior stakeholders and the chance to make a lasting impact across the entire business.

As the Data Architect, you will be responsible for designing and governing the enterprise data platform, creating a scalable and secure foundation for reporting, analytics, AI, and future innovation.

Working closely with executive stakeholders and technology leadership, you'll define the architectural vision while driving the implementation of a modern Lakehouse and Data Warehouse environment built on Microsoft and Databricks technologies.

Responsibilities

• Designing enterprise-scale data warehouse and Lakehouse architectures
• Developing data platform strategies using Microsoft Fabric OneLake and Databricks
• Building scalable data models and storage frameworks
• Establishing robust governance, security, lineage and access control frameworks
• Creating modern data integration and transformation pipelines
• Defining CI/CD and deployment standards for data products
• Driving the adoption of best practices across architecture, performance and scalability
• Collaborating with senior business stakeholders to translate strategic objectives into technical solutions

Requirements

• Enterprise data warehouse architecture and design
• Microsoft Fabric, Azure Data Platform technologies and modern Lakehouse architectures
• Databricks, Unity Catalog and Delta Lake
• PySpark, Databricks, SQL
• Medallion Architecture implementation
• Data modelling approaches including Star Schema and Data Vault
• Data governance, security and access management

Why This Opportunity

• Greenfield data transformation programme
• Full ownership of enterprise data architecture
• Significant investment in modern Microsoft technologies
• Opportunity to shape the organisation's move into Microsoft Fabric
• Strong board-level sponsorship and commitment to data-driven decision making
• Direct influence on strategic business outcomes
• People-first culture with a genuine commitment to employee development
• Funded Microsoft certifications and professional accreditations
• Long-term career growth within a forward-thinking organisation

What's on Offer?

• Competitive salary and benefits package
• Hybrid working model
• High-profile role with executive-level exposure
• Significant autonomy and ownership
• Investment in training, certifications and professional development
• Opportunity to influence technology decisions and strategy
• Collaborative, people-focused culture that genuinely invests in its employees