Collaborate with functional IFS teams to align migration logic with business and system requirements.
Review existing operations data, research open issues, and collaborate with the engineering and operations teams on new and ongoing projects.
Ensure the accuracy, integrity, and security of data within the organization.
Lead and support data migration activities for IFS, including extraction, cleansing, mapping, transformation, validation, and reconciliation.
Design tools and infrastructure to analyze large volumes of data.
Develop and optimize SQL, PL/SQL, and T-SQL code to support enterprise data workflows across Oracle and SQL Server.
Build data pipelines, monitor them, and troubleshoot operational or data issues.
Assist the team with troubleshooting, root cause analysis, and thorough defect resolution in the event of a problem.
Requirements
power bi
sql
python
ci/cd
degree
azure
Exceptional communication skills and ability to translate technical concepts into appropriate language for all stakeholders
Experience with Power BI or other BI tools.
Strong SQL experience with Oracle, SQL Server, including query tuning and analysis.
5+ years of experience as a Data Engineer or similar role.
Familiarity with DevOps practices. CI/CD experience.
Proficiency in Python, PySpark, data modeling, ETL/ELT processes and data integration using Microsoft technologies.
Degree or Diploma in Computer Science, Information Systems, or related field.
Advanced SQL skills for data transformation and querying on Azure data services (e.g., Data Factory, Databricks, Synapse, Fabric, Purview).
Strong understanding of data pipeline engineering and big data design principles.
Experience with database, data warehouse or data lake solutions.
Benefits
Community Involvement- Generously supporting health, charities, youth, and education opportunities is our passion, and you’re invited to be a part of that.
Gym Subsidy Program- Employees are eligible for a gym membership reimbursement of up to $300 per year, this includes Fitness related App’s.
As part of our Goals, Rewards, Improvement and Teamwork program qualifying teams can enjoy a monthly reward.
PocketPills – You and your family will have free access to Canada’s first Digital Pharmacy, PocketPills enables you to call, text or email the pharmacy care team from wherever you are. You will enjoy free delivery of your prescriptions and vitamins straight to your home.
Personal and Professional Development- We are committed to helping you reach your potential through training and education.
Life and Disability- You will be provided with life insurance in a multiple of your salary with an option to purchase additional coverage.
Pension Matching Program- Invest in your future with each pay cheque through our Defined Contribution Pension Plan and we will match your contribution (up to 3% of your salary).
Health and Dental- Employees and their families enjoy paid benefits covering an extensive list of medical and dental expenses and services.
Employee and Family Assistance Program (EFAP)- You and your family will have free access to consultation and support for your mental, emotional and financial well-being
Training + Development
Information not given or found
Interview process
Information not given or found
Visa Sponsorship
Information not given or found
Security clearance
Information not given or found
Company
Overview
1963 Founded
Year Established
The company was founded in 1963 and has since grown into a trusted name in air distribution and ventilation solutions.
The company focuses on providing innovative products that improve air quality and comfort in various environments.
The company specializes in customized HVAC solutions, offering products like diffusers, air terminals, and acoustic products.
With a strong presence in North America, the company has expanded globally, serving clients across multiple industries.
The company’s products are integral to building systems in sectors like healthcare, commercial, residential, and institutional.
The company stands out for its commitment to engineering excellence, continuously evolving product offerings to meet market needs.
Notable projects include large-scale hospitals, high-rise commercial buildings, and industrial complexes, showcasing their diverse expertise.
Culture + Values
Integrity
Teamwork
Customer focus
Innovation
Accountability
Environment + Sustainability
Net‑zero by 2050
Carbon Neutrality Target
The company aims to achieve net-zero greenhouse gas emissions by 2050, aligning with global climate goals.
5‑10% annual energy reduction
Operational Efficiency Goals
Plans to reduce energy consumption by 5-10% annually through energy efficiency initiatives.
75% waste diversion rate
Waste Management Achievement
Maintains a 75% waste diversion rate across manufacturing facilities, focusing on recycling and reuse.
Reduce Scope 1 and 2 emissions through energy‑efficiency projects and increased use of low‑carbon energy
Quarterly tracking and reporting of water use, energy use and waste generation using real‑time dashboards
Inclusion & Diversity
40% Target
Female Leadership by 2027
Aims to increase female representation in leadership positions to 40% by 2027 through a gender-equity initiative.
32% Representation
Current Leadership Roles
Currently, women hold 32% of leadership positions within the organization.
95% Completion
Unconscious Bias Training
Achieved 95% completion rate for unconscious bias training in 2024 among all people managers.
Over 100 Participants
Mentorship Program
Over 100 participants have joined the mentorship program, pairing women and underrepresented employees with senior executives.