SQL Developer jobs

The Canadian Air Transport Security Authority (CATSA) has 1 exciting indeterminate opportunity 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.

If you are a motivated professional seeking a position within a multifunctional and collaborative environment and you are looking for the next great adventure, CATSA is the place for you!

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:
To qualify for the position, you must have:

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

How to apply:

If you feel you are the ideal candidate for this position, please submit your application before September 24, 2026 by 11:59pm EST.

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;