Azure Data Architect/ADF

Sentinel; Greater London; Hybrid; GBP 70,000 - 90,000; Full time

Job summary

A prominent technology company in the UK is looking for an experienced Azure Data Architect with a strong background in SQL Server. This role involves designing and delivering data solutions, utilizing Microsoft technologies such as Azure Data Factory and Databricks. The position is predominantly remote, requiring occasional trips to London and Birmingham. Ideal candidates will have significant expertise in data architecture, performance optimization, and relevant certifications in Azure data engineering. Competitive compensation is offered.

Qualifications

• Extensive experience as a SQL Server DBA/Architect designing and delivering Data Solutions.
• Strong understanding of data design principles and architecture patterns.
• Experience with event-driven architectures and change data capture.

Responsibilities

• Design and deliver Data Solutions using SQL Server and Azure technologies.
• Optimize database performance and manage high availability and disaster recovery.
• Develop and maintain ETL processes using SSIS and Azure Data Factory.

Skills

SQL Server 2016

SQL Server 2022

T-SQL development

SSIS

Azure Data Factory

Azure Data Lake Storage

Databricks

PowerShell

Python

Education

Microsoft Certified: Azure Data Engineer Associate (DP-203)

Microsoft Certified: Fabric Analytics Engineer Associate (DP-600)

Job description

Azure Data Architect/DBA/SQL Server 2016/2022/YSQL/ADF/ADL/Fabric.

Superb London based client with a site in Birmingham have an urgent need for an experienced Azure/SQL Server Data Architect. 12 months, Inside IR35, Remote, with some trips to London and Birmingham. If you have a wealth of experience as a SQL Server DBA/Architect designing and delivering Data Solutions please get in touch.

Microsoft data stack.

• Expert in: SQL Server 2016 & 2022 (engine internals, performance, HA/DR); T‑SQL development, stored procedures, triggers, and query optimization; SSIS (package design, orchestration, deployment); Azure Data Factory (pipelines, triggers, integration runtimes); Azure Data Lake Storage (Gen2, security, folder structures); Microsoft Fabric (Lakehouse, OneLake, Data Engineering); Databricks (Spark SQL, notebooks, Delta Lake, integration with ADF/Fabric)
• Strong data design principles: normalization, dimensional modelling, and data architecture patterns.

NICE TO HAVE

• Azure Synapse Analytics, Power BI semantic models.
• Data governance tools (Microsoft Purview), RBAC/ABAC, and Key Vault integrations.
• Scripting: PowerShell, Python for automation.
• Experience with event‑driven architectures and CDC.

CERTIFICATIONS (Preferred)

• Microsoft Certified: Azure Data Engineer Associate (DP-203)
• Microsoft Certified: Fabric Analytics Engineer Associate (DP-600)