Data Engineer: Power Platform & ETL Expert
Posted Updated
Description
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.
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. 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.Skills
Sign in to read and join the discussion.