SQL Data Architect - Microsoft Stack

Square One Resources; Remote; GBP 80,000 - 100,000; Full time

Job summary

A leading consultancy firm is seeking a skilled SQL Data Architect for a remote role with occasional travel to Birmingham. The successful candidate will focus on Microsoft data stack technologies and drive end-to-end solutions independently. This is a 12-month contract with a competitive rate of up to £600 per day inside IR35, requiring extensive experience in data engineering, advanced SQL skills, and a design-first mindset.

Responsibilities

• Design end-to-end data solutions with minimal supervision.
• Deliver autonomous data engineering and architecture solutions.
• Influence stakeholders through clear communication.

Skills

SQL Server 2016 & 2022

T-SQL development

Azure Data Factory

Data design principles

DevOps (Git / Azure DevOps)

Autonomous delivery

Clear communication

Tools

PowerShell

Python

Job description

Job Title : SQL Data Architect - Azure Stack

Location : Remote with occasional travel to Birmingham

Salary / Rate : Up to £600 per day inside IR35

Start Date : 12 / 01 / 2026

Job Type : Contract - 12 months

Company Introduction

We have an exciting opportunity now available with one of our sector-leading consultancy clients! They are currently looking for a skilled SQL Data Architect to join their team for a twelve-month contract.

Required Skills / Experience

The ideal candidate will have the following :

• Extensive experience in data engineering / DBA / architecture with a focus on 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.
• Proven track record of autonomous delivery, from discovery to production support.
• Experience with DevOps (Git / Azure DevOps), CI / CD for data solutions.
• Autonomous & accountable : Delivers end-to-end solutions with minimal supervision.
• Design-first mindset : Drives simplicity, scalability, and quality in architecture.
• Clear communicator : Capable of influencing stakeholders and documenting decisions.

Desirable Skills / Experience

Although not essential, the following skills are desired by the client :

• 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.
• Microsoft Certified : Azure Data Engineer Associate (DP-203)
• Microsoft Certified : Fabric Analytics Engineer Associate (DP-600)

Sound like a match? Feel free to apply!