Overview

No. of Positions: 02

Experience: 10+ Years

Work Mode: Hybrid – 2 days/week from office is mandatory

Work Locations: Bangalore, Hyderabad, Chennai, Mumbai, Ahmedabad, Pune & Coimbatore

Notice Period: Immediate Joiners Only

Role Summary: We are looking for an experienced Senior Data Modeler with strong expertise in enterprise data modeling, data architecture, data warehousing, and data governance. The candidate will work with business, architecture, engineering, and analytics teams to design scalable data models aligned with enterprise requirements. Insurance or Financial Services domain experience is mandatory.

Key Responsibilities

• Design and maintain Conceptual, Logical & Physical Data Models.
• Develop enterprise and domain-level data models.
• Translate business requirements into scalable data structures.
• Define entities, attributes, relationships, keys, and business rules.
• Perform source-to-target mapping and support data integration initiatives.
• Design data models for Data Warehouse, Data Lake/Lakehouse, and cloud platforms.
• Maintain data dictionaries, metadata, business glossary, and data lineage.
• Collaborate with Data Architects, Data Engineers, BI, and business teams.
• Ensure data modeling standards, quality, consistency, and governance.
• Review and optimize data models for scalability and performance.

Mandatory Skills

• Conceptual, Logical & Physical Data Modeling
• Enterprise Data Modeling
• Data Warehousing & Dimensional Modeling
• Advanced SQL
• Data Architecture
• Data Governance & Metadata Management
• Data Lineage & Source-to-Target Mapping
• Relational Database concepts
• Erwin / ER Studio / PowerDesigner or similar tools
• Snowflake / Databricks / Azure Synapse / AWS / Azure / GCP

Mandatory Domain Experience

Insurance: Claims, FNOL, Policy Administration, Underwriting, Coverage, Premium/Rating, Reinsurance, Fraud, Customer 360, etc.

OR

Financial Services: Banking, Lending, Payments, Capital Markets, Wealth Management, Risk, AML/KYC, Regulatory Reporting, Treasury, etc.

Good to Have

• Data Vault
• MDM
• Collibra / Informatica / Microsoft Purview
• AI/ML or GenAI data initiatives
• Agile/Scrum experience

Important Requirements

• Immediate Joiners Only
• 2 days/week from office is mandatory
• F2F Final Round is mandatory
• Please share only relevant profiles matching the above requirements.
• Kindly mention total experience, relevant Data Modeling experience, domain experience, current location, notice period, and expected rate while sharing profiles.