Data Engineer (Intermediate - Senior)

KF Aerospace•Kelowna, BC

2d•CA$73,000 - CA$111,000•Onsite

About The Position

KF Aerospace is seeking a Data Engineer to support the design, development, and modernization of their enterprise data platform. This role will focus on implementing scalable data solutions using Microsoft Fabric, Azure, SQL Server, and Power BI technologies. The Data Engineer will collaborate with business stakeholders, analysts, developers, and report authors to build and maintain reliable data pipelines, a modern Lakehouse architecture, and enterprise reporting solutions that facilitate data-driven decision-making across the organization. This position offers an opportunity to contribute to a growing data environment while working with modern cloud and analytics 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.
Strong analytical, problem-solving, communication, and collaboration skills.

Nice To Haves

Experience with Azure DevOps, REST APIs, Python, Spark, or Azure Data Factory is considered an asset.

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.