Job 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.

The Analyst, Data & Analytics - Data Modeler must be an excellent communicator, both written and verbal, and have experience working with business areas to translate their business data needs and data questions into project or enhancement requirements. The incumbent must have a solid background in Data Analysis as well as on the job experience as a data modeler. This position provides the opportunity to be involved in new BI and DW solutions, such as Dashboards and Reports, Big Data Solutions and to work with many different business areas within the company. The candidate will participate in all phases of the BI/DW development life cycle as well as support the day-to-day operations as it pertains to data modeling improvements and supporting the existing platform. The candidate will own the Enterprise Data Model.

He/She must have solid data modeling experience and must demonstrate an affinity for working with others to create successful Business Intelligence (BI) and Data Warehouse (DW) solutions.

Responsibilities:

• 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.
  
• 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 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, etc.
  
• Build model aggregation layers and specific star schemas as subject areas within a logical and physical model.
  

Qualifications

• University degree in computer science or in similar fields or relevant experience
  
• Experience building and managing enterprise grade data models.
  
• Experience with relational modeling, domain modeling, Data Vault modeling  and dimensional modeling.
  
• Experience with metadata management and its use for modeling activities.
  
• Experience with creating data model and data structure in Teradata, SQL Server, PostgreSQL, or other using ER/Studio DA or 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.
  
• Ability to conceive and describe the big picture.
  
• Strong quantitative and analytic skills.
  
• Proven ability to quickly work with multiple key stakeholders.
  
• Able to steer through a large corporate environment and ensure appropriate organizational data processes are met.
  
• Data analysis/profiling and reverse engineering of data. Strong knowledge of relational and multi-dimensional database architectures.
  
• Excellent interpersonal skills
  
• Strong Communication skills, Oral and Written
  
• Knowledge of SQL
  
• Mandatory Covid-19 Vaccination Required as of October 31st 2021
  

Conditions of Employment:

• Candidates must be eligible to work in the country of interest, at the time any offer of employment is made and seeking any required work permits/visas or other authorizations which may be required is the sole responsibility of the candidates applying for this position.
  

Linguistic Requirements

Based on equal qualifications, preference will be given to bilingual candidates.