Snowflake DBT Data vault modelling

Job Title: Snowflake DBT Data vault modelling Location: Scottdale, AZ [ (Day one Onsite) Job Description: 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 normalizeddenormalized 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 relationshipusage Create relational and dimensional structures for large multiterabyte operational analytical warehouse and BI systems Should be good in verbal and written communication"