Data Modeler

Idyllic Services; India; On-site; INR 1,200,000 - 2,000,000; Full time

Job summary

Idyllic Services is seeking an experienced Data Modeller to design and maintain data models for enterprise-level banking and wealth management systems. The role demands expertise in logical and physical data modelling, focusing on data quality and alignment with business needs.

Ideal candidates will have strong skills in wealth management, metadata management, and collaboration with diverse teams to optimize data integration. The position offers opportunities to support data governance and work in a fast-paced global environment.

Qualifications

• Strong experience in Logical & Physical Data Modelling for enterprise-grade systems.
• Hands-on experience in wealth management data modelling.
• Strong understanding of data standards, metadata management, and naming conventions.

Responsibilities

• Design and develop Logical and Physical Data Models for banking systems.
• Collaborate with business stakeholders to translate requirements into data structures.
• Ensure consistency and reusability through canonical data models.

Skills

Logical & Physical Data Modelling

Wealth Management Data Modelling

Data Standards & Metadata Management

SQL Knowledge

Analytical Skills

Stakeholder Communication

Tools

Data Modelling Tools

Snowflake

Collibra

Job description

Shift Timing: EMEA Shift (12:30 PM – 9:30 PM IST)

Role Overview

We are looking for an experienced Data Modeller with strong expertise in enterprise-scale data modelling, particularly within the wealth management and banking domain. The role involves designing and maintaining logical and physical data models, ensuring high data quality, consistency, and alignment with business requirements.

Key Responsibilities

• Design and develop Logical and Physical Data Models for enterprise-level banking and wealth management systems
• Build and maintain data models for wealth domain entities such as Client, Portfolio, Product, and Transactions
• Collaborate with business stakeholders, data architects, and engineering teams to translate business requirements into data structures
• Define and enforce data standards, naming conventions, and metadata management practices
• Ensure consistency and reusability through canonical data models
• Work closely with data engineering teams to support data integration and performance optimisation
• Maintain data lineage, data dictionaries, and documentation for governance purposes
• Support data governance initiatives and tools implementation

Mandatory Skills

• Strong experience in Logical & Physical Data Modelling (enterprise-grade systems)
• Hands‑on experience in wealth management data modelling
• Proficiency in data modelling tools such as:
• Strong understanding of data standards, metadata management, and naming conventions

Secondary / Good‑to‑Have Skills

• Knowledge of SQL and database performance optimisation
• Exposure to modern data platforms (e.g., Snowflake, Cloud environments)
• Experience with data governance and lineage tools (e.g., Collibra)
• Understanding of core banking platforms (e.g., Avaloq or similar systems)
• Familiarity with wealth management domain data structures and processes
• Strong analytical and problem‑solving skills
• Excellent stakeholder communication and collaboration
• Attention to detail and data quality focus
• Ability to work in a fast‑paced, global environment