Key Responsibilities
Analyse existing enterprise data models, databases, schemas and data warehouses.
Develop conceptual, logical and physical data models.
Design dimensional models, including fact and dimension tables.
Define business rules, keys, relationships and historical data requirements.
Create detailed source-to-target mappings.
Analyse data dependencies, lineage and transformation requirements.
Support large-scale data migration and data validation activities.
Work closely with Data Architects, Data Engineers, Business Analysts and BI teams.
Conduct data-modelling/discovery workshops with client stakeholders.
Support client onboarding and independently drive modelling deliverables.
Ensure target data models are scalable and aligned with enterprise standards.

Required Skills
12–15 years of overall experience,



with solid experience in Data Modelling/Data Warehousing.
Robust experience in enterprise data modelling.
Experience with large-scale data migration projects.
Robust SQL and data warehousing knowledge.
Strong conceptual, logical, physical and dimensional modelling experience.
Knowledge of Star/Snowflake schemas and SCD Type 1/Type 2.
Strong source-to-target mapping experience.
Experience working with large and complex datasets.
Strong communication and client-facing skills.
Experience working with Data Architects and Data Engineering teams.

Pay: ₹3,057,444.24 - ₹4,883,732.18 per year

Work Location: In person

📌 Data Modeler Pune (India)
🏢 Wishtree Technologies
📍 India