Data Modeler

TVH Group

Pune District

On-site

INR 1,400,000 - 2,400,000

Full time

14 days+

Get a reply from this employer

Your resume and cover letter, tailored to exactly what they’re hiring for.

Get past ATS filters

Job summary

TVH Group is seeking a Data Modeler to design and maintain enterprise Logical and Physical Data Models across multiple domains, including customer, supplier, item, product, and finance. You will translate cross-domain requirements into scalable data structures and ensure alignment with business realities while optimizing performance.

You will collaborate with Domain Architects, Data Engineers, and Data Stewards to ensure consistency and governance, while profiling source data with SQL and

Qualifications

  • 5+ years of hands-on experience in Logical/Physical Data Modeling across multiple domains.
  • Expertise in Relational/3NF, Dimensional Modeling, and Denormalization concepts.
  • Strong SQL for profiling, mapping, and schema validation.
  • Experience with cloud data warehouses (BigQuery, Snowflake, Databricks) and relational DB platforms.
  • Proficiency with data modeling tools (Erwin, PowerDesigner, SqlDBM).
  • Fluent in English with strong communication to stakeholders and engineers.

Responsibilities

  • Design, construct, and maintain LDMs and PDMs across enterprise domains.
  • Translate requirements into normalized, scalable data structures.
  • Translate LDMs into optimized PDMs for target databases.
  • Collaborate with Domain Architects, Data Engineers, and Data Stewards.
  • Profile source data with SQL and optimize schemas for cloud warehouses.

Skills

SQL proficiency
English communication
Data modeling
Analytical thinking

Tools

Erwin
PowerDesigner
SqlDBM
BigQuery
Snowflake
Databricks

Job description

About the RoleAs a Data Modeler at TVH, you will play a central role in shaping how our global organization structures, understands, and leverages its data. Operating across all core business domains (e.g., Customer, Supplier, Item, Product, Equipment, HR, Finance, Commercial, Operations, ...), you will design, develop, and maintain high-performing Logical Data Models (LDM) and Physical Data Models (PDM) that power enterprise reporting, analytics, and operational applications.You will translate diverse cross-domain business requirements into clear, standardized, and scalable data structures. Working closely with Domain Architects, Data Engineers, and Data Stewards, you will ensure our logical abstractions align perfectly with business reality while our physical implementations maximize database performance and data accessibility.Key Responsibilities* Enterprise Logical & Physical Data Model Design: + Design, construct, and maintain normalized Conceptual and Logical Data Models (LDM) across all enterprise domains, establishing clear entities, attributes, relationships, and business definitions. + Translate LDMs into optimized Physical Data Models (PDM) tailored for target database platforms, balancing storage efficiency, index strategies, and query performance. + Reverse-engineer legacy source systems and translate complex domain requirements into normalized, reusable data structures. + Produce and manage comprehensive data documentation, including ERDs (Entity-Relationship Diagrams), data dictionaries, and data mapping lineage.* Domain Alignment & Standards Governance: + Drive consistent data modeling standards, naming conventions, and design patterns across all domain modeling initiatives. + Partner with Data Governance teams to incorporate standardized business glossaries and enterprise metadata standards directly into model structures. + Conduct data model reviews with technical and business teams to ensure cross-domain consistency and avoid data duplication.* Cross-Functional Technical Collaboration: + Work hand-in-hand with Domain Architects to ensure domain models fit seamlessly into TVH’s target data architecture strategy. + Collaborate with Data Engineers to guide the physical realization of models and support optimized ETL/ELT pipeline design. + Partner with Data Analysts, Data Stewards and Business Partners to validate logical assumptions, clarify business logic, and refine domain models as needs evolve.* Model Optimization & Quality: + Profile source data using SQL to uncover structural edge cases and validate cardinality before finalizing logical designs. + Refine physical schemas for cloud data warehouses, adjusting partitioning, clustering, and denormalization strategies to meet performance SLAs.Qualifications* 5+ years of hands-on experience focused specifically on Logical Data Modeling (LDM) and Physical Data Modeling (PDM) across multiple business domains.* Deep expertise in diverse modeling paradigms: Relational/Entity-Relationship (3NF), Dimensional Modeling (Star/Snowflake), and Denormalization concepts.* Strong proficiency in SQL for deep source system profiling, data mapping, and schema validation.* Hands-on experience with modern cloud data warehouses (preferably GCP BigQuery, Snowflake, or Databricks) and relational database platforms.* Proficiency with enterprise data modeling tools (e.g., Erwin, PowerDesigner, SqlDBM, or similar).* Solid understanding of Data Warehousing principles, metadata management, and ETL/ELT architecture.* Fluent in English with excellent communication skills to articulate complex logical structures to both business stakeholders and engineering teams.Preferred Skills* Experience with Data Vault 2.0 modeling methodologies for enterprise scale.* Exposure to real-time or streaming data modeling patterns (Event-driven architectures).* Understanding of data privacy impact on data design (e.g., handling PII attributes across global domains).* Experience working in Agile/Scrum distributed software delivery teams.
Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Data Modeller
Data Modeller

Vrinda International • Chennai District

On-site
INR 350,000 - 800,000
Data Modeling
Data Modeling

Infosys • Bengaluru

On-site
INR 900,000 - 1,300,000
ERP/Analytics tooling credits
Data Modeler
Data Modeler

Durapid Technologies Pvt Ltd • Bengaluru Urban

On-site
INR 900,000 - 1,500,000
Data Platform Architect
Data Platform Architect

Waisl Ltd • Bengaluru

On-site
INR 2,500,000 - 4,000,000
Lead Data Modeler
Lead Data Modeler

EXL • Pune District, Gurugram District, Bengaluru

Hybrid
INR 2,500,000 - 4,500,000
Senior Data Modeler – Consultant
Senior Data Modeler – Consultant

Crisil • Mumbai, Pune District, Hyderabad

On-site
INR 2,400,000 - 4,200,000
Data Modeler
Data Modeler

Tech Mahindra Limited • Hyderabad, Pune District, Bengaluru

Hybrid
INR 1,200,000 - 1,800,000
Senior Data Modeler
Senior Data Modeler

Biz-metric India • Navi Mumbai, Mumbai, Gurugram District

On-site
INR 3,200,000 - 5,200,000
Data Modeler (MDM)
Data Modeler (MDM)

Navikenz • Bengaluru

On-site
INR 1,200,000 - 1,600,000
Technical Consultant-Data Modeler
Technical Consultant-Data Modeler

Titan Company • Bengaluru

Hybrid
INR 1,800,000 - 3,000,000