Data Engineer

Our client, one of Asia-Pacific’s leading organizations is looking for: Data Engineer

Develop and maintain ETL pipelines and file-based interfaces for ingesting HR data into ODIN, including data profiling, mapping, specifications and dataset onboarding. Build and maintain SQL and Python logic to cleanse, standardise, transform and reconcile HR data into reliable, reusable datasets, including historical and legacy data. Enhance ODIN data models, tables and dependencies to meet new requirements, with traceable mappings, definitions and processing rules.

Support CRs and SRs by reviewing requirements, executing tests, validating outputs, documenting defects and resolving issues through implementation. Automate validation, reconciliation and cleansing checks; investigate anomalies, trace lineage, resolve root causes and verify fixes. Monitor pipelines and interfaces, troubleshoot failures, perform reruns and improve reliability, performance, maintainability and operational documentation.

Develop governed datasets, Athena tables/views and queries, and Tableau data sources/workbooks for approved reporting and analytics needs. Translate stakeholder requirements into data mappings, transformation rules and technical solutions, while documenting decisions and supporting timely delivery. Provide technical evidence for audits, access reviews and assurance activities, and support required remediation.

Strong proficiency in SQL and working proficiency in Pyt