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.