P

Senior Data Analyst - Data Migration

Pty
3 days ago
Full-time
On-site
Johannesburg, South Africa

Introduction

ID: 32521

Location: Johannesburg 
Work Arrangement: Hybrid
Contract: Fixed-term contract until 30 January 2027
Start Date: As soon as possible
Industry: Banking and Financial Services

The Opportunity

An exciting opportunity is available for an experienced Senior Data Analyst with strong data migration experience to join a major transformation programme within a leading Corporate and Investment Banking environment.

You will support the migration of complex customer, account, transaction and reference data from a legacy cash-management application into a new Liquidity Management System.

This is not a traditional reporting-only Data Analyst position. We are looking for a hands-on specialist who can interrogate large datasets, identify data-quality issues, map and reconcile data, validate migration results and confidently confirm whether data is ready for migration.

The role requires strong technical analysis capability, excellent stakeholder engagement and experience working across business, engineering and testing teams.

Duties & Responsibilities

  • Analyse legacy and target-system data across customer, account, transaction and reference datasets.
  • Identify, assess and document all data required for migration.
  • Perform detailed data profiling and data-quality assessments.
  • Identify missing, duplicated, inconsistent or inaccurate records.
  • Develop and maintain source-to-target data mappings.
  • Document data lineage, transformation rules, dependencies and business rules.
  • Analyse and validate data pipelines between on-premises systems and AWS.
  • Validate data across landing, cleansed and curated data layers.
  • Perform source-to-target reconciliations to confirm migration completeness and accuracy.
  • Investigate schema changes, transformation failures and data-quality exceptions.
  • Write SQL queries to interrogate, compare and validate large datasets.
  • Prepare extracts and supporting analysis for migration testing and business acceptance.
  • Develop Power BI dashboards to monitor migration progress, exceptions and data quality.
  • Work closely with data engineers, developers, testers and business stakeholders to resolve migration defects.
  • Support deployment and post-migration validation activities.
  • Maintain accurate requirements, findings, risks and defects in Jira and Confluence.
  • Clearly communicate migration risks and technical findings to business and technical stakeholders.

Desired Experience & Qualification

  • 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.
  • Advanced SQL and data interrogation skills.
  • Practical experience with:
    • Data profiling and data-quality analysis
    • Source-to-target mapping
    • Data cleansing and transformation validation
    • Data reconciliation
    • Migration testing and validation
    • Data lineage and dependency analysis
    • ETL or data-pipeline validation
  • Experience working with cloud-based data platforms or data pipelines.
  • Power BI dashboard development and reporting experience.
  • Experience supporting UAT or business acceptance testing.
  • Strong documentation and stakeholder-management capability.
  • Experience working in an Agile delivery environment.

Advantageous Experience

  • Banking or broader financial-services experience.
  • Transaction banking, cash management, payments, liquidity or treasury exposure.
  • Experience migrating customer, account or transactional data.
  • AWS data-platform experience, including technologies such as:
    • Amazon S3
    • AWS Glue
    • Amazon Athena
    • Amazon Redshift
  • Experience with legacy banking-system migrations.
  • Understanding of banking data controls, governance and regulatory requirements.
  • Liquidity Management System or similar financial-platform exposure.
  • Jira and Confluence experience.
  • A relevant IT, Computer Science, Information Systems, Data or Analytics qualification.