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.