Data Modeler

We're Hiring | Data Modeler | Pan India | TCS We are looking for experienced Data Modelers to join our growing team. The ideal candidate should have strong hands-on experience in conceptual, logical, and physical data modelling to support operational, analytical, reporting, AI/ML, regulatory, and business decision-making needs, with domain expertise across Banking, Insurance, and Capital Markets. Location Pan India Experience 8–15 Years Employment Type Full-time Key Responsibilities Understand business processes, KPIs, regulatory requirements, and analytical use cases. Collaborate with business stakeholders to identify entities, attributes, relationships, hierarchies, and business rules. Translate business requirements into conceptual and logical data structures. Design and maintain Conceptual (CDM), Logical (LDM), and Physical (PDM) Data Models. Build normalized (3NF) operational models and dimensional models (Star/Snowflake) for analytical environments. Design canonical enterprise models, domain-specific models, and Fact-Dimension architecture. Develop data models supporting Data Products, MDM, AI/ML, and Regulatory Reporting initiatives. Align models with enterprise data governance policies and maintain business/technical metadata and lineage. Support modernization, cloud migration programs, and performance/scalability optimisation. Mandatory Skills Conceptual, Logical, and Physical Data Modeling; ER Modeling; Dimensional Modeling; Data Vault; Canonical Modeling Data Modeling Tools — Erwin, ER/Studio, PowerDesigner, Sparx EA, or Oracle Data Modeler Data Warehouse Architecture, Data Lake, Lakehouse, Data Mart Design, ETL/ELT Concepts Advanced SQL, Data Profiling, Metadata Management, Data Lineage, Source-to-Target Mapping Strong analytical thinking, stakeholder management, and communication skills Domain expertise in Banking, Insurance, or Capital Markets Good to Have DAMA CDMP, Data Vault 2.0, TOGAF, erwin/ER-Studio Certification Cloud Data Modeling certifications from hyperscalers Regulatory and compliance awareness (AML/KYC, Risk & Compliance) Data Quality Management and MDM experience Your Next Career Opportunity Awaits! Apply now and get a faster recruitment process. Click here to apply