Data Engineer (Intermediate - Senior)

KF Aerospace; Kelowna; On-site; CAD 73,000 - 114,000; Full time

Benefits offered by this job

Health & Dental

Pension matching plan

RRSP

Employee Assistance Program

Job summary

This role offers exposure to modern cloud analytics and enterprise reporting, with a strong emphasis on data governance, performance, and scalable data solutions across KF Aerospace facilities in Canada.

Qualifications

• Degree or diploma in Computer Science, Information Systems, Software Engineering, or equivalent experience.
• Minimum 3 years of experience in Data Engineering, Data Warehousing, or related roles (Senior: 5+).
• Strong SQL and relational database development, including optimization and data modeling.
• Experience with SQL Server, Microsoft Fabric, Azure Synapse, and Power BI.
• Experience developing ETL/ELT pipelines and working with cloud-based data platforms.
• Knowledge of Lakehouse, data modeling, and modern data architecture concepts.
• Experience with Azure DevOps, REST APIs, Python, Spark is a plus.

Responsibilities

• Design, develop, and maintain scalable ETL/ELT pipelines and data solutions.
• Develop, optimize, and maintain complex SQL queries and database objects for analytics.
• Support Microsoft Fabric deployment, Data Factory, OneLake, Data Warehouse, and Power BI integrations.
• Build Lakehouse and Medallion-based data architectures.
• Integrate data from multiple enterprise systems, databases, APIs, and cloud platforms.
• Monitor and optimize data processes for performance and reliability.
• Collaborate with business and technical teams to translate requirements into data solutions.
• Support data governance, quality, and security standards.
• Contribute to adoption of emerging data technologies.

Skills

SQL

Azure

Power BI

Python

Spark

ETL/ELT

Data Warehousing

REST APIs

Education

Degree or diploma in CS/IS/SE

Tools

Microsoft Fabric

Azure Synapse

Power BI

SQL Server

Azure Data Factory

Job description

Salary Range: $73,000.00 To $114,000.00 Annually

We’re all about the craft.

KF Aerospace is proud to deliver innovative aircraft services for corporate, commercial, and military customers worldwide. Launched in 1970 out of British Columbia’s beautiful city of Kelowna, KF has grown to specialize in a wide range of aviation services including maintenance and modifications, cargo operations, military pilot training and aircraft leasing. With facilities across Canada, KF is home to over 1,200 highly skilled individuals. Our passion for our craft fuels everyproject we touch.

JOB OVERVIEW

KF Aerospace is seeking a Data Engineer to support the design, development, and modernization of our enterprise data platform. This role will help drive the implementation of scalable data solutions using Microsoft Fabric, Azure, SQL Server, and Power BI technologies.

You will work closely with business stakeholders, analysts, developers, and report authors to build and maintain reliable data pipelines, modern Lakehouse architecture, and enterprise reporting solutions that enable data-driven decision making across the organization.

This is an opportunity to contribute to a growing and evolving data environment while working with modern cloud and analytics technologies.

DUTIES AND RESPONSIBILITIES

• Design, develop, and maintain scalable ETL/ELT pipelines and enterprise data solutions.
• Develop, optimize, and maintain complex SQL queries and database objects to support analytics and reporting solutions.
• Support the implementation and optimization of Microsoft Fabric, including Data Factory, OneLake, Data Warehouse, and Power BI integrations.
• Build and maintain Lakehouse and Medallion-based data architectures.
• Integrate data from multiple enterprise systems, databases, APIs, and cloud platforms.
• Monitor, troubleshoot, and optimize data processes for performance, reliability, and scalability.
• Collaborate with business and technical teams to translate requirements into effective data solutions.
• Support data governance, quality, security, and documentation standards.
• Contribute to enhancement initiatives and adoption of emerging data technologies.

REQUIREMENTS

• Degree or diploma in Computer Science, Information Systems, Software Engineering, or equivalent experience.
• Intermediate: minimum 3 years of experiencein Data Engineering, Data Warehousing, or related technical roles.
• Senior: minimum of 5 years of experience in Data Engineering, Data Warehousing, or related technical roles.
• Strong SQL and relational database development experience, including query optimization and data modeling.
• Strong experience with SQL Server, Microsoft Fabric, Azure Synapse, and Power BI.
• Experience developing ETL/ELT pipelines and working with cloud-based data platforms.
• Knowledge of Data Lakehouse, data modeling, and modern data architecture concepts.
• Experience with Azure DevOps, REST APIs, Python, Spark, or Azure Data Factory is considered an asset.
• Strong analytical, problem-solving, communication, and collaboration skills.

BENEFITS

Full-Time staff benefits include (but are not limited to):

• Health and Dental
• Short & Long-Term Disability
• Life Insurance
• Health Spending Account
• Personal (Wellness) Spending Account
• Paid vacation and Personal time off
• Pension matching plan and voluntary RRSP
• Employee & Family Assistance Program
• A bonus program based on organizational performance

SALARY

The wage band is KF level 9-12 $73,000-$114,000. The expertise and technical skill level of the candidate is assessed during the selection process for placement within the band. Note: The salary range maximum signifies full job knowledge.