Data Engineer

Future Electronics; Kirkland; Hybrid; CAD 90,000 - 130,000; Full time

Job summary

Future Electronics is seeking a Data Engineer to design, build, and optimize enterprise data pipelines that collect, transform, store, and prepare data for reporting, analytics, ML, and AI initiatives. You will ensure data reliability, security, and accessibility for BI and advanced analytics while collaborating with analysts, data scientists, architects, and business stakeholders.

Responsibilities include ETL/ELT design, data source integration (Oracle, SQL Server, SAP, APIs), and creating

Qualifications

• Experience building and optimizing ETL/ELT pipelines.
• Ability to extract, transform, and integrate data from multiple sources (Oracle, SQL Server, SAP, APIs, flat files).
• Experience preparing analytics-ready and ML-ready datasets.
• Support ML/AI projects through data prep, feature engineering, and validation.

Responsibilities

• Design and maintain ETL/ELT pipelines.
• Extract, transform, and integrate data from multiple sources (Oracle, SQL Server, SAP, APIs, flat files).
• Build analytics-ready and AI-ready datasets.
• Support ML/AI projects through data preparation, feature engineering, and validation.
• Implement data quality, monitoring, auditing, and reconciliation processes.
• Optimize SQL queries, Spark notebooks, Lakehouse/Warehouse tables, and pipeline performance.
• Troubleshoot data issues and process failures.
• Collaborate with business, analytics, and AI/ML teams to deliver scalable data solutions.
• Evaluate AI-generated recommendations and analytics outputs before deployment.

Skills

Python

PySpark

SQL

Stored Procedures

Data Modeling

Data Warehousing

SQL Server

Oracle

Azure Lakehouse

Medallion Architecture

ML dataset prep

Tools

SQL Server

Oracle

Azure Fabric Lakehouse/Warehouse

Job description

This role is responsible for designing, building, and optimizing enterprise data pipelines that collect, transform, store, and prepare data for reporting, analytics, machine learning, and AI initiatives. The Data Engineer ensures data is reliable, secure, accessible, and ready for business intelligence and advanced analytics while working closely with analysts, data scientists, architects, and business stakeholders.

Key Responsibilities

• Design and maintain ETL/ELT data pipelines.
• Extract, transform, and integrate data from multiple sources (Oracle, SQL Server, SAP, APIs, flat files, etc.).
• Build analytics-ready and AI-ready datasets.
• Support machine learning and AI projects through data preparation, feature engineering, and validation.
• Implement data quality, monitoring, auditing, and reconciliation processes.
• Optimize SQL queries, Spark notebooks, Lakehouse/Warehouse tables, and pipeline performance.
• Troubleshoot data issues and process failures.
• Collaborate with business, analytics, and AI/ML teams to deliver scalable data solutions.
• Evaluate AI-generated recommendations and analytics outputs before deployment.

Required Technical Skills

• Strong experience with:
• Python
• PySpark
• SQL
• Stored Procedures
• Data modeling and data analysis.
• Data warehousing concepts.
• Experience with:
• SQL Server
• Oracle
• Azure Fabric Lakehouse/Warehouse
• Understanding of Medallion Architecture.
• Experience preparing datasets for machine learning and predictive analytics.

Preferred Skills

• Microsoft Fabric
• Data Engineering certifications
• Data Governance and Data Quality frameworks
• AI-assisted development tools (Microsoft Fabric Copilot)

Our Approach To Employee Wellness Is Holistic, Which Is Why Alongside Competitive Salaries, And Excellent Health And Dental Benefits, Corporate Employees Have Access To The Following:

• Wellness amenities such as an onsite gym, fitness studio, and employee lounge
• Group RRSP plan to take care of the future you
• Onsite medical clinic and telemedicine
• Daily shuttle bus from two downtown locations
• Subsidized employee café with delicious meals and snacks

Future Electronics is taking a hybrid approach to work. We value collaboration and working together, which our offices facilitate, combined with working remotely.

Future Electronics is an equal opportunity employer.