Data Migration Analyst for M&A Tech Integrations

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

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.