Data Warehouse Architect

TXP
City of London
3 weeks 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

Data Architect

BI & Data Warehouse Developer

Data Engineer

Data Warehouse Manager - Fabric Lakehouse

Data Architect

Senior 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.

How Many Data Science Tools Do You Need to Know to Get a Data Science Job?

If you’re trying to break into data science — or progress your career — it can feel like you are drowning in names: Python, R, TensorFlow, PyTorch, SQL, Spark, AWS, Scikit-learn, Jupyter, Tableau, Power BI…the list just keeps going. With every job advert listing a different combination of tools, many applicants fall into a trap: they try to learn everything. The result? Long tool lists that sound impressive — but little depth to back them up. Here’s the straight-talk version most hiring managers won’t explicitly tell you: 👉 You don’t need to know every data science tool to get hired. 👉 You need to know the right ones — deeply — and know how to use them to solve real problems. Tools matter, but only in service of outcomes. So how many data science tools do you actually need to know to get a job? For most job seekers, the answer is not “27” — it’s more like 8–12, thoughtfully chosen and well understood. This guide explains what employers really value, which tools are core, which are role-specific, and how to focus your toolbox so your CV and interviews shine.

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.