SQL Data Architect - Microsoft Stack

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!