SQL Data Architect - Microsoft Stack
Posted 1 day ago by Square One Resources
£80 Per hour
Inside
Remote
Birmingham, England, United Kingdom
Summary: The SQL Data Architect role focuses on leveraging the Microsoft data stack to deliver data engineering solutions within a consultancy environment. The position requires extensive experience in SQL Server, Azure Data Factory, and data architecture principles. The role is remote with occasional travel to Birmingham and is classified as inside IR35. The contract duration is twelve months, starting on January 12, 2026.
Key Responsibilities:
- Design and implement data solutions using Microsoft data stack technologies.
- Develop and optimize T-SQL queries, stored procedures, and triggers.
- Create and manage SSIS packages and Azure Data Factory pipelines.
- Ensure data architecture adheres to strong design principles and best practices.
- Deliver end-to-end solutions with minimal supervision and clear communication with stakeholders.
- Utilize DevOps practices for CI/CD in data solutions.
Key Skills:
- Extensive experience in data engineering, DBA, and architecture.
- Expertise in SQL Server 2016 & 2022, T-SQL, SSIS, and Azure Data Factory.
- Strong understanding of data design principles and architecture patterns.
- Experience with DevOps tools like Git and Azure DevOps.
- Ability to communicate effectively and influence stakeholders.
- Desirable skills include Azure Synapse Analytics and Power BI.
Salary (Rate): £80.00/hr
City: Birmingham
Country: United Kingdom
Working Arrangements: remote
IR35 Status: inside IR35
Seniority Level: undetermined
Industry: IT
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!