Data Architect and Information Management Specialist (36191)

Myticas Consulting

Ottawa

Hybrid

CAD 110,000 - 170,000

Full time

2 days ago
Be an early applicant

A complete application in a minute

Tailored resume and cover letter, ready to send.

Get past ATS filters

Job summary

Ottawa International Airport Authority is seeking a Data Architect and Information Management Specialist to design, build, and maintain enterprise data architecture and governance frameworks, enabling a unified, scalable data platform. This hands-on role focuses on modeling, governance, and modern data infrastructure across the enterprise.

The incumbent will develop data pipelines, establish data quality standards, and drive BI/AI readiness using Power BI and MS Fabric, collaborating with IT,

Qualifications

  • Minimum five years in data architecture or related field.
  • Experience with cloud data platforms and governance frameworks.
  • Hands-on with data models, data integration, and data quality.
  • Proficient in Power BI and MS Fabric; strong English communication.

Responsibilities

  • Design enterprise data architecture, models, and integration solutions.
  • Build and maintain scalable data pipelines and data governance.
  • Implement data catalogs, lineage, and security controls.
  • Enable analytics, BI, and AI/ML readiness across the organization.

Skills

Data architecture
Cloud platforms
ETL/ELT
Data governance

Education

University degree in Computer Science

Tools

Power BI
MS Fabric
SharePoint

Job description

Data Architect and Information Management Specialist (Power BI & MS Fabric)

Reporting to the Director, Architecture and Technology, this is a hands‑on technical role responsible for designing, building, and maintaining the organization’s enterprise data architecture and information management systems. The incumbent will directly execute the work required to establish foundational data infrastructure, governance frameworks, and platform capabilities that enable the Authority to transition from siloed, legacy data environments to a modern, unified, and scalable data platform. The Data Architect will design and build enterprise data models, implement data governance and cataloguing practices, evaluate and recommend cloud data platforms, and develop the data pipelines and integration solutions needed to support advanced analytics, business intelligence, and future artificial intelligence and machine learning initiatives. This role is a key technical contributor in positioning the Ottawa International Airport Authority as a data‑driven, next‑generation airport.

Responsibilities
Data Architecture and Platform Design
  • Conducts detailed analysis of existing source systems to assess data structure, quality, integration points, and opportunities for modernization;
  • Designs and builds the enterprise data architecture including conceptual, logical, and physical data models to support a unified, scalable data platform;
  • Evaluates and recommends cloud data platforms and modern data architectures (data lakehouse, lake-centric, open‑architecture) based on scalability, integration capabilities, cost‑effectiveness, and alignment with the Authority’s strategic vision;
  • Maps data attributes to business needs and KPIs across departments, identifying critical data required for analytics, reporting, and future AI/ML use cases;
  • Defines and documents business rules, transformation logic, validation rules, and data quality standards to ensure consistency and traceability across systems;
  • Designs and specifies the technical infrastructure (cloud, on‑premises, hybrid) including storage, compute, integration, and security components;
Data Governance and Information Management
  • Develops and implements the enterprise data governance framework, including data classification, data loss prevention policies, retention and archival standards, and access control procedures;
  • Builds and maintains the enterprise Data Catalogue to ensure comprehensive, current, and discoverable data assets across the organization;
  • Implements Master Data Management (MDM) practices to maintain a single source of truth for key business entities;
  • Configures and maintains data lineage tracking, metadata management, and data lifecycle management practices;
  • Executes document management, records management, forms integration, and document classification in compliance with regulatory requirements and best practices;
  • Implements data security, privacy, and compliance controls in accordance with applicable regulations and aviation industry standards;
  • Configures user access policies, role‑based access controls, and authentication/authorization standards for the data platform;
Data Engineering and Integration
  • Creates data engineering design documents including data flow diagrams and transformation logic;
  • Builds and maintains scalable, automated ETL/ELT data pipelines for data ingestion, transformation, and loading;
  • Develops data integration solutions that unify information from disparate airport operational systems and enterprise applications;
  • Executes the migration of data from legacy systems to modern cloud-based or hybrid platforms;
  • Builds and distributes data reports, dashboards, and self‑service analytics capabilities for internal and external stakeholders;
  • Implements data storage strategies, including digitization of legacy files and modern document management;
AI/ML Readiness and Innovation
  • Ensures data quality, integrity, and structure standards that will enable trustworthy AI and machine learning outcomes as the organization’s data capabilities mature;
  • Works with operational teams to identify and prioritize high‑value analytics and AI/ML use cases relevant to airport operations;
  • Designs data infrastructure with future capabilities in mind, including support for predictive analytics, real‑time operational intelligence, and digital twin platforms;
  • Stays current on emerging technologies and aviation industry trends — including generative AI, computer vision, biometric identity systems, and cloud‑based airport operating platforms — to advise on adoption strategies;
Planning and Stakeholder Collaboration
  • Contributes to translating business strategy into technical data architecture plans, roadmaps, and investment recommendations;
  • Assess the current state of data architecture, identifies gaps, and proposes actionable plans to achieve the desired future state;
  • Works directly with technicians, contractors, vendors, and technology partners to address data architecture and information management aspects of new initiatives;
  • Performs other duties as assigned.
Qualifications
Education

University degree in Computer Science, Data Science, Data Engineering, Information Systems, or a related discipline,

License

Valid driver’s license (Class G or equivalent)

Experience
  • Minimum of five (5) years’ progressive experience in data architecture, data engineering, or enterprise information management;
  • Demonstrated hands‑on experience designing and building enterprise data architectures, data models (conceptual, logical, physical), and data integration solutions;
  • Hands‑on experience with cloud data platforms and modern data architectures (data lakehouse, lake-centric, open‑architecture approaches) Practical experience implementing data governance frameworks, data catalogues, Master Data Management, and data quality programs;
  • Experience with SharePoint (Cloud and On‑Premises) and enterprise collaboration platforms;
  • Knowledge of emerging solutions, applications, and technologies in data management, analytics, and AI/ML;
  • Demonstrated commitment to continuous professional development
Skills
  • Strong working knowledge of database systems (relational, NoSQL), ETL/ELT processes, data warehousing, and data pipeline development;
  • Information management expertise — document management, records management, data classification, and compliance with applicable regulations;
  • Knowledge of emerging solutions, applications, and technologies in data management, analytics, and AI/ML;
  • Ability to organize complex technology solutions including deliverables, roadmaps, timelines, operational requirements, and budget impacts;
  • Excellent research skills and the ability to interpret analytical data to assess and improve information systems;
  • Strong troubleshooting, time management, and organizational skills with the ability to manage multiple priorities;
  • Strong customer service skills and professional, positive interpersonal approach;
  • Ability to work independently and as part of a collaborative team environment;
  • Excellent research skills and the ability to interpret analytical data to assess and improve information systems;
  • Advanced analytical, problem‑solving and critical thinking skills;
  • Ability to establish and maintain effective working relationships with supervisors, peers, staff, vendors, and stakeholders;
  • Excellent oral and written communication skills in English.
Assets
  • Data Science, Data Engineering, or Data Management professional certification (e.g., CDMP, cloud data platform certifications);
  • Experience with open data standards and formats (e.g., Apache Iceberg, Delta Lake, Parquet);
  • Familiarity with aviation or airport operations technology systems;
  • Experience with data visualization and BI tools (e.g., Power BI, Tableau);
  • MS Fabric expertise;
  • Knowledge of AI/ML data requirements, including feature engineering and model data lifecycle management;
  • Knowledge of Canadian data privacy regulations and cybersecurity frameworks;
  • Experience with CI/CD processes and version control for data engineering workflows; and
  • Strong knowledge of Microsoft 365 suite and enterprise productivity tools;
  • Bilingualism (English & French)
Work Environment
  • Requires flexibility to adjust work hours to respond to critical incidents, urgent issues, and organizational priorities outside of standard business hours.
  • Participation in a periodic on‑call pager support rotation is required.
  • Operates within a hybrid work model, balancing on‑site presence with remote work as operational needs dictate.
  • Functions in a fast‑paced, technology‑driven environment requiring extensive hands‑on technical expertise in data architecture, information management, data governance, and emerging data and analytics technologies.
Equal Opportunity Employer

The Authority is committed to the principles of Employment Equity and to achieving a workforce that is representative of the diversity of the Canadian population. We strongly encourage candidates to self‑identify if they are Indigenous peoples, persons with disabilities, or members of visible minorities.,

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Manager, Business Information & Analytics
Manager, Business Information & Analytics

Altis • Ottawa

On-site
CAD 90,000 - 130,000
Director, Technology Architecture & Engineering
Director, Technology Architecture & Engineering

Toronto Pearson International Airport • Toronto

Hybrid
CAD 150,000 - 200,000
Comprehensive benefits with retirement
Flexible hybrid work environment
Learning and development opportunities
Manager, Data and AI - AI Systems Integrations and Agentic technical owner
Manager, Data and AI - AI Systems Integrations and Agentic technical owner

Air Canada Ltd. • Toronto

On-site
CAD 120,000 - 180,000
Data Engineer
Data Engineer

Catsa Acsta • Ottawa

On-site
CAD 90,000 - 130,000
Data Solution Architect
Data Solution Architect

Bombardier • Dorval

Hybrid
CAD 120,000 - 180,000
Insurance plans (Dental, medical)
Retirement savings plan
Employee Assistance Program
Director, HR Services, Systems and Data
Director, HR Services, Systems and Data

Toronto Pearson International Airport • Toronto

Hybrid
CAD 140,000 - 190,000
Flexible hybrid work environment
Learning & development opportunities
Reward and recognition program
Power Systems Engineer
Power Systems Engineer

Calgary Airports • Calgary

Hybrid
CAD 120,000 - 180,000
Associate Director, Software Engineering
Associate Director, Software Engineering

Toronto Pearson International Airport • Toronto

Hybrid
CAD 150,000 - 200,000
Director, IT Infrastructure & Cybersecurity
Director, IT Infrastructure & Cybersecurity

Winnipeg Airports Authority • Winnipeg

On-site
CAD 150,000 - 210,000
Health, Dental & Vision
Defined Contribution Pension Plan
Healthcare Spending Account
+4
Analyst - Data and Artificial Intelligence - Governance, Integration
Analyst - Data and Artificial Intelligence - Governance, Integration

Air Canada Ltd. • Dorval

On-site
CAD 85,000 - 120,000