Remote Data Modeling Engineer: RRS & Migration

Click Global Talent; Kuala Lumpur; Remote; MYR 180,000 - 240,000; Full time

Job summary

Click Global Talent is seeking a Data Modeling Engineer with expert knowledge of Regulatory Reporting System (RRS) data and migration strategies. The role spans analysis, design, build, SIT, UAT, and go-live with ongoing reconciliation and cutover responsibilities.

You will collaborate with business analysts, ETL/ELT developers, DBAs, and the data architect. The ideal candidate has extensive experience in enterprise data warehouses, dimensional modeling, and complex migrations across platforms,

Qualifications

• Minimum 8 years in data modelling / data engineering.
• Bachelor's degree in Computer Science, Information Systems, Engineering, or a related discipline.
• Deep data modelling across conceptual, logical, and physical layers using dimensional, 3NF, and Data Vault techniques.
• Proven delivery of a platform migration with schema/DDL conversion and data-type translation.
• Experience with migration where structures and results must be preserved exactly.

Responsibilities

• Produce and maintain data models for staging, integration, and consumption layers.
• Apply dimensional, 3NF, and Data Vault techniques and define grain, keys, relationships, and history.
• Convert legacy RRS data models to the target platform with correct lineage and auditability.
• Design physical models for the target MPP engine and advise ELT developers on model structures.
• Create Source-to-Target Mapping specifications and maintain data lineage and metadata.
• Lead end-to-end delivery lifecycle: design, build, SIT, UAT, parallel run, cutover.

Skills

Data modelling

Data engineering

SQL

Data Vault

ETL/ELT

Data warehouse

Education

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

Tools

GaussDB/DWS

Netezza

Teradata

Snowflake

DDL

Job description

Click Global Talent is seeking a Data Modeling Engineer with expert knowledge of Regulatory Reporting System (RRS) data and migration strategies. The role spans analysis, design, build, SIT, UAT, and go-live with ongoing reconciliation and cutover responsibilities.

You will collaborate with business analysts, ETL/ELT developers, DBAs, and the data architect. The ideal candidate has extensive experience in enterprise data warehouses, dimensional modeling, and complex migrations across platforms,