Data Migration & Analytics Engineer

SCIENTE INTERNATIONAL PTE. LTD.; Singapore; On-site; SGD 90,000 - 130,000; Full time

Job summary

SCIENTE INTERNATIONAL PTE. LTD. in Singapore seeks a detail-oriented Data Engineer / Data Migration Analyst to support enterprise data migration, reporting transformation, and data quality initiatives across legacy systems and modern platforms.

You will analyze datasets, develop ETL pipelines, map source-to-target data, and ensure accurate migration of reporting datasets to the new data platform, using SQL, Hive, Impala, and Hadoop tools.

Qualifications

• Bachelor's degree in Computer Science, Information Systems, Engineering, Mathematics, Statistics, or related discipline.
• Minimum 3 years' experience in Data Engineering, ETL, Data Warehousing, Reporting, or Data Migration.
• Strong SQL development and data manipulation skills.
• Proficiency in SAS and/or Python scripting.
• Hands-on experience with Hue, Hive, Impala, Oozie.
• Experience with large and complex datasets and relational databases.

Responsibilities

• Analyze existing tables, reports, datasets, and data processing workflows from legacy data marts.
• Review SQL scripts, transformation logic, business rules, and data dependencies.
• Identify source systems, data lineage, reporting requirements, and current-state data processes.
• Collaborate with business users to translate requirements into technical solutions.
• Perform source-to-target mapping between legacy data marts and new enterprise data marts.
• Document mappings, transformation logic, and business rules.
• Develop and maintain SQL scripts using Hive and Impala via Hue.
• Build data extraction, transformation, validation, and reporting processes.
• Rebuild reporting datasets and data preparation workflows in the new data marts.
• Perform reconciliation between legacy outputs and new platform results.
• Validate data accuracy, completeness, consistency, and timeliness.
• Involvement in documentation and data governance.

Skills

SQL development

Data engineering

ETL development

Python scripting

SAS

Hadoop ecosystem

Data warehousing

Data migration

Data modelling

Data analysis

Education

Bachelor's degree in Computer Science or related field

Tools

Hue

Hive

Impala

Oozie

Job description

SCIENTE INTERNATIONAL PTE. LTD. in Singapore seeks a detail-oriented Data Engineer / Data Migration Analyst to support enterprise data migration, reporting transformation, and data quality initiatives across legacy systems and modern platforms.

You will analyze datasets, develop ETL pipelines, map source-to-target data, and ensure accurate migration of reporting datasets to the new data platform, using SQL, Hive, Impala, and Hadoop tools.