Job Description

• Must have 10+ years of experience
• Primary Skill Dimensional modelling
• secondary skill snowflake Data vault modelling
• The Data Modeler will be responsible for the design development and maintenance of data models and standards for Enterprise data platforms
• Build dimensional data models applying best practices and providing business insights
• Build data warehouse data marts on Cloud while performing data profiling and quality analysis
• Identify business needs and translate business requirements to Conceptual Logical Physical and semantic
• multidimensional star snowflake normalized denormalized Data Vault20 model for the project
• Knowledge of snowflake and dbt is added advantage
• Create and maintain the Source to Target Data Mapping document for this project Includes documentation of all entities
• attributes data relationships primary and foreign key structures allowed values codes business rules glossary terms etc
• Develop best practices for standard naming conventions and coding practices to ensure consistency of data models
• Gather and Publish Data Dictionaries Maintain data models and capture data models from existing databases and record descriptive information
• Work with the Development team to implement data strategies build data flows and develop conceptual data models
• Create logical and physical data models using best practices to ensure high data quality and reduced redundancy
• Optimize and update logical and physical data models to support new and existing projects
• Data profiling business domain modelling logical data modelling physical dimensional data modelling and design
• Data design and performance optimization for large Data Warehouse solutions
• understanding data profile and analysis metadata formats definitions valid values boundaries relation shipusage
• Create relational and dimensional structures for large multiterabyte operational analytical warehouse and BI systems
• Should be good in verbal and written communication

Job Tags

Similar Jobs