Data Migration Lead Data Analyst

Sumitomo Mitsui Banking Corporation
Charing Cross, United Kingdom
2 days ago

Role details

Contract type
Permanent contract
Employment type
Full-time (> 32 hours)
Working hours
Regular working hours
Languages
English
Experience level
Senior

Job location

Charing Cross, United Kingdom

Tech stack

Artificial Intelligence
Amazon Web Services (AWS)
Data analysis
Business Intelligence
Databases
Information Engineering
Data Governance
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
Informatica Powercenter
Generative AI
Data Strategy
Data Lineage
Data Analytics
Tools for Reporting

Job 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.

Requirements

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

Benefits & conditions

Pulled from the full job description

  • Annual leave
  • Private medical insurance, 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.

.buttontextfef7b1971ec97ba9 a{ border: 1px solid transparent; } .buttontextfef7b1971ec97ba9 a: focus{ border: 1px dashed #aad041 !important; outline: none !important; } About SMBC

A trusted partner for the long term 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, we deliver a full suite of corporate finance products and solutions to our customers, including corporate, structured and trade finance, leveraged finance, loan market and treasury products. We can also provide investment banking and advisory services and a range of innovative solutions in global capital markets. about what we do and who we are at https://www.smbcgroup.com/emea/careers

About the company

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.

Apply for this position