Data Architect - Azure Data Factory - SC Cleared

Data Architect - Azure Data Factory – SC Cleared - Part Time - Remote - Inside IR35 Lead the migration of data capabilities from a legacy stack onto a newly delivered Azure Data Factory platform for a major UK public sector programme. You’ll set the target data architecture, govern the migration, and work closely with stakeholders and engineers to deliver a secure, performant and cost-effective solution.This is a part-time role, offering 3 days per week. Due to the nature of the role, we require candidates with an active SC Clearance. Responsibilities

• Own the target data architecture (ingest transform serve) and standards/guardrails.
• Plan and govern migration from Oracle/PL-SQL to Azure (e.g. Azure SQL/T-SQL), including cutover and risk.
• Define conceptual/logical/physical data models and interfaces.
• Oversee ETL/ELT in Azure Data Factory, ensuring reliability, observability and cost optimisation.
• Guide PL/SQL T-SQL conversion, recommending tooling (e.g. SSMA).
• Champion DevOps practices (Git/GitHub, CI/CD) and produce clear design/runbook docs.
• Engage senior technical and non-technical stakeholders effectively.

Skills & experience: Essential

• Advanced SQL; strong Oracle PL/SQL and T-SQL (migration/conversion experience).
• Proven Azure Data Factory design/governance at scale.
• Data modelling & RDBMS fundamentals.
• Excellent stakeholder management and communication.

Desirable

• Data engineering on Azure; monitoring and cost control.
• SSMA, Git/GitHub, VS Code, GitHub Copilot / basic LLM prompting (foundational knowledge fine).
• Data architecture & network basics in Azure (VNets/private endpoints).
• Power BI / SAP BusinessObjects exposure.