Data Modeler

Job Title: Data Modeller

Location: Pune & Bangalore

Experience: 7 – 15 Years

Work Mode: Hybrid (3 Days Onsite)

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:

• ERwin

• ER Studio

• PowerDesigner

• 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

Key Competencies

• 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