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.