Data Engineer (6 months, Bank) #ESY

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

Job summary

Recruit Express Pte Ltd seeks a data engineer to analyze existing tables and workflows, map source to target systems, and develop SQL-based pipelines for migration and reporting. You will work closely with business users to define data lineage, rules, and validation processes.

The role emphasizes ETL development, data migration, and support for data governance within a banking/financial services context, leveraging Hive and Impala for large-scale data processing in Singapore.

Qualifications

• 3 to 5 years of experience in data engineering, data migration, ETL development, reporting or data management.
• Experience in banking or financial services is an advantage.
• Degree in Computer Science, Information Systems, Engineering or related discipline.

Responsibilities

• Analyze existing tables, reports, datasets and data processing workflows from legacy data marts.
• Understand scripts, transformation logic and reporting methodologies.
• Perform source to target mapping and document data lineage and rules.
• Develop and enhance SQL scripts and data pipelines for migration and reporting.
• Validate migrated datasets and support UAT and governance.

Skills

Data analysis

Data discovery

ETL development

Data migration

Reporting

Data lineage

Business rules

Education

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

Tools

Hive

Impala

SQL

Job description

Data Analysis & Discovery

• Analyse existing tables, reports, datasets and data processing workflows from legacy data marts and manual processes.
• Understand existing scripts, transformation logic, business rules and reporting methodologies.
• Identify data lineage, dependencies and reporting requirements.
• Work closely with business users to understand current reporting processes and migration requirements.

Data Migration & Source Mapping

• 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 where appropriate.
• Develop migration specifications aligned with business requirements.

Development

• 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.

Testing & Validation

• 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.

Documentation

Prepare and maintain project documentation including:

• Source to target mapping
• Data lineage
• Technical specifications
• Data dictionaries
• Metadata documentation
• Validation and reconciliation reports
• Operational runbooks

Requirements

Experience

• 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.