Data Engineer

Kinsley Power Systems; Ottawa; On-site; CAD 90,000 - 120,000; Full time

Job summary

CATSA is seeking a Data Engineer within the Technology branch in Ottawa to analyze, develop, implement, and support data solutions, including ETL, Power Platform, and AI/MLOps operations. The role emphasizes building dashboards, applications, and automated workflows to drive data-driven decisions.

The ideal candidate has a university degree in CS/IT or related field, 3+ years of SQL experience, 3+ years in Power Platform, and 2+ years with ETL/data engineering tools, with strong communication

Qualifications

• Bachelor's degree in Computer Science, Information Technology/Management, or related field, or equivalent education/experience.
• Minimum 3 years of advanced SQL experience.
• Minimum 3 years of experience using Microsoft Power Platform tools (PowerApps, Power Automate, Power BI).
• Minimum 2 years of experience with ETL/data engineering tools (e.g., SSIS, DataStage, Informatica, Azure Data Factory, Azure Synapse).

Responsibilities

• Design and create interactive dashboards and reports using Power BI for data-driven insights.
• Develop custom applications with PowerApps to meet business requirements.
• Automate workflows with Power Automate to improve efficiency.
• Design, develop, and maintain scalable data pipelines for data integration and analytics.
• Implement and manage ETL processes to ensure data quality across sources.

Skills

SQL

Analytical thinking

Communication

Team collaboration

Power Platform adoption

Education

Bachelor's degree in Computer Science / Information Technology or related field

Tools

Power BI

PowerApps

Power Automate

SSIS

Azure Data Factory

Azure Synapse

Python

Job description

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;

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;