About the role
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 candidate must have strong data modeling and data architecture experience and demonstrate the ability to work collaboratively with both technical and business stakeholders to deliver enterprise grade data solutions. This role combines hands on data modeling, architectural contribution, and leadership responsibilities.
The individual will work across multiple data modeling methodologies, including Integration Data Modeling, Dimensional Modeling, and Data Vault 2.0, and will contribute to the design and evolution of Data Warehouse (DW), Business Intelligence (BI), and cloud based analytics solutions. The role requires excellent written and verbal communication skills, the ability to translate business requirements into structured data models, and experience working in project and agile environments.
The candidate will participate in all phases of the DW / BI development lifecycle, support day to day operations related to data modeling and data architecture and ensure compliance with enterprise data modeling standards. In addition, the role includes mentoring, standards stewardship, and collaboration with architects, developers, DBAs, and business partners across the organization.
Responsibilities:
- Participate in and facilitate agile and project sessions to assess, capture, and translate complex business requirements into data architecture and data modeling solutions.
- Develop, enhance, and maintain conceptual, logical, and physical data models (including dimensional and integration models) to support enterprise data platforms.
- Design and maintain dimensional models, star schemas, snowflake schemas, and Data Vault structures to support analytics, dashboards, and reporting needs.
- Perform data model consolidation and integration to onboard new data sources and eliminate data silos.
- Ensure referential integrity, data lineage, and source to target mappings are properly defined and aligned with business needs.
- Conduct conceptual and logical data model reviews with product managers, data subject matter experts, and technical stakeholders.
- Create and maintain solution design and architecture documentation, including architecture overviews, detailed designs, and architectural decision records.
- Present and socialize proposed solutions to technical review boards and communicate designs to both technical and non technical audiences.
- Support implementation efforts by providing architectural guidance and hands on support to internal and external development teams.
- Ensure enterprise data standards, conformed dimensions, and referential datasets are applied consistently across projects.
- Maintain and evolve data modeling standards, methodologies, and best practices.
- Set up, maintain, and upgrade data modeling tools (e.g., ERWIN), including onboarding new users and managing licensing and vendor interactions.
- Collaborate with enterprise architecture and governance teams to influence and adopt emerging data modeling trends and practices.
- Participate in data governance activities related to data quality, metadata management, and information management.
- Provide technical ability to provide mentorship, and guidance to other data modelers to ensure consistency, quality, and standards adherence.
Qualifications
- University degree in computer science, information systems, or a related field, or equivalent relevant experience.
- 3+ years of experience using data modeling techniques such as 3rd Normal Form, ERD, and dimensional modeling (star and snowflake schemas).
- 3+ years of experience applying data management standards and data modeling best practices.
- Proven experience building enterprise grade data models in complex environments.
- Strong experience with relational, domain, dimensional, and integration data modeling methodologies.
- Hands on experience with Data Vault 2.0 modeling.
- Experience with metadata management and its application to data modeling and governance.
- Strong proficiency in ERWIN or similar data modeling tools.
- Thorough knowledge of conceptual and logical data modeling, with familiarity in physical database design and optimization concepts.
- Experience defining common standards for data elements, data types, and file formats.
- Strong data analysis, data profiling, and reverse engineering skills.
- Ability to abstract from detailed requirements to design scalable, enterprise level data solutions.
- Proven ability to collaborate effectively with multiple stakeholders across business and technical teams.
- Strong quantitative, analytical, and problem solving skills.
- Excellent interpersonal and communication skills (written and verbal).
- Working knowledge of SQL for data analysis and data dictionary exploration.
- Prior experience mentoring data modelers and ensuring adherence to enterprise standards is an asset.
- Demonstrate punctuality and dependability to support overall team success in a fast-paced environment.
Conditions of Employment:
Candidates must be eligible to work in the country of interest at the time any offer of employment is made and are responsible for obtaining any required work permits, visas, or other authorizations necessary for employment. Prior to their start date, candidates will also need to provide proof of their eligibility to work in the country of interest.
Linguistic Requirements
Based on equal qualifications, preference will be given to bilingual candidates.
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.
As an equal opportunity employer, we welcome applications from all to help us build a diverse workforce which reflects the diversity of our customers, and communities, in which we live and serve.
Air Canada thanks all candidates for their interest; however only those selected to continue in the process will be contacted.
Not the right fit? Search for Data and AI Data Modeler jobs in Toronto, ON
About Air Canada
Canada's largest airline, the country’s flag carrier and a founding member of Star Alliance, the world's most comprehensive air transportation network celebrating its 25thanniversary in 2022, Air Canada provides scheduled passenger service directly to 51 airports in Canada, 51 in the United States and 86 internationally. It is the only international network carrier in North America to receive a Four-Star ranking from Skytrax, which in 2021 gave Air Canada awards for the Best Airline Staff in North America, Best Airline Staff in Canada, Best Business Class Lounge in North America, and an excellence award for its management of the COVID-19 pandemic.
**
Air Canada est la plus importante société aérienne du Canada, le transporteur national du pays et un membre cofondateur du réseau Star Alliance — le plus vaste regroupement mondial de sociétés aériennes, qui célèbre son 25e anniversaire en 2022. Les lignes passagers régulières d’Air Canada relient sans escale 51 aéroports au Canada, 51 aux États-Unis et 86 sur le reste du globe. En Amérique du Nord, Air Canada constitue le seul transporteur aérien d’envergure internationale offrant une gamme complète de services à détenir la cote quatre étoiles de Skytrax qui, en 2021, lui a décerné les prix Meilleur personnel au sol et à bord en Amérique du Nord, Meilleur personnel au sol et à bord au Canada, Meilleur salon de classe affaires en Amérique du Nord ainsi qu’un Prix d’excellence pour sa gestion de la pandémie de la COVID-19.
Similar jobs you might like
About the role
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 candidate must have strong data modeling and data architecture experience and demonstrate the ability to work collaboratively with both technical and business stakeholders to deliver enterprise grade data solutions. This role combines hands on data modeling, architectural contribution, and leadership responsibilities.
The individual will work across multiple data modeling methodologies, including Integration Data Modeling, Dimensional Modeling, and Data Vault 2.0, and will contribute to the design and evolution of Data Warehouse (DW), Business Intelligence (BI), and cloud based analytics solutions. The role requires excellent written and verbal communication skills, the ability to translate business requirements into structured data models, and experience working in project and agile environments.
The candidate will participate in all phases of the DW / BI development lifecycle, support day to day operations related to data modeling and data architecture and ensure compliance with enterprise data modeling standards. In addition, the role includes mentoring, standards stewardship, and collaboration with architects, developers, DBAs, and business partners across the organization.
Responsibilities:
- Participate in and facilitate agile and project sessions to assess, capture, and translate complex business requirements into data architecture and data modeling solutions.
- Develop, enhance, and maintain conceptual, logical, and physical data models (including dimensional and integration models) to support enterprise data platforms.
- Design and maintain dimensional models, star schemas, snowflake schemas, and Data Vault structures to support analytics, dashboards, and reporting needs.
- Perform data model consolidation and integration to onboard new data sources and eliminate data silos.
- Ensure referential integrity, data lineage, and source to target mappings are properly defined and aligned with business needs.
- Conduct conceptual and logical data model reviews with product managers, data subject matter experts, and technical stakeholders.
- Create and maintain solution design and architecture documentation, including architecture overviews, detailed designs, and architectural decision records.
- Present and socialize proposed solutions to technical review boards and communicate designs to both technical and non technical audiences.
- Support implementation efforts by providing architectural guidance and hands on support to internal and external development teams.
- Ensure enterprise data standards, conformed dimensions, and referential datasets are applied consistently across projects.
- Maintain and evolve data modeling standards, methodologies, and best practices.
- Set up, maintain, and upgrade data modeling tools (e.g., ERWIN), including onboarding new users and managing licensing and vendor interactions.
- Collaborate with enterprise architecture and governance teams to influence and adopt emerging data modeling trends and practices.
- Participate in data governance activities related to data quality, metadata management, and information management.
- Provide technical ability to provide mentorship, and guidance to other data modelers to ensure consistency, quality, and standards adherence.
Qualifications
- University degree in computer science, information systems, or a related field, or equivalent relevant experience.
- 3+ years of experience using data modeling techniques such as 3rd Normal Form, ERD, and dimensional modeling (star and snowflake schemas).
- 3+ years of experience applying data management standards and data modeling best practices.
- Proven experience building enterprise grade data models in complex environments.
- Strong experience with relational, domain, dimensional, and integration data modeling methodologies.
- Hands on experience with Data Vault 2.0 modeling.
- Experience with metadata management and its application to data modeling and governance.
- Strong proficiency in ERWIN or similar data modeling tools.
- Thorough knowledge of conceptual and logical data modeling, with familiarity in physical database design and optimization concepts.
- Experience defining common standards for data elements, data types, and file formats.
- Strong data analysis, data profiling, and reverse engineering skills.
- Ability to abstract from detailed requirements to design scalable, enterprise level data solutions.
- Proven ability to collaborate effectively with multiple stakeholders across business and technical teams.
- Strong quantitative, analytical, and problem solving skills.
- Excellent interpersonal and communication skills (written and verbal).
- Working knowledge of SQL for data analysis and data dictionary exploration.
- Prior experience mentoring data modelers and ensuring adherence to enterprise standards is an asset.
- Demonstrate punctuality and dependability to support overall team success in a fast-paced environment.
Conditions of Employment:
Candidates must be eligible to work in the country of interest at the time any offer of employment is made and are responsible for obtaining any required work permits, visas, or other authorizations necessary for employment. Prior to their start date, candidates will also need to provide proof of their eligibility to work in the country of interest.
Linguistic Requirements
Based on equal qualifications, preference will be given to bilingual candidates.
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.
As an equal opportunity employer, we welcome applications from all to help us build a diverse workforce which reflects the diversity of our customers, and communities, in which we live and serve.
Air Canada thanks all candidates for their interest; however only those selected to continue in the process will be contacted.
Not the right fit? Search for Data and AI Data Modeler jobs in Toronto, ON
About Air Canada
Canada's largest airline, the country’s flag carrier and a founding member of Star Alliance, the world's most comprehensive air transportation network celebrating its 25thanniversary in 2022, Air Canada provides scheduled passenger service directly to 51 airports in Canada, 51 in the United States and 86 internationally. It is the only international network carrier in North America to receive a Four-Star ranking from Skytrax, which in 2021 gave Air Canada awards for the Best Airline Staff in North America, Best Airline Staff in Canada, Best Business Class Lounge in North America, and an excellence award for its management of the COVID-19 pandemic.
**
Air Canada est la plus importante société aérienne du Canada, le transporteur national du pays et un membre cofondateur du réseau Star Alliance — le plus vaste regroupement mondial de sociétés aériennes, qui célèbre son 25e anniversaire en 2022. Les lignes passagers régulières d’Air Canada relient sans escale 51 aéroports au Canada, 51 aux États-Unis et 86 sur le reste du globe. En Amérique du Nord, Air Canada constitue le seul transporteur aérien d’envergure internationale offrant une gamme complète de services à détenir la cote quatre étoiles de Skytrax qui, en 2021, lui a décerné les prix Meilleur personnel au sol et à bord en Amérique du Nord, Meilleur personnel au sol et à bord au Canada, Meilleur salon de classe affaires en Amérique du Nord ainsi qu’un Prix d’excellence pour sa gestion de la pandémie de la COVID-19.