Data Warehouse Engineer - Outside IR35 - Hybrid
other jobs Tenth Revolution Group
Added before 7 Days
- England,London,City of London
- Full Time, Contract
- £400 - £450 per day
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.
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.
Job number 3530147
Increase your exposure to recruiters with ProJobs
Thousands of recruiters are looking for you in the Job Master profile database, increase your exposure 4 times with a ProJob subscription
You can cancel your subscription at any time.