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

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.

• 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, One Lake, 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 Dev Ops (Git / Azure Dev Ops), 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.

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 :
  Power Shell, 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!