Data Warehouse Engineer - Outside Ir35 - Hybrid

Tenth Revolution Group
London
1 day ago
Create job alert

Job Description

Data Warehouse Engineer - Outside IR35 - Hybrid - Financial services Role Overview

We are looking for an experienced Senior Data Warehouse Engineer to lead the design and delivery of an end-to-end data warehouse on Azure for a wealth management firm undergoing a major digital and data transformation.

You will take ownership of the data platform architecture, ingestion pipelines, dimensional models, and API layer, delivering a scalable Bronze/Silver/Gold medallion architecture and establishing best practices for data engineering and DevOps.

Must Have

Azure Stack

  • Azure Blob Storage / ADLS
  • Azure SQL Database
  • Azure Data Factory (ADF)
  • Azure Synapse Analytics
  • Azure Functions

Data Warehouse Delivery

  • Delivered end-to-end DWH as a lead engineer (source integration ? dimensional models ? API layer)
  • Designed and implemented Bronze/Silver/Gold medallion architecture
  • Made architectural decisions and produced Architecture Decision Records (ADRs)

Data Engineering & Modelling

  • Dimensional modelling (Kimball), star schemas
  • SCD Type 2
  • MDM concepts (entity resolution, golden records)
  • Batch & incremental ETL/ELT pipelines
  • File-based ingestion (CSV/XLS) with error handling
  • SQL Server replication (snapshot/delta strategies)

Performance & Access

  • Partitioning strategies (date/size-based)
  • REST APIs for real-time data queries and response optimisation

Quality & Security

  • Source-to-target validation and exception reporting
  • Azure RBAC, Managed Identities, Key Vault
  • Row-level security, PII handling, audit trails

DevOps

  • Git workflows
  • Infrastructure as Code (Terraform / ARM)
  • CI/CD pipelines

To apply for this role please submit your CV or contact Dillon Blackburn on or at .

Tenth Revolution Group are the go-to recruiter for Data & AI roles in the UK offering more opportunities across the country than any other recruitment agency. We're the proud sponsor and supporter of SQLBits, Power Platform World Tour, and the London Fabric User Group. We are the global leaders in Data & AI recruitment.

Related Jobs

View all jobs

Data Warehouse Engineer

Data Warehouse Engineer | €40k | Azure

Data Warehouse Engineer - 6 Month FTC

Data Warehouse Engineer

Data Warehouse Engineer - Outside IR35 - Hybrid

Data Warehouse Engineer - 6 Month FTC

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.