Data Modeling Engineer: Shape Investment Data Flows

Rimes; Singapore; Hybrid; SGD 65,000 - 95,000; Full time

Benefits offered by this job

Private Health Insurance

23 days annual leave

Employee Assistance Programme

Job summary

Rimes is seeking a Data Modeling Engineer to work hands-on with financial datasets, structuring and validating data for downstream pipelines. You will build data models, profile datasets, and ensure consistency before ingestion, collaborating with Data Engineering to enable ETL/ELT-ready schemas.

The role emphasizes working directly with datasets across index, pricing, reference, and research data, with a focus on accuracy, traceability, and cross-functional collaboration in a hybrid work

Qualifications

• Experience with conceptual, logical, and physical data models.
• Solid understanding of relational and dimensional modeling basics.
• Proficiency in SQL and familiarity with Python for profiling, validation, or simple automation.
• Experience with Git or similar version control systems.
• Educational background in Engineering, Computer Science, Mathematics, or equivalent with strong analytical and data modeling capability.
• 1–3+ years of experience in data modeling, data engineering, or data architecture.

Responsibilities

• Inspect new datasets to understand structure, fields, data types, and quirks before ingestion.
• Identify inconsistencies, missing fields, formatting issues, or schema gaps and flag necessary adjustments.
• Build and update data models (tables, relationships, hierarchies) based on real dataset behavior.
• Test sample data against models to ensure mappings and transformations are correct.
• Collaborate with Data Engineering to translate models into ETL/ELT-ready schemas.
• Document field definitions, data relationships, and handling rules for internal teams.
• Review provider schema updates and adjust models to maintain alignment.
• Support data quality improvements by applying model-level fixes and ensuring consistent patterns.
• Contribute to improvements in modeling standards, documentation, and internal processes.

Skills

SQL

Python

Data profiling

Data modeling

Communication

Attention to detail

Education

BSc in Engineering/CS/Mathematics or equivalent

Tools

Git

Databricks

Snowflake

Parquet-based systems

Job description

Rimes is seeking a Data Modeling Engineer to work hands-on with financial datasets, structuring and validating data for downstream pipelines. You will build data models, profile datasets, and ensure consistency before ingestion, collaborating with Data Engineering to enable ETL/ELT-ready schemas.

The role emphasizes working directly with datasets across index, pricing, reference, and research data, with a focus on accuracy, traceability, and cross-functional collaboration in a hybrid work