Data Modeler, Data - Dorval, Canada - Air Canada

Air Canada

Verified Company

Dorval, Canada

1 week ago

Posted by:

Sophia Lee

beBee Recruiter

Description

Description

Being part of Air Canada is to become part of an iconic Canadian symbol, recently ranked the best Airline in North America. Let your career take flight by joining our diverse and vibrant team at the leading edge of passenger aviation.

Responsibilities:

Develop dimensional models and views needed for data analytics and reporting.
Perform data model consolidation and integration to integrate new silos of organizations source data to the data platform.

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.

Evaluate and extract the general principles from specifics and conceptualize and design data model.

Collaborate with the Data Analyst in the elaboration of the "Source to Target" mapping.
Develop, enhance, and manage conceptual data models, enterprise logical data models (LDM) and, physical data model (PDM) for the data platform.
Ensure data lineage mapping across implementations for the platform.
Analyse and meet referential data integrity requirements based on business needs.
Develop and/or assist in generating source to target data mapping.

Develop and maintain fully defined conceptual, logical and physical dimensional data models to ensure the information models are capable of meeting end user and developer needs.

Develop data models and data migration strategies utilizing best practice concepts of data modeling including star schema, snowflake schema, Vault etc.

Qualifications

Bachelor's degree in computer science, information technology or a similar field.
Experience building enterprise grade data models cross platforms.
5+ years of experience using the following modeling techniques: 3rd Normal form, ERD, Dimensional modelling (Star Schema / Snowflake Schema)
5+ years of experience with data management standards and data model practices.
Experience with relational modeling, domain modeling, and dimensional modeling as well as accompanying supporting documents.
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.
Thorough knowledge of conceptual and logical data modeling and familiarity with physical database design and optimization concepts.
Strong knowledge of common standards and best practices for data elements, data types, and file formats.
Ability to conceive and describe the big picture.
Solid analytical and strong problemsolving skills
Proven ability to quickly work with multiple key stakeholders, and ability to focus on crossgroup collaboration.
Data analysis/profiling and reverse engineering of data. Strong knowledge of relational and multidimensional database architectures.
Excellent interpersonal skills
Strong Communication skills, Oral and Written
Knowledge of SQL
Working knowledge of both Waterfall and Agile development methodologies.
Data quality processing experience in transportation industry, an asset.

Conditions of Employment:

Linguistic Requirements

Diversity and Inclusion

Air Canada is strongly committed to Diversity and Inclusion and aims to create a healthy, accessible and rewarding work environment which highlights employees' unique contributions to our company's success.