Data ModellerLocation : Bangalore/Mumbai. Experience : 5 - 8 Years. Joining requirement : Immediate Joiners.Key Responsibilities : - Design and develop Conceptual, Logical and Physical Data Models based on business requirements.- Build and maintain relational and dimensional data models, including Star and Snowflake schemas.- Translate business requirements into scalable data models for data warehouse and analytics platforms.- Perform source-to-target data mapping, data analysis and model validation.- Develop and maintain data dictionaries, metadata, naming conventions and modelling standards.- Work closely with Business Analysts, Data Engineers and Architects to understand data requirements and identify gaps.- Perform normalization/denormalization, entity-relationship modelling and database design.- Ensure data quality, integrity, consistency, lineage and governance across data models.- Review existing models and recommend improvements for scalability and performance.Mandatory Skills :
- 5 - 8 years of overall experience with strong hands-on Data Modelling experience.- Strong knowledge of Conceptual, Logical and Physical Data Modelling.- Strong understanding of ER modelling and dimensional modelling.- Experience with Star Schema, Snowflake Schema, fact and dimension tables.- Hands-on experience with modelling tools such as erwin, ER/Studio or Visual Paradigm.- Strong SQL knowledge.- Experience in data mapping, data dictionaries, metadata and data lineage.- Valuable understanding of Data Warehousing, ETL/ELT and database concepts.Preferred Skills : - Experience in Banking, Financial Services or Insurance (BFSI) domain.- Exposure to Snowflake/cloud data platforms.- Knowledge of Data Vault modelling is an advantage.- Understanding of data governance and data quality frameworks.- Exposure to Python would be an added advantage. (ref:hirist.tech)
📌 EY - Data Modeller (Mumbai)
🏢 EY
📍 Mumbai