Data Migration Analyst: SQL & Data Warehousing

RECRUIT EXPRESS PTE LTD; Singapore; On-site; SGD 70,000 - 110,000; Full time

Job summary

Recruit Express Pte Ltd is seeking a data engineering professional to analyze and migrate data between legacy systems and new data marts in a banking/financial services context. You will develop SQL scripts, map source-to-target data, and document data lineage and transformation rules.

The role requires 3–5 years of relevant experience, strong SQL skills, and familiarity with Hive and Impala. Collaboration with business users and participation in testing and documentation are essential.

Qualifications

• Degree in Computer Science, Information Systems, Engineering or a related discipline.
• 3 to 5 years of relevant experience in data engineering, data migration, ETL development, reporting or data management.
• Experience within banking or financial services will be an advantage.
• Strong SQL skills are mandatory.
• Prior data management and coding experience.

Responsibilities

• Analyse existing tables, reports, datasets and data processing workflows from legacy data marts and manual processes.
• Understand existing scripts, transformation logic and reporting methodologies.
• Identify data lineage, dependencies and reporting requirements.
• Work closely with business users to understand current reporting processes and migration requirements.
• Perform source to target mapping between legacy systems and new enterprise data marts.
• Document field mappings, transformation logic and business rules.
• Identify data gaps and recommend improvements.
• Develop migration specifications aligned with business requirements.
• Develop and enhance SQL scripts for data extraction, transformation and reporting.
• Work with Hive and Impala to support data migration activities.
• Rebuild existing reporting datasets using the new enterprise data marts.
• Support workflow automation where applicable.
• Perform reconciliation between legacy and migrated datasets.
• Validate data accuracy, completeness and consistency.
• Investigate and resolve data discrepancies.
• Support User Acceptance Testing (UAT) and business validation.
• Prepare and maintain project documentation including: source to target mapping, data lineage, technical specifications, data dictionaries, metadata documentation, validation and reconciliation reports, operational runbooks.

Skills

SQL

Data integration

Data warehousing

Hive

Impala

ETL development

Education

Bachelor's degree in Computer Science, Information Systems, Engineering

Tools

Hive

Impala

SQL scripting

Job description

Recruit Express Pte Ltd is seeking a data engineering professional to analyze and migrate data between legacy systems and new data marts in a banking/financial services context. You will develop SQL scripts, map source-to-target data, and document data lineage and transformation rules.

The role requires 3–5 years of relevant experience, strong SQL skills, and familiarity with Hive and Impala. Collaboration with business users and participation in testing and documentation are essential.