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.