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