Data and AI Data Modeler

Air Canada • Montreal, QC

1d

About The Position

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.

Requirements

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

Nice To Haves

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

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.

Benefits

• 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.
• Based on equal qualifications, preference will be given to bilingual candidates.
• 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.

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level
• Education Level: Associate degree