Senior Data Migration Engineer (Microsoft BI Stack)

You will play a key role in delivering robust, well-governed migration solutions within a regulated environment. What you'll be doing

• Lead end-to-end data migration activities from discovery and analysis through to build, validation, and deployment.
• Design and develop scalable ETL/ELT pipelines across on-premise and Azure-based platforms.
• Perform detailed source-to-target data mapping, defining transformation rules, derivations, and reconciliation logic.
• Analyse complex Legacy datasets where documentation may be limited.
• Conduct comprehensive data profiling and support data quality remediation.
• Translate business and regulatory requirements into clear, structured technical specifications.
• Develop, optimise, and troubleshoot advanced SQL solutions.
• Contribute to data warehouse and analytics platform design and enhancement.
• Support CI/CD implementation and automated testing practices within an Agile delivery environment.
• Produce and maintain high-quality technical and mapping documentation.

• Extensive experience delivering large-scale data migration programmes, ideally within financial services or other regulated environments.
• Deep expertise across the Microsoft BI stack (SSIS, SSRS, SSAS, T-SQL) and modern Azure data services.
• Strong Azure engineering capability including Azure Data Factory, Synapse, Databricks, Data Lake, Fabric and Power BI.
• Advanced SQL skills (T-SQL and/or PL/SQL).
• Strong understanding of ETL/ELT, data warehousing, dimensional modelling and BI principles.
• Experience working within Agile environments with exposure to DevOps and automated deployment practices.
• Excellent stakeholder communication skills and the ability to work autonomously.

Nice to have:

• Experience integrating with or migrating data to Salesforce.
• Exposure to or experience in data architecture and solution design, including data modelling and platform design decisions.

InterQuest Group is acting as an employment agency for this vacancy. InterQuest Group is an equal opportunities employer and we welcome applications from all suitably qualified persons regardless of age, disability, gender, religion/belief, race, marriage, civil partnership, pregnancy, maternity, sex or sexual orientation. Please make us aware if you require any reasonable adjustments throughout the recruitment process.