Data Modelling Engineer

Rimes Technologies; Singapore; Hybrid; SGD 120,000 - 180,000; Full time

Benefits offered by this job

23 days annual leave

Employee Assistance Programme

Job summary

Rimes is seeking a Data Modelling Engineer to design scalable data models for financial datasets on Databricks, ensuring they are well-structured for downstream use and production-ready.

You will profile datasets, verify fields and formats, and collaborate with data engineers to implement mappings and governance using Unity Catalog, Delta Lake, and PySpark. This role blends hands-on exploration with shaping data workflows across the organization.

Qualifications

• 5+ years of experience designing production data models.
• Strong SQL and data profiling abilities with large datasets.
• Experience with Databricks and Delta Lake.

Responsibilities

• Design scalable data models on Databricks using Delta Lake and Lakehouse architecture.
• Profile new datasets to understand structure, data types and keys.
• Define source-to-target mappings and handling rules for ETL/ELT pipelines.
• Test sample data against models to validate mappings before production.

Skills

SQL

Databricks

Python

Data modelling

Git

Education

Bachelor's degree in Engineering/CS/Math

Tools

Delta Lake

Unity Catalog

PySpark

Job description

Rimes provides the Intelligence Fabric for Capital Markets, a trusted data network and intelligence architecture that transforms fragmented data, operations and workflows into decision-grade intelligence. The world’s leading institutional investors, asset managers, and service providers rely on Rimes to help them make better investment decisions that power more than US$ 75 trillion in AUM annually.

The Opportunity:

As a Data Modelling Engineer, you will design scalable, production-ready data models for financial datasets on Databricks, and 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:

• Design and maintain scalable data models (tables, relationships, hierarchies, history handling) on Databricks using Delta Lake and Lakehouse architecture.
• Profile new index, pricing, reference, ESG, and research datasets to understand structure, fields, data types, keys and vendor specific quirks.
• Identify inconsistencies, missing fields, formatting issues, or schema gaps and collaborate on remediation.
• Define source-to-target mappings, schemas and handling rules that Data Engineering can implement in ETL/ELT pipelines, and work closely with them to ensure the build matches the design.
• Test sample data against models to validate mappings and assumptions before they go into production.
• Use Unity Catalog to support governance, lineage and traceability of modelled data.
• Document field definitions, data relationships, and handling rules clearly for internal teams, and contribute to modelling standards and good data practice.
• Review provider schema updates and adjust models when needed to maintain alignment.

Requirements:

• 5+ years of experience in data modelling, with a track record of designing conceptual, logical and physical models for production platforms.
• Solid grasp of relational and dimensional modelling fundamentals, including hierarchies and history handling (e.g. slowly changing dimensions)
• Strong SQL and hands-on experience profiling and validating unfamiliar datasets.
• Hands-on experience with Databricks, including Delta Lake and Unity Catalog.
• Python for data profiling and validation.
• Experience with Git or similar version control systems.
• Degree in a technical discipline (e.g. Engineering, Computer Science, Mathematics) or equivalent experience demonstrating strong analytical and data modelling capability.
• 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:

• PySpark for data exploration, prototyping or building transformations.
• Familiarity with common data exchange and schema formats, such as XML and JSON.
• Experience with modern data platforms such as Palantir Foundry or Snowflake.
• Strong Excel skills for exploratory data assessment.
• Progress toward the CFA or a similar investment qualification, or equivalent knowledge of investment data and concepts

What We Offer:

• 23 days of annual leave
• Employee Assistance Programme

Compensation: Competitive pay and bonus eligibility

Work Life Balance: Flexible hybrid work environment

Only selected candidates will be contacted for interviews. We appreciate your understanding. Thank you for considering a career with us.

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.