19 Nov
|
Myticas Consulting
|
Canada
19 Nov
Myticas Consulting
Canada
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 up-to-date, 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.ResponsibilitiesData 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 datasecurity, privacy, and compliance controls in accordance with applicable regulations and aviation industry standards;
- Configures useraccess 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 datastorage 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 t
📌 Data Architect And Information Management Specialist (Canada)
🏢 Myticas Consulting
📍 Canada