IN.JobDiagnosis logo

Job Title:

Data Modeller

Company: HCLSoftware

Location: Pune, Maharashtra

Created: 2026-01-04

Job Type: Full Time

Job Description:

Role ContextOwn conceptual/logical/physical modelling for key domains, ensuring semantics, integrity, and performance. Enables consistent ETL implementation and supports analytics and ML-friendly structures.Key ResponsibilitiesCreate and maintain conceptual, logical, and physical data models.Define canonical structures, keys, grain, relationships, reference/master data conventions.Ensure time semantics are explicitly modelled (event_time vs process_time, snapshot dates).Provide model-driven guidance to ETL teams and validate transformation logic alignment.Maintain data dictionary, naming standards, domain glossary, and change impact analysis.Ensure models support analytics reporting and ML feature derivation (events, snapshots, aggregates).Must Have8–12 years in data modelling / data architecture with strong delivery alignment.Expertise in 3NF and dimensional modelling; canonical modelling experience preferred.Strong SQL profiling and validation capability.Cloud warehouse modelling experience (Snowflake/BigQuery/Redshift/Synapse).Strong understanding of SCD, temporal modelling, surrogate keys, and conformed dimensions.Non-technical: stakeholder communication, documentation quality, conflict resolution on definitions.Good To HaveExposure to Data Vault 2.0 modelling.Experience modelling customer/marketing/event-driven domains.Familiarity with feature-store-friendly modelling patterns

Apply Now

➤
Home | Contact Us | Privacy Policy | Terms & Conditions | Unsubscribe | Popular Job Searches
Use of our Website constitutes acceptance of our Terms & Conditions and Privacy Policies.
Copyright © 2005 to 2026 [VHMnetwork LLC] All rights reserved. Design, Develop and Maintained by NextGen TechEdge Solutions Pvt. Ltd.