Data Engineer

Canadian Air Transport Security Authority

Ottawa

On-site

CAD 90,000 - 130,000

Full time

9 days ago

A complete application in a minute

Tailored resume and cover letter, ready to send.

Get past ATS filters

Job summary

Canadian Air Transport Security Authority (CATSA) invites applications for a Data Engineer in Ottawa. The role focuses on data engineering, ETL development, and Power Platform solutions to support strategic data initiatives and performance dashboards.

The successful candidate will have 3+ years of SQL experience, proficiency with Power BI/PowerApps/Power Automate, and experience with data lakes or data marts in a hybrid cloud/on-premises environment.

Qualifications

  • Graduation from a recognized university with a specialization in Computer Science, Information Technology/Management, or another specialty relevant to the duties of the position, or an equivalent combination of education and experience.
  • A minimum of three years (3) of experience with advanced Structured Query Language (SQL).
  • Minimum three years (3) of experience in development using Microsoft Power Platform tools (PowerApps, Power Automate, Power BI).
  • A minimum two years (2) of experience using ETL/data engineering tools (e.g., Microsoft SSIS, IBM DataStage, Informatica, Azure data factory, Microsoft Fabric, Azure Synapse etc.) for the creation and implementation of data marts, data lakes.

Responsibilities

  • Design and create interactive dashboards and reports using Power BI to provide data-driven insights and facilitate decision-making.
  • Develop custom applications using PowerApps to meet specific business requirements.
  • Automate business workflows using Power Automate to enhance operational efficiency and reduce manual tasks.
  • Design, develop, and maintain scalable and efficient data pipelines support data integration, processing, and analytics.
  • Implement and manage ETL (Extract, Transform, Load) processes to ensure data quality and reliability across multiple data sources.

Skills

SQL
Analytical thinking
Communication
Teamwork/independence
Data modeling

Education

Bachelor's degree in Computer Science/IT or related field

Tools

PowerApps
Power Automate
Power BI
SQL Server
SSIS
Azure Synapse
Azure Data Factory

Job description

The Canadian Air Transport Security Authority (CATSA) has 1 (one) exciting determinate opportunity up to April 23, 2027 within the Technology branch at the CATSA HQ. This position represents an opportunity for career-driven individuals seeking a position within an organization that inspires growth and promotes excellence to make a difference and contribute to CATSA’s unique culture as it strives to excel in air transport security.

Why is CATSA a great fit for you?

CATSA is a world leader in aviation security, mandated to protect the public by delivering security screening operations at 89 designated airports across Canada. As a Crown corporation, CATSA is accountable to Parliament through the Minister of Transport. We champion innovation and creativity and offer a welcoming and inclusive workplace where employees can be their true selves and take pride in being part of a mission that matters.

Summary of responsibilities:

The Data Engineer is responsible for analyzing, developing, implementing, and supporting CATSA’s business data solutions such as data engineering, Extract, Transform, Load (ETL) development, Power platform (Power BI, PowerApps, Power Automate) development, Artificial Intelligence (AIOps)/Machine Learning (MLOps) Operations. The Data Engineer performs all other duties and responsibilities related to the position as required.

Key Tasks and Responsibilities:
  • Design and create interactive dashboards and reports using Power BI to provide data-driven insights and facilitate decision-making.
  • Develop custom applications using PowerApps to meet specific business requirements.
  • Automate business workflows using Power Automate to enhance operational efficiency and reduce manual tasks.
  • Design, develop, and maintain scalable and efficient data pipelines support data integration, processing, and analytics.
  • Implement and manage ETL (Extract, Transform, Load) processes to ensure data quality and reliability across multiple data sources.
What you need to succeed
  • Graduation from a recognized university with a specialization in Computer Science, Information Technology/Management, or another specialty relevant to the duties of the position, or an equivalent combination of education and experience.
  • A minimum of three years (3) of experience with advanced Structured Query Language (SQL).
  • Minimum three years (3) of experience in development using Microsoft Power Platform tools (PowerApps, Power Automate, Power BI).
  • A minimum two years (2) of experience using ETL/data engineering tools (e.g., Microsoft SSIS, IBM DataStage, Informatica, Azure data factory, Microsoft Fabric, Azure Synapse etc.) for the creation and implementation of data marts, data lakes.
This position is best suited to individuals with the following skills and abilities:

Strong client service orientation. Ability to communicate effectively orally and in writing; ability to tailor communications to suit the audience. Strong analytical and critical thinking skills. Ability to understand client needs and articulate solutions. Ability to troubleshoot, to think creatively and to problem-solve. Ability to work in a team environment or independently. Ability to multitask and prioritize, strong organizational skills.

Valuable skills include:
  • Knowledge of CATSA's mandate and priorities, as well as an awareness of relevant legislation impacting CATSA.
  • Knowledge of data modeling, data analysis, programming technologies (e.g., Python), statistical concepts and techniques.
  • Knowledge of development in a hybrid cloud and on-premises environment
  • Experience in programming languages such as Python, Java, .Net or C#.
  • Experience in Artificial Intelligence (AI) development (Microsoft AI foundry, Agent creation)
  • Experience in Data administration/security/Governance
  • Experience in data lake architecture and data pipelines.
  • Understanding of DevOps practices and tools, including CI/CD pipelines.
  • Proven experience in providing user training and support on Microsoft Power Platform solutions.
Microsoft Certified: Azure AI Engineer Associate.
  • Microsoft Certified Azure Data Engineer Associate.
  • Microsoft Certified: Power Platform Developer Associate desired.
Specific work requirements:

Language Profile: English essential; Ability to obtain and maintain a Secret security clearance;

Additional information:

Please note that candidates that meet all the position requirements, including the language profile, will be given first consideration however, we invite all interested candidates to submit their applications; While we appreciate all the candidates’ interest, only those being considered in the process will be contacted; CATSA will use this opportunity to establish a candidate pool that may be used to staff permanent or fixed-term positions with similar responsibilities and qualifications;

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Data Engineer
Data Engineer

Catsa Acsta • Ottawa

On-site
CAD 90,000 - 130,000
Data Engineer: Power Platform & ETL Expert
Data Engineer: Power Platform & ETL Expert

Canadian Air Transport Security Authority • Ottawa

On-site
CAD 90,000 - 130,000
Data Engineer: Power BI, ETL & AI Ops Specialist
Data Engineer: Power BI, ETL & AI Ops Specialist

Catsa Acsta • Ottawa

On-site
CAD 90,000 - 130,000
Data Architect and Information Management Specialist (36191)
Data Architect and Information Management Specialist (36191)

Myticas Consulting • Ottawa

Hybrid
CAD 110,000 - 170,000
Onsite Desktop Support
Onsite Desktop Support

Compugen Inc • Ottawa

On-site
CAD 55,000 - 75,000
Data Engineer
Data Engineer

Thales Group • Ottawa

Hybrid
CAD 90,000 - 135,000
Extended health and dental
Retirement savings plans
Paid holidays and vacation
+1
Cyber Implementation Specialist-EN
Cyber Implementation Specialist-EN

CAE • Ottawa

Hybrid
CAD 91,000 - 136,000
Benefits plan
Pension plan
Stock purchase plan
+3
Senior Cyber Security Engineer
Senior Cyber Security Engineer

CAAT Pension • Toronto

On-site
CAD 126,000 - 157,000
Total Rewards program
Pension plan
Flexible work arrangements
Senior Manager, Cybersecurity Operations & Vulnerability Management
Senior Manager, Cybersecurity Operations & Vulnerability Management

CAAT Pension Plan • Canada

On-site
CAD 151,000 - 189,000
Manager, Business Information & Analytics
Manager, Business Information & Analytics

Altis • Ottawa

On-site
CAD 90,000 - 130,000