Login | Register

Senior Data Modeler with experience creating data models for Data Warehouse (DW) and Business Intelligence (BI) for our client in the travel industry

Job Type: Contract
Positions to fill: 1
Start Date: Jan 31, 2023
Job End Date: Feb 01, 2024
Pay Rate: Hourly: Negotiable
Job ID: 126648
Location: Calgary, Edmonton, Halifax, London, Montreal, Ottawa, Regina, Toronto, Vancouver, Victoria, Winnipeg
Apply
Our client is seeking a senior Data Modeler with experience creating data models for Data Warehouse (DW) and Business Intelligence (BI) 

Duration is 1 year, 100% remote work

Overview
The Data Modeler will Create data models for Data Warehouse (DW) and Business Intelligence (BI). Consultant  will Translate business needs and data questions into project or enhancement requirements and will Facilitate and/or participate in agile sessions to assess, capture, and translate complex business issues and requirements into structured data architecture and data modeling use case requirements.

Must Haves
  • Experience building enterprise grade data models.  
  • Experience with relational modeling, domain modeling,and dimensional modeling.
  • Experience in Data Vault 2.0 Modeling.
  • Experience with metadata management and its use for modeling activities.  
  • Experience with creating data model and data structure in Erwin Modeling.  
  • 5+ years of experience using the following modeling techniques: 3rd Normal form, ERD, Dimensional modelling (Star Schema)  
  • 5+ years of experience with data management standards and data model practices.  
  • Thorough knowledge of conceptual and logical data modeling and familiarity with physical database design and optimization concepts.
  • Experience with common standards and best practices for data elements, data types, and file formats.  
  • Experience working with Agile Methodology  
  • Data analysis/profiling and reverse engineering of data
  • Strong knowledge of relational and multi-dimensional database architectures.
  • Must have Knowledge of SQL   
  • Strong Communication skills, Oral and Written 

Responsibilities

Hold conceptual and logical data model reviews with product managers/data subject matter experts.
Must be able to abstract general principles from specifics and conceptualize and design data model.
Develop, enhance, and manage conceptual data model, enterprise logical data model (LDM), physical data model (PDM) for the data platform.  
Ensure data lineage mapping across implementations for the platform.  
Understand and meet referential data integrity requirements based on business needs.
Develop and/or assist in generating source to target data mapping.
Perform data model consolidation and integration to integrate new silos of organizations source data to the data platform.  
Understand and apply logical entity-relational design concepts.
Develop dimensional models and views needed for data analytics and reporting.
Develop data models and data migration strategies utilizing best practice concepts of data modeling including star schema, snowflake schema, Vault 2.0
Provide architectural help to development teams, and provide technical guidance and leadership to all internal and external teams involved in the implementation