Data Architect

Mayfair IT Consultancy; Greater London; On-site; GBP 90,000 - 130,000; Full time

Job summary

Mayfair IT Consultancy Ltd. is seeking an experienced Data Architect (SFIA Level 5/6) to define data architecture strategy, governance, standards, and solutions across complex public sector environments in the UK.

The role requires designing enterprise-wide data solutions, establishing data governance and security frameworks, and leading architecture governance with senior stakeholders. BPSS clearance is desirable but not mandatory.

Qualifications

• Experience designing enterprise data architectures.
• Proficient in data governance, quality, and security.
• Strong knowledge of data modelling (conceptual to physical).
• Hands-on with cloud data platforms (Azure).
• Ability to lead architecture governance and stakeholder alignment.

Responsibilities

• Design enterprise-wide data architecture solutions.
• Define data models, standards, and roadmaps.
• Establish governance, quality, and security frameworks.
• Support cloud-based data platforms and modernization.
• Collaborate with technical, business, and delivery teams.
• Ensure compliance with data management practices and regulations.
• Provide architectural leadership across programmes.
• Produce architecture documentation and designs.

Skills

Data Architecture

Enterprise Data Modelling

Data Governance

Data Quality Management

Master Data Management

Metadata Management

Data Integration

Data Warehousing

Architecture Frameworks

Cloud Data Platforms

SQL

API Design

Data Security

Architecture Documentation

Stakeholder Management

Agile Delivery

Education

Tools

Microsoft Azure

Azure Data Factory

Azure Synapse Analytics

Azure Data Lake

Databricks

SQL Server

Power BI

Purview

DevOps / CI-CD

Job description

Overview

We are seeking experienced Data Architects (SFIA Level 5 and Level 6) to support large-scale public sector digital transformation programmes. The successful candidate will be responsible for defining data architecture strategy, governance, standards, and solutions across complex enterprise environments.

Key Responsibilities

• Design and deliver enterprise-wide data architecture solutions.
• Define data models, standards, and architectural roadmaps.
• Establish data governance, quality, and security frameworks.
• Support cloud-based data platforms and modernisation initiatives.
• Collaborate with technical, business, and delivery teams.
• Ensure compliance with data management best practices and regulatory requirements.
• Provide architectural leadership and guidance across programmes.
• Produce architecture documentation and technical designs.

Essential Skills & Experience

• Data Architecture
• Enterprise Data Modelling (Conceptual, Logical, Physical)
• Data Governance
• Data Quality Management
• Master Data Management (MDM)
• Metadata Management
• Data Integration & ETL
• Data Warehousing
• Data Architecture Frameworks
• Cloud Data Platforms (Azure preferred)
• SQL
• API & Data Integration Design
• Data Security & Risk Management
• Architecture Documentation
• Stakeholder Management
• Agile Delivery Environments

Technical Skills

Preferred Technologies

• Microsoft Azure
• Azure Data Factory
• Azure Synapse Analytics
• Azure Data Lake
• Databricks
• SQL Server
• Power BI
• Purview
• DevOps / CI-CD

SFIA Level 5 Expectations

• Takes responsibility for defining and assuring data architecture.
• Influences project and programme decisions.
• Provides technical leadership within a workstream.
• Works autonomously with minimal supervision.

SFIA Level 6 Expectations

• Owns enterprise-level data architecture strategy.
• Influences organisational policy and standards.
• Leads architecture governance and decision-making.
• Provides expert guidance to senior stakeholders and delivery teams.

Desirable

• SC Clearance (current or previously held).
• Public sector programme experience.
• Experience supporting large, complex digital transformation initiatives.

Clearance Requirement

Candidates must be eligible and willing to undergo Baseline Personnel Security Standard (BPSS) clearance prior to onboarding. Current or previous SC clearance is welcomed but not required.