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 strong experience in Data Modelling/Data Warehousing.
Strong experience in enterprise data modelling.
Experience with large-scale data migration projects.
Strong SQL and data warehousing knowledge.
Robust conceptual, logical, physical and dimensional modelling experience.
Knowledge of Star/Snowflake schemas and SCD Type 1/Type 2.
Solid source-to-target mapping experience.
Experience working with large and complex datasets.
Solid 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 Redshift To Databricks Pune
🏢 Wishtree Technologies
📍 Pune