Data Modeler

APAR TECHNOLOGIES PTE. LTD.; Singapore; On-site; SGD 80,000 - 120,000; Full time

Job summary

A technology consultancy firm in Singapore is seeking a Data Modeler with over 7 years of experience in data modelling and migration, particularly from legacy systems to PostgreSQL. This crucial role involves leading data modelling efforts, defining migration strategies, and ensuring alignment with business needs. The ideal candidate will have deep expertise in PostgreSQL and a strong understanding of data governance and compliance standards.

Qualifications

• 7+ years of hands-on data modelling and data migration experience for complex systems.
• Prior experience in migrating complex data from legacy systems to PostgreSQL.
• Deep knowledge of PostgreSQL performance and migration features.

Responsibilities

• Lead data modelling for financial system modernization.
• Perform legacy data discovery and create source-to-target mappings.
• Define end-to-end data migration strategies.

Skills

data modelling

data migration

PostgreSQL

Tools

PlantUML

Draw.io

Job description

JDSummary

We are looking for a Data Modeler with deep expertise in enterprise system migration and modernization programs, preferable in the financial domain. This role will play a pivotal role in decommissioning legacy systems and rebuilding future‑ready platforms using PostgreSQL DB.

Required Qualifications

• 7+ years of hands‑on data modelling and data migration experience for complex system and handling high volume data migration.
• Prior experience in migrating complex data from legacy systems (SQL/MP, Enscribe) to PostgreSQL.
• Deep knowledge of PostgreSQL performance and migration features (large-scale COPY, FDW, partitioning, parallel query).

Preferred Skills (Good to Have)

• Knowledge of data modelling tools (PlantUML, Draw.io).
• Experience with reconciliation frameworks.
• Previous projects involving reporting migrations or reference data modernization.

Key Responsibilities

• Lead conceptual, logical, and physical data modelling for enterprise‑wide financial system modernization and core platform replacement initiatives.
• Data remodeling supporting transactional, analytical, and regulatory workloads.
• Perform legacy data discovery, profiling, and create detailed source‑to‑target mappings (STTM) for migrations involving hundreds of tables.
• Define and execute end‑to‑end data migration strategies from legacy environments to modern PostgreSQL.
• Collaborate with solution architects, data engineers, and business stakeholders to ensure modelling aligns with business and technology needs.
• Produce high‑quality deliverables: ER diagrams, data dictionaries, data mapping, migration runbooks, reconciliation reports.
• Enforce data governance, quality, masking, and compliance standards.