Data Warehouse Architect

Role: Data Warehouse Architect

Contract: 6 week initial engagement

Location: Hybrid working - likely to be some travel to London required

Rate: £700pd-£750pd (outside IR35)

We are currently recruiting for a Data Warehouse Architect who can come in and provide a DWH assessment, you will be responsibile for assessing the DWH landscape and provide driection, deliverables and outcomes. This is due to be a 6-week engagement with the chance of it becoming a longer term piece of work.

Core Responsibilities

Own logical and physical data warehouse architecture from ingestion to consumption
Define target state architecture and roadmaps for enterprise data platforms
Design modern data warehouse patterns using medallion architecture. Bronze silver gold
Define canonical data models conformed dimensions and domain boundaries
Set Master Data Management strategy including golden records matching and governance
Define integration patterns for batch streaming and API based data movement
Establish non functional requirements covering performance security scalability and cost

Microsoft Fabric and Platform Architecture

Architect solutions on Microsoft Fabric at platform and solution level
Define appropriate use of Lakehouse Warehouse OneLake and semantic models
Set standards for data pipelines notebooks and orchestration patterns
Define medallion layer responsibilities and data contracts between layers
Govern Power BI semantic models Direct Lake usage and enterprise BI patterns
Define security architecture using Entra ID RLS FLS and workspace separation

MDM and Data Governance

Define enterprise MDM architecture and operating model
Set standards for data domains ownership stewardship and controls
Define data quality frameworks reference data management and issue management
Ensure MDM integration into analytical and operational use cases

Business Intelligence and Analytics Enablement

Define enterprise BI and semantic layer architecture
Set standards for KPI metric definition and reuse across the organisation
Enable advanced analytics and data science consumption from curated layers
Ensure consistency usability and performance of analytical models

Key Data Warehouse Building Blocks

Source system classification and data contracts
Ingestion and landing architecture
Standardisation validation and data quality layers
Master and reference data integration
Analytical and dimensional modelling approaches
Semantic layer and BI consumption patterns
Metadata lineage observability and monitoring

Architecture Leadership

Act as architectural authority and design reviewer
Produce architecture artefacts principles and standards
Translate business strategy into scalable data architectures
Work with engineers product owners and business leaders to govern delivery

The role will require travel to London and will be hybrid working, please consider this when applying for the role.

Due to the time-frames required for the engagement, you must be available to start a new role as soon as required.

If you are interested in the role and would like to apply, please click on the link to be considered