Data Architect and Information Management Specialist (36191)
- Ottawa, ON, Canada
Full-time
Applications open in a new tab.
Job details
- Job type
- Full-time
- Apply by
- Posting language
- English
- Posted
Original job description
Data Architect and Information Management Specialist (Power BI & MS Fabric)
Position Overview
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
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
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.
,
Position Overview
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;
- 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;
- 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;
- 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;
- Contributes to translating business strategy into technical data architecture plans, roadmaps, and investment recommendations;
- Assesses 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.
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
- 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.
- 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)
- 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.
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.
,
More about this job
Responsibilities
Design, build, and maintain the enterprise data architecture, governance framework, catalogue, and scalable data platform, including data models, integrations, and automated pipelines. Lead information management and data security practices while enabling analytics, reporting, and future AI/ML capabilities in collaboration with operational teams and technology partners.
Requirements
Requires a university degree in Computer Science, Data Science, Data Engineering, Information Systems, or a related discipline, a valid driver’s license, and at least five years of progressive experience in data architecture, data engineering, or enterprise information management. Candidates should have hands-on experience with enterprise data models, cloud data platforms, governance, catalogues, MDM, data quality, SharePoint, and data integration, along with strong analytical, communication, and collaboration skills.
Skills
- Data Architecture
- Data Modeling
- Data Engineering
- Data Governance
- Data Cataloguing
- Master Data Management
- ETL/ELT Pipelines
- Data Integration
- Cloud Data Platforms
- Microsoft Fabric
- Power BI
- SharePoint
- Information Management
- Data Quality
- Data Security and Privacy
- AI/ML Readiness
Visa sponsorship
Not detected in the job text
Categories
- Data & Analytics
- Technology
- Software
- Transportation
Keywords
- Enterprise Data Architecture
- Conceptual Data Models
- Logical Data Models
- Physical Data Models
- Microsoft Fabric
- Power BI
- SharePoint
- Cloud Data Platforms
- Data Lakehouse
- Open Architecture
- Data Governance
- Data Catalogue
- Master Data Management
- Metadata Management
- Data Lineage
- Data Lifecycle Management
- ETL/ELT
- Data Pipelines
- Data Warehousing
- Relational Databases
- NoSQL
- Document Management
- Records Management
- Data Classification
- Data Quality
- Role-Based Access Control
- AI/ML
- Apache Iceberg
- Delta Lake
- Parquet