Data Engineer: Power Platform & ETL Expert

Canadian Air Transport Security Authority

Ottawa

On-site

CAD 90,000 - 130,000

Full time

9 days ago

Get a reply from this employer

Your resume and cover letter, tailored to exactly what they’re hiring for.

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

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.

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

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 Engineer
Data Engineer

Canadian Air Transport Security Authority • Ottawa

On-site
CAD 90,000 - 130,000
Data Engineer
Data Engineer

Catsa Acsta • Ottawa

On-site
CAD 90,000 - 130,000
Software Developer - ETL / Power BI - Intermediate
Software Developer - ETL / Power BI - Intermediate

isgSearch • Toronto

On-site
CAD 90,000 - 130,000
Data Analyst – Power BI / Microsoft Fabric
Data Analyst – Power BI / Microsoft Fabric

Myticas Consulting Inc. • Ottawa

On-site
CAD 90,000 - 107,000
Full benefits
Power Platform Developer - Valued Government of Canada Client
Power Platform Developer - Valued Government of Canada Client

Robertson & Company Ltd. • Ottawa

On-site
CAD 80,000 - 100,000
Senior Power BI & Data Warehouse Architect
Senior Power BI & Data Warehouse Architect

Precision Technologies • Mississauga

On-site
CAD 110,000 - 140,000
Data Analyst / Business Intelligence Analyst
Data Analyst / Business Intelligence Analyst

NorthBridge Analytics • Ottawa

Hybrid
CAD 75,000 - 90,000
Company pension
Dental care
Flexible schedule
+3
Intermediate Software Developer
Intermediate Software Developer

Hirematic Talent Solutions • Toronto

On-site
CAD 55,000 - 62,000
Power BI Developer
Power BI Developer

Tata Consultancy Services Limited • Calgary

On-site
CAD 90,000 - 110,000