> Markdown version of [/jobs/ext/1245321-data-migration-lead-data-analyst](https://www.wearedevelopers.com/jobs/ext/1245321-data-migration-lead-data-analyst). Every page supports `.md` or `Accept: text/markdown`. Links point to the HTML versions so they work for humans too. Agent guide: [/agents.md](https://www.wearedevelopers.com/agents.md). --- # Data Migration Lead Data Analyst - **Company:** Sumitomo Mitsui Banking Corporation - **Location:** London, UK - **Experience:** Expert - **Contract:** Permanent contract - **Skills:** Artificial Intelligence, Amazon Web Services, Data Analysis, Business Intelligence Development, Databases, Information Engineering, Data Governance, Extract Transform Load (ETL), Data Mapping, Data Migration, Data Profiling, RAID, Microsoft SQL Server, MySQL, Operational Data Store, Oracle (Applications), Migration Manager, SQL Databases, SQL Server Integration Services, Talend, Azure Data Factory, Informatica Powercenter, Generative AI, Data Strategy, Data Lineage, Data Analytics, Tools for Reporting - **Published:** July 12, 2026 - **Apply:** https://uk.indeed.com/viewjob?jk=c0ac485a8e44916f ## About the Role The successful candidate will be hands-on, detail-oriented, and possess a strong understanding of data, technology, and solution design principles., Extensive experience in data migration, data engineering, data quality, data governance, and data remediation within a banking or regulated environment. Strong technical expertise in SQL, database technologies (Oracle, SQL Server, MySQL), ETL and migration tools (e.g., Informatica, Talend, SSIS, AWS DMS, Azure Data Migration Service), and reporting tools such as Power BI and Tableau. Proven ability to perform requirements gathering, rule writing and testing, stakeholder management, problem solving, RAID management, and delivery of multiple concurrent projects. Competencies Customer Focus Driving Change Driving Results Embraces Diversity Enterprise Leadership Judgement and Decision Making Risk Management Strategic and Visionary Trust and Integrity What we offer ## Description The Data Office is seeking a Lead Data Analyst - Data Migration to support strategic transformation initiatives across the Bank. The role will be responsible for leading data migration activities across multiple programmes, establishing data migration standards and frameworks, and ensuring the secure, accurate, and controlled movement of data between systems throughout the full delivery lifecycle from discovery and design through to deployment and optimisation. The successful candidate will play a key role in shaping the Bank's Data Migration capability, supporting both large-scale transformation programmes and smaller tactical initiatives. Working closely with business, operations, technology, and data stakeholders, they will define migration approaches, data mapping strategies, quality controls, transformation rules, and validation processes to ensure successful delivery. The role will support the migration of client, reference, transactional, and operational data into new platforms and business processes, helping the Bank modernise its data landscape while maintaining high standards of governance, security, and regulatory compliance. As part of the wider Data Office strategy, the Lead Data Analyst will also contribute to the development of reusable migration frameworks, tooling, and best practices. The role will collaborate with Data Strategy, Data Analytics, Data Governance, Data Privacy and Data Innovation teams to identify opportunities to leverage automation, AI, and Generative AI capabilities to improve data profiling, quality assessment, mapping, lineage discovery, transformation, validation, testing, monitoring, and migration optimisation. The ideal candidate will combine strong technical expertise with a hands on delivery mindset, bringing experience in data migration, data quality, data governance, stakeholder engagement, and change delivery within a complex banking environment., The Lead Data Analyst will help establish and evolve the Bank's Data Migration Framework, supporting the movement and transition of data between systems. As part of a growing team, the role contributes to migration strategy, framework development, tooling adoption, and delivery of successful migration outcomes across multiple programmes., The Lead Data Analyst is responsible for leading data migration activities across strategic programmes, ensuring the accurate, secure, and compliant movement of data between systems. The role combines data analysis, migration delivery, governance, stakeholder engagement, testing, cutover support, and continuous improvement to deliver successful business outcomes., Lead data lineage, mapping, transformation, validation, cleansing, and migration activities to support the successful transfer of data between source and target systems. Ensure data quality, governance, security, regulatory compliance, testing, cutover planning, runbook execution, and post-migration validation throughout the migration lifecycle. Collaborate with business, technology, operations, and programme stakeholders to deliver analysis, reporting, documentation, issue resolution, user support, and continuous process improvement. ## Related Videos - [MySQL Protocol Features You Should Be Aware Of](https://www.wearedevelopers.com/videos/100267-mysql-protocol-features-you-should-be-aware-of) - [From Messy Queries to Scalable Systems - How Data Engineering actually works](https://www.wearedevelopers.com/videos/100203-from-messy-queries-to-scalable-systems-how-data-engineering-actually-works) - [Coding for Good: Achieving social change with an app](https://www.wearedevelopers.com/videos/1645-coding-for-good-achieving-social-change-with-an-app) - [Migrating half a million users to a new payment service provider](https://www.wearedevelopers.com/videos/730-migrating-half-a-million-users-to-a-new-payment-service-provider) - [Branch your database like your code: How schema changes and pull requests go hand in hand](https://www.wearedevelopers.com/videos/350-branch-your-database-like-your-code-how-schema-changes-and-pull-requests-go-hand-in-hand) - [Modern Data Architectures need Software Engineering](https://www.wearedevelopers.com/videos/1030-modern-data-architectures-need-software-engineering) ## Related Articles - [Data Analyst Salary in the UK](https://www.wearedevelopers.com/magazine/278-data-analyst-salary-in-the-uk) - [Coffee with Developers - Maria Apazoglou - Making AI understandable for all in production](https://www.wearedevelopers.com/magazine/475-coffee-with-developers-maria-apazoglou-making-ai-understandable-for-all-in-production) - [Best Companies to work for in London: Top 25 Companies in 2023](https://www.wearedevelopers.com/magazine/187-best-companies-to-work-for-in-london-top-25-companies-in-2023) - [Data Engineer Salary UK](https://www.wearedevelopers.com/magazine/253-data-engineer-salary-uk) - [Software Engineer Salary London](https://www.wearedevelopers.com/magazine/252-software-engineer-salary-london) - [Top-Paying Tech Jobs (with Salaries)](https://www.wearedevelopers.com/magazine/372-top-paying-tech-jobs-with-salaries)