Data Engineer (Intermediate - Senior)

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 every project 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 experience in 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
• Uniform allowance
• 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.