Data Migration Lead Data Analyst
London, LND, GB, EC2M 2AT
SMBC: A trusted partner for the long term
Here at SMBC Group, we want to help you find the next step in your career so read on to discover if this opportunity is the one for you. We like to recognise potential in our people, so we welcome your application even when your experience doesn’t perfectly align with the job description. Whilst we’ll always strive to be better, we’re proud of our inclusive culture, and encourage our applicants and colleagues to be their authentic, unique selves.
Who we are
United by a sense of purpose towards our customers – to be a trusted partner for the long-term – and our universal banking platform in EMEA, SMBC Group has an international growth agenda and award-winning products, meaning we provide exciting opportunities to work on a diverse range of projects and initiatives. We deliver a full suite of corporate finance products and solutions to our customers as well as investment banking and advisory services, and a range of innovative solutions in global capital markets. Read on to find out how you could enhance your skills and gain valuable experience, by joining us to support our clients transition to a sustainable future.
Business Area
|
The EMEA Data Office has been established for nearly four years and is growing significantly. The bank is at the early stages of it data journey and it under going a number of programmes to change the way the bank works. |
Position 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.
Role Summary
Lead Data Analyst – Data Migration
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 successful candidate will be hands-on, detail-oriented, and possess a strong understanding of data, technology, and solution design principles.
Summary of Role
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.
Essential Responsibilities
- 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.
Candidate Requirements
- 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
What we offer
For all the expertise and experience you bring to help us make a difference, it’s only sustainable if we support you to build your career and be your best self so we offer competitive company benefits, centred around promoting positive well-bring and work-life balance. We also believe in fostering a diverse and inclusive work environment, where all team members perspectives and contributions are valued. Initiatives in place which promote a diverse and inclusive culture and healthy work life balance include hybrid working, Sport & Social Clubs and Diversity and Inclusion networks.
As an employee of SMBC you have access to a host of both useful and exciting benefit offerings. See below some of the benefits on offer to you:
- Hybrid and flexible working
- Competitive paid leave days
- Benefits to support your physical wellbeing, including private medical insurance and life and invalidity insurance
- Various policies to support your mental wellbeing, including a robust behavioural health network with counselling and coaching services
- Access a wide range of learning and development opportunities and career progression opportunities
- Ambitious remuneration package
So, if you like a challenge and want to continuously grow and develop in a role where you will be supported along the way by a dynamic and diverse team, apply today!!
We recognise our role as a bank to support social change and welcome all applications, including those from groups often under-represented in financial services. We value the uniqueness of professional and personal, backgrounds and perspectives as they play a vital role in continuing the sustainable growth of our organisation. We’ll ensure reasonable adjustments to our recruitment process are offered due to a disability or long-term condition whenever requested.
We are committed to transparent and equitable pay practices. Compensation is determined using objective criteria, including skills, experience, and role responsibilities, and applied consistently throughout our recruitment processes. We do not request candidates' pay history and are committed to preventing unjustified pay disparities.