Data Warehouse Architect

TXP
City of London
22 hours ago
Create job alert

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

Related Jobs

View all jobs

Hybrid Data Warehouse Architect

Senior Data Warehouse Architect & ETL Lead

Senior Data Warehouse Architect & ETL Lead

Senior Data Warehouse Architect & ETL Lead

Data Architect

Data Architect

Subscribe to Future Tech Insights for the latest jobs & insights, direct to your inbox.

By subscribing, you agree to our privacy policy and terms of service.

Industry Insights

Discover insightful articles, industry insights, expert tips, and curated resources.

What Hiring Managers Look for First in Data Science Job Applications (UK Guide)

If you’re applying for data science roles in the UK, it’s crucial to understand what hiring managers focus on before they dive into your full CV. In competitive markets, recruiters and hiring managers often make their first decisions in the first 10–20 seconds of scanning an application — and in data science, there are specific signals they look for first. Data science isn’t just about coding or statistics — it’s about producing insights, shipping models, collaborating with teams, and solving real business problems. This guide helps you understand exactly what hiring managers look for first in data science applications — and how to structure your CV, portfolio and cover letter so you leap to the top of the shortlist.

The Skills Gap in Data Science Jobs: What Universities Aren’t Teaching

Data science has become one of the most visible and sought-after careers in the UK technology market. From financial services and retail to healthcare, media, government and sport, organisations increasingly rely on data scientists to extract insight, guide decisions and build predictive models. Universities have responded quickly. Degrees in data science, analytics and artificial intelligence have expanded rapidly, and many computer science courses now include data-focused pathways. And yet, despite the volume of graduates entering the market, employers across the UK consistently report the same problem: Many data science candidates are not job-ready. Vacancies remain open. Hiring processes drag on. Candidates with impressive academic backgrounds fail interviews or struggle once hired. The issue is not intelligence or effort. It is a persistent skills gap between university education and real-world data science roles. This article explores that gap in depth: what universities teach well, what they often miss, why the gap exists, what employers actually want, and how jobseekers can bridge the divide to build successful careers in data science.

Data Science Jobs for Career Switchers in Their 30s, 40s & 50s (UK Reality Check)

Thinking about switching into data science in your 30s, 40s or 50s? You’re far from alone. Across the UK, businesses are investing in data science talent to turn data into insight, support better decisions and unlock competitive advantage. But with all the hype about machine learning, Python, AI and data unicorns, it can be hard to separate real opportunities from noise. This article gives you a practical, UK-focused reality check on data science careers for mid-life career switchers — what roles really exist, what skills employers really hire for, how long retraining typically takes, what UK recruiters actually look for and how to craft a compelling career pivot story. Whether you come from finance, marketing, operations, research, project management or another field entirely, there are meaningful pathways into data science — and age itself is not the barrier many people fear.