SQL Data Architect - Microsoft Stack

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

Job summary

A leading consultancy firm based in the Greater London area seeks a skilled SQL Data Architect for a twelve-month contract. This remote role involves working with Microsoft data technologies, including SQL Server, Azure Data Factory, and DevOps practices. The ideal candidate will have extensive experience in data engineering and possess strong communication skills to influence stakeholders. Ideal certifications include Azure Data Engineer Associate and Fabric Analytics Engineer Associate.

Qualifications

• Extensive experience in data engineering/DBA/architecture focusing on Microsoft data stack.
• Proven track record of autonomous delivery from discovery to production support.
• Strong data design principles with normalization and dimensional modeling experience.

Responsibilities

• Delivering end-to-end solutions with minimal supervision.
• Driving simplicity, scalability, and quality in architecture.

Skills

Data engineering

SQL Server 2016 & 2022

T-SQL development

SSIS

Azure Data Factory

Data architecture patterns

DevOps tools (Git/Azure DevOps)

Scripting (PowerShell, Python)

Education

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

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

Job description

Job Title: SQL Data Architect - Azure Stack

Location: Remote with occasional travel to Birmingham

Salary/Rate: Up to £550 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

• 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

• 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)

If you are interested in this opportunity, please apply now with your updated CV in Microsoft Word/PDF format.

Disclaimer

Notwithstanding any guidelines given to level of experience sought, we will consider candidates from outside this range if they can demonstrate the necessary competencies.
Square One is acting as both an employment agency and an employment business, and is an equal opportunities recruitment business. Square One embraces diversity and will treat everyone equally. Please see our website for our full diversity statement.