Data Modeling Engineer

jobr.pro; Singapore; On-site; SGD 90,000 - 130,000; Full time

Benefits offered by this job

Private Health Insurance

23 days of annual leave

Employee Assistance Programme

Job summary

Rimes is seeking a Data Modeling Engineer to work hands-on with financial datasets, ensuring accurate structures and readiness for downstream pipelines.

You will build and validate data models, collaborate with Data Engineering to deliver ETL/ELT-ready schemas, and document definitions for cross-functional teams. Ideal candidates have 1–3+ years in data modeling and finance data, with a strong eye for quality.

Qualifications

• Experience with conceptual, logical, and physical data models.
• Strong knowledge of relational and dimensional modeling.
• Proficiency in SQL and basic Python for profiling and validation.

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 what needs adjustment.
• Build and update data models (tables, relationships, hierarchies) based on real dataset behavior.
• Test sample data against models to ensure mappings, assumptions, and transformations are correct.
• Work closely with Data Engineering to translate models into ETL/ELT-ready schemas.
• Document field definitions, data relationships, and handling rules clearly 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

Git

Data modeling

Attention to detail

Cross-functional collaboration

Analytical thinking

Education

Bachelor's degree in Computer Science / Engineering / Mathematics

Tools

Databricks

Foundry

Snowflake

Parquet

Excel

Git

Job description

About Rimes

Rimes provides enterprise data management solutions to the global investment community. Driven by our passion for solving the most complex data problems, we provide our clients with investment intelligence that powers more than US$75 trillion in assets under management annually. The world’s leading institutional investors, asset managers and service providers rely on Rimes to help them make better investment decisions using accurate information and industry-leading technology.

The Opportunity

As a Data Modeling Engineer, you will work hands‑on with financial datasets to make sure they are understood, structured correctly, and ready for downstream use. Alongside building data models, you will perform practical, early‑stage analysis on new datasets, checking fields, formats, and structure to ensure consistency and proper handling before the data enters our pipelines.

You will help ensure that new datasets, including index, pricing, reference, and research data, integrate smoothly into Rimes’ data ecosystem with clarity, quality, and traceability. This role is well suited for someone who enjoys rolling up their sleeves, exploring datasets directly, and shaping the underlying structures that power data workflows across the organization.

Responsibilities

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

Requirements

• Experience working 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 a technical discipline (e.g. Engineering, Computer Science, Mathematics) or equivalent experience demonstrating strong analytical and data modeling capability.
• 1–3+ years of experience in data modeling, data engineering, or data architecture.
• Strong attention to detail and ability to investigate datasets independently.
• Clear communication skills and comfort working with cross‑functional teams.
• Organized, proactive, and committed to accuracy and continuous improvement.
• Experience working with financial data, including research datasets (e.g., ESG data), with the ability to model data for analytical and investment use cases.

Preferred Experience

• Familiarity with XML, JSON, and schema definition languages.
• Experience with modern data platforms such as Databricks, Foundry (Palantir), Snowflake, or Parquet‑based systems.
• Strong Excel skills for exploratory data assessment.
• Progress toward CFA Level II or higher.

What We Offer

• Private Health Insurance (plus eligible dependents)
  23 days of annual leave
  Employee Assistance Programme

Compensation: Competitive pay and bonus eligibility

Work Life Balance: Flexible hybrid work environment

Rimes is committed to promote the values of diversity and inclusion throughout the business. Whether it’s through recruitment, retention, career progression or training and development, we are committed to improving opportunities for people regardless of their background or circumstances.