Data Modeler

TVH; Pune District; On-site; INR 1,200,000 - 1,800,000; Full time

Benefits offered by this job

Medical Insurance

Dental Insurance

Vision Insurance

401(k) match up to 6%

On-site preschool

On-site restaurant

Job summary

TVH is seeking a Data Modeler to design and maintain enterprise data models across all core domains. You will translate business requirements into standardized data structures and collaborate with domain architects and engineers to optimize performance and accessibility.

Ideal candidates have 5+ years in LDM/PDM, strong SQL skills, and hands-on experience with cloud data warehouses (BigQuery, Snowflake, Databricks) and modeling tools like Erwin or PowerDesigner. Fluency in English required.

Qualifications

• Bachelor’s degree in Computer Science or a related field.
• 5+ years of hands-on experience in Logical Data Modeling (LDM) and Physical Data Modeling (PDM).
• Strong SQL proficiency for profiling, mapping, and validation.
• Experience with cloud data warehouses (GCP BigQuery, Snowflake, Databricks) and relational databases.
• Proficiency with data modeling tools such as Erwin, PowerDesigner, or SqlDBM.

Responsibilities

• Design, construct, and maintain LDM and PDM across multiple domains.
• Translate cross-domain business requirements into scalable data structures.
• Collaborate with Domain Architects, Data Engineers, and Data Stewards.
• Profile source data using SQL and optimize schemas for performance.
• Lead governance of modeling standards and metadata management.

Skills

SQL

Data modeling

LDM/PDM

Cloud data warehouses

Erwin

PowerDesigner

SqlDBM

Databricks

BigQuery

Snowflake

Education

Bachelor's degree in CS or related field

Tools

Erwin

PowerDesigner

SqlDBM

BigQuery

Snowflake

Databricks

Job description

Data Modeler

About the Role

As 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.

WHAT’S IN IT FOR YOU

You’ll be part of a people-centric culture, where your well-being matters. Our comprehensive package offers standard benefits such as medical, dental, and vision, plus unique benefits such as our onsite health clinic and our incredible dollar for dollar 401(k) match up to 6%. At our HQ, there’s an on-site preschool, restaurant and where you can get active or enjoy our regular team get-togethers.

PEOPLE ARE AT OUR HEART

TVH is a global business with a family atmosphere, where people are at the center. We value clarity, mutual respect, kindness and open communication. Our people are down-to-earth, easy to work and engage with. We welcome differences and celebrate new ideas.

ABOUT TVH

TVH is a parts specialist for quality parts and accessories for material handling, industrial vehicles, and construction and agricultural equipment. Working at TVH is opting for a company that excels as an international market leader and is well-known for its unstoppable craving for innovation.