Futran Tech Solutions Pvt. Ltd.
Snowflake +DBT Data vault modelling
Futran Tech Solutions Pvt. Ltd., Scottsdale, Arizona, us, 85261
Job Title: Snowflake +DBT Data Vault Modelling
Location: Scottsdale, AZ (Day 1 onsite)
Duration: 6+ Months
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
Location: Scottsdale, AZ (Day 1 onsite)
Duration: 6+ Months
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