Posted:1 day ago|
Platform:
On-site
Full Time
Role Context
Own conceptual/logical/physical modelling for key domains, ensuring semantics, integrity, and performance. Enables consistent ETL implementation and supports analytics and ML-friendly structures.
Key Responsibilities
Create 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 Have
8–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 Have
Exposure to Data Vault 2.0 modelling.
Experience modelling customer/marketing/event-driven domains.
Familiarity with feature-store-friendly modelling patterns
HCLSoftware
Upload Resume
Drag or click to upload
Your data is secure with us, protected by advanced encryption.
Browse through a variety of job opportunities tailored to your skills and preferences. Filter by location, experience, salary, and more to find your perfect fit.
We have sent an OTP to your contact. Please enter it below to verify.
Instantly access job listings, apply easily, and track applications.
hyderabad
10.0 - 15.0 Lacs P.A.
pune, maharashtra, india
Salary: Not disclosed
bengaluru
5.0 - 10.0 Lacs P.A.
hyderabad, pune, bengaluru
0.5 - 3.0 Lacs P.A.
hyderabad
10.0 - 15.0 Lacs P.A.
bengaluru
10.0 - 12.0 Lacs P.A.
hyderabad
10.0 - 12.0 Lacs P.A.
chennai
10.0 - 12.0 Lacs P.A.
pune
10.0 - 12.0 Lacs P.A.
hyderabad
10.0 - 15.0 Lacs P.A.
