Data modeler

Berribot · Bengaluru, India

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 (3 NF) 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, Power Designer, 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