Data Migration Analyst/6 months contract/48-58k HKD P/M

Argyll Scott; Hong Kong; On-site; HKD 614,000 - 949,000; Full time

Job summary

Argyll Scott Asia is seeking a hands-on Data Migration Analyst to support regional merger, acquisition, integration, and separation programmes. The role focuses on data assessment, transformation, validation, transfer, and governance across complex technology transitions.

You will work with business, technology, security, and control teams, leveraging SQL, data extraction, transformation, and validation skills to ensure accurate data migration and clear documentation.

Qualifications

• Experience in data migration and data analysis across complex tech programs.
• Strong SQL, data extraction, transformation, validation and reconciliation.
• Knowledge of data lineage, mappings, test scenarios, validation rules, and defect management.
• Excellent attention to detail and ability to manage multiple priorities.
• Experience in multi-stakeholder projects, APAC market is a plus.

Responsibilities

• Analyse source and target data structures, formats, volumes, quality, mappings, and dependencies.
• Support ETL processes: extraction, transformation, loading, testing, reconciliation, and post-migration checks.
• Define validation rules and completeness checks, plus pre-/post-migration comparisons.
• Investigate discrepancies, defects, duplicates, omissions, and coordinate remediation.
• Maintain migration docs: mappings, lineage, inventories, validation results, approvals, and audit trails.

Skills

SQL

Data migration

Data analysis

Data quality

Testing

Stakeholder coordination

Education

Data/Technology related degree

Tools

Power BI

Excel

Jira

ServiceNow

ETL tools

Data profiling tools

Python

Job description

Data Migration Analyst

Contract: 6 months

Our client, a leading international financial services organization is seeking a hands‑on Data Migration Analyst to support regional merger, acquisition, integration, and separation programmes.

The successful candidate will help ensure that data is accurately assessed, transformed, validated, transferred, and governed throughout complex technology transitions. This role requires strong analytical capability, technical data skills, and the ability to coordinate delivery across business, technology, security, and control teams.

Key Responsibilities

• Analyse source and target data structures, formats, volumes, quality, mappings, and dependencies.
• Support data extraction, transformation, loading, migration testing, reconciliation, and post-migration verification.
• Define and execute validation rules, completeness checks, and pre- and post-migration comparisons.
• Investigate data discrepancies, defects, duplication, omissions, and control issues, coordinating remediation through to resolution.
• Maintain clear migration documentation, including data mappings, lineage, inventories, validation results, decisions, approvals, and audit evidence.
• Apply data governance, privacy, information security, retention, and regulatory control requirements.
• Coordinate test cycles, dress rehearsals, cutover activities, runbooks, incidents, risks, and dependencies.
• Provide clear status reporting and translate technical findings into business impacts and recommended actions.

Essential Experience

• Experience in data migration, data analysis, data quality, testing, or technology delivery.
• Strong practical experience with SQL, data extraction, transformation, validation, and reconciliation.
• Knowledge of source-to-target mapping, data lineage, test scenarios, validation rules, and defect management.
• Strong attention to detail with the ability to identify anomalies and assess data risks.
• Experience working in structured, multi-stakeholder project or change environments.
• Clear communication skills and the ability to manage competing priorities and deadlines.

Preferred Experience

• Experience supporting M&A, divestments, separations, integrations, or large-scale technology migrations.
• Background in banking, financial services, or another highly regulated industry.
• Familiarity with ETL tools, data profiling tools, cloud data platforms, or automated testing.
• Exposure to Python, PowerShell, Excel, Power BI, Jira, ServiceNow, or equivalent tools.
• Experience working across international teams or APAC markets.
• Relevant qualification in data, technology, computer science, information systems, or engineering.

Argyll Scott Asia is acting as an Employment Business in relation to this vacancy.