Jobs, fresher vacancy - Data Warehouse Engineer - Outside IR35 - Hybrid • UK

Company: Tenth Revolution Group

UK

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.