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