Senior Data Analyst - Data Migration

About the role

We are looking for an experienced Senior Data Analyst to lead data migration activities within a major transformation programme for a Corporate and Investment Banking client. The role focuses on moving complex customer, account, transaction and reference data from a legacy cash‑management system to a new Liquidity Management platform.

Key responsibilities

• Analyse legacy and target‑system data across customer, account, transaction and reference datasets.
• Identify, assess and document all data required for migration, performing detailed data profiling and quality assessments.
• Develop and maintain source‑to‑target data mappings, documenting lineage, transformation rules and business logic.
• Validate data pipelines between on‑premises systems and AWS, and perform source‑to‑target reconciliations.
• Write SQL queries to interrogate, compare and validate large datasets, and prepare extracts for migration testing.
• Build Power BI dashboards to monitor migration progress, exceptions and data quality.
• Collaborate with data engineers, developers, testers and business stakeholders to resolve migration defects.
• Maintain requirements, findings, risks and defects in Jira and Confluence, and communicate technical findings to stakeholders.

Required profile

• Strong professional experience as a Data Analyst, Technical Data Analyst or Data Migration Analyst.
• Proven involvement in at least one complex end‑to‑end data migration project.
• Excellent stakeholder engagement and ability to work across business, engineering and testing teams.
• Experience in banking or financial services is preferred.

Required skills

• Advanced SQL for data interrogation and validation.
• Experience with AWS data services and data pipelines.
• Power BI for dashboarding and reporting.
• Jira and Confluence for issue and documentation tracking.
• Data profiling, data mapping, data lineage and data quality assessment.
• Hands‑on data migration and source‑to‑target reconciliation.