Data Analyst (Data Migration & Reconciliation)

Ambition; Hong Kong; On-site; HKD 400,000 - 680,000; Full time

Job summary

Ambition in Hong Kong is seeking a hands-on Data Analyst to support a regional enterprise transformation. The role focuses on data migration, reconciliation, validation, and quality assurance across complex datasets, using SQL and Python to handle large volumes.

You will automate validation processes, produce quality metrics, and drive improvements in migration efficiency, working with ERP or enterprise data domains.

Qualifications

• Bachelor's degree in CS/IS/Data Analytics/Stats.
• 3+ years in data analytics, data migration or quality roles.
• Strong SQL skills for large datasets.
• Strong Python for data manipulation and automation.
• Experience with data reconciliation and root cause analysis.
• Experience supporting system migration or integration.

Responsibilities

• Perform data extraction, profiling, validation, and reconciliation across multiple systems.
• Support data migration activities including data mapping, transformation, cleansing, and verification.
• Develop and optimize SQL queries to analyze and validate large datasets.
• Investigate data discrepancies and perform root cause analysis.
• Build Python-based automation to improve data validation, reconciliation, and quality control processes.
• Run data quality checks and ensure data completeness, consistency, and accuracy.
• Support testing and migration cycles through detailed data verification activities.
• Produce reconciliation reports and data quality metrics.
• Identify opportunities to improve migration and reconciliation efficiency through process enhancement and automation.

Skills

SQL

Python

Data analysis

Data validation

Data reconciliation

Automation

Root cause analysis

Attention to detail

Education

Bachelor's degree in Computer Science / Information Systems / Data Analytics / Statistics

Tools

ERP systems

Job description

We are seeking a Data Analyst to support a regional enterprise transformation programme. The role focuses on data migration, reconciliation, validation, and quality assurance activities across complex datasets.

The ideal candidate will possess strong SQL and Python capabilities and be comfortable working with large volumes of data to identify discrepancies, automate validation processes, and improve reconciliation efficiency.

Key Responsibilities

• Perform data extraction, profiling, validation, and reconciliation across multiple systems
• Support data migration activities including data mapping, transformation, cleansing, and verification
• Develop and optimize SQL queries to analyze and validate large datasets
• Investigate data discrepancies and perform root cause analysis
• Build Python-based automation to improve data validation, reconciliation, and quality control processes
• Run data quality checks and ensure data completeness, consistency, and accuracy
• Support testing and migration cycles through detailed data verification activities
• Produce reconciliation reports and data quality metrics
• Identify opportunities to improve migration and reconciliation efficiency through process enhancement and automation

Requirements

• Bachelor's degree in Computer Science, Information Systems, Data Analytics, Statistics, or a related discipline
• 3+ years of experience in Data Analytics, Data Migration, Data Quality, or related disciplines
• Strong SQL skills with experience querying and analyzing large datasets
• Strong Python skills for data manipulation, validation, and automation
• Experience in data reconciliation, data validation, and root cause analysis
• Experience supporting system migration, transformation, integration, or implementation projects
• Strong analytical and problem-solving abilities
• High attention to detail and data accuracy

Preferred Experience

• Experience working with ERP or enterprise systems
• Exposure to finance, master data, customer data, product data, or operational data
• Experience supporting regional transformation or migration programmes
• Familiarity with data quality frameworks and controls

  Ideal Candidate

  We're looking for a hands-on technical analyst who enjoys working directly with data. The ideal candidate combines strong SQL and Python capabilities with practical experience in data migration, reconciliation, and quality assurance within complex enterprise environments.