Data Modeler

Job Title : Data Modeler – Wholesale Lending Data Domain

Location : Chennai / Mumbai

Year of Experience- 6 to 12 years

Key Responsibilities :

1. Data Modeling & Design

Develop conceptual, logical, and physical data models for the Wholesale Lending domain / applications / platforms (e.g., Loans, Credit Facilities, Collateral, Exposure, Covenants, Customers, and Accounts).

2. Business Alignment & Data Domain Enablement

Translate complex business requirements into data model structures that align with domain-driven design principles.

3. Technical Implementation Support

Work with Data Engineers to ensure models are implemented accurately in data warehouses / data lakes / data mesh environments (e.g., Snowflake, Databricks, Teradata).

4. Data Governance & Quality

Contribute to the data catalog, metadata management, and lineage documentation (e.g., using Collibra, Alation, Atlan, or Informatica EDC).

5. Continuous Improvement & Innovation

Recommend opportunities for model optimization, standardization, and reusability across domains (Retail, Treasury, Risk).

Required Skills & Qualifications :

Technical Skills

Strong expertise in data modeling tools (e.g., ER / Studio, ERwin, PowerDesigner).

Deep understanding of relational, dimensional, and data vault modeling.

Experience with cloud data platforms (Snowflake, Azure Synapse, GCP BigQuery, AWS Redshift, Databricks).

Strong knowledge of SQL, PL / SQL, proficiency and ability to review data mappings.

Familiarity with data governance tools (Collibra, Alation, Informatica, Atlan).

Understanding of metadata management, lineage, and cataloging principles.