Data Engineer at Trojan Technologies in London, Ontario, Canada | Kablio

Role

Description

data workflows

data modeling

snowflake

matillion

elt pipelines

performance monitoring

Architect end-to-end data workflows that ensure high performance, reliability, and data integrity for both batch and near real-time use cases.
Define and implement best practices for data modeling, metadata management, data lineage, and governance, utilizing the features of Snowflake and Matillion.
Collaborate with cross-functional teams including Data Analysts, DevOps, and business stakeholders to gather requirements and deliver data solutions that drive value.
Optimize data storage, retrieval, and computation to ensure efficient processing and cost control within our cloud infrastructure.
Design, develop, and maintain scalable ELT/ETL pipelines using Matillion and Snowflake to support diverse data integration and transformation needs across the company.
Monitor, troubleshoot, and resolve issues related to data pipelines, performance bottlenecks, and data quality challenges

Requirements

aws

snowflake

matillion

mlops

data modeling

5+ years

Strong grasp of cloud platforms (AWS, Azure, or GCP) as they relate to data storage, processing, and security.
Exposure to machine learning workflows and MLOps in a data engineering context
Deep understanding of data modeling (dimensional, normalized, and denormalized), data governance, and data quality frameworks.
Bachelor’s or Master’s degree in Computer Science, Information Systems, Engineering, or a related field, or equivalent work experience.
Advanced knowledge of Snowflake, including schema design, security, performance tuning, stream and tasks, and cost optimization strategies.
Hands-on experience with data cataloging tools and metadata management frameworks.
5+ years of professional experience in data engineering, with at least 2 years in a senior role.
3+ years of continuous experience working with Matillion ELT/ETL for cloud data warehouses, including designing complex orchestration jobs, transformation components, and API integrations.
Proven experience in architecting large-scale, distributed data systems and implementing data lakes, warehouses, and marts.

Benefits

Flexible working hours
Career coaching and development opportunities
Professional onboarding and training options
Powerful team looking forward to working with you

Training + Development

Information not given or found

Interview process

technical assessments
architectural discussions
meetings with key stakeholders

Visa Sponsorship

Information not given or found

Security clearance

Information not given or found

Company

Overview

250+ Patents

Innovative Solutions

Trojan has secured over 250 patents in UV and filtration technology, showcasing their commitment to innovation.

760K+ Systems

Global Installations

Their systems are deployed across six continents, highlighting widespread adoption.

Billions Treated Daily

Water Treatment Impact

Trojan's systems treat billions of gallons of water daily, addressing critical water needs.

Founded nearly 50 years ago, Trojan Technologies pioneered UV and filtration systems to tackle global water challenges.
Their portfolio spans municipal water and wastewater projects, industrial applications, residential systems, and filtration.
Trojan products have become essential in major infrastructure—like the world’s largest UV drinking-water plant in NYC.
They design integrated UV‑AOP solutions that remove pathogens and chemical contaminants in a single, compact unit.
Manufacturing is global, with facilities in Canada, the U.S., and Austria, supporting clients in over 90 countries.
Trojan continues to win large-scale contracts, evolving UV technology for increasingly complex water treatment needs.

Culture + Values

Apply Insights – We listen and respond to external and internal customer needs, applying critical thinking, and cultivating breakthrough ideas.
Instill Trust – Our atmosphere of mutual respect exists because we act with integrity, and are genuine, open and honest.
Deliver Results – Customers challenge us - and we challenge us - to continuously improve and innovate.
Win as a Team – We create an environment where everyone feels that they belong, and feel motivated and enabled to do their best.

Environment + Sustainability

72/100 Score

EcoVadis Silver Medal 2025

Achieved a score of 72/100, placing in the 92nd percentile of companies assessed.

71/100 Score

EcoVadis Gold Medal 2023

Achieved a score of 71/100, placing in the 95th percentile of companies assessed.

80% Supply Chain

Sustainability Ratings Goal

Aiming to have at least 80% of the supply chain achieve positive EcoVadis sustainability ratings.

760k Installations

Water Treatment Systems

Over 760,000 UV and microfiltration installations on six continents, treating billions of gallons of water daily.

Part of Veralto’s sustainability agenda 'Safeguarding the World’s Most Vital Resources™.'
5 manufacturing facilities; 900+ associates across 16 countries; support network in 90 countries.

Inclusion & Diversity

2023

Great Place to Work Certification

Recognized as a Great Place to Work in Canada, highlighting exceptional workplace culture and employee satisfaction.

80%

Trust Index Score

Achieved a Trust Index score reflecting strong employee satisfaction across key workplace dimensions.

Regular associate engagement surveys to drive change.
Ongoing awareness initiatives including Day of Understanding, reverse mentorship, workshops, seminars and lunch‑and‑learns.
Associate resource groups: Women + Friends; Asian Descent + Friends; Black + Friends; LatinX + Friends; LGBTQ + Friends.
Women’s Leadership & Development Book Study Group.
Career development programs and unbiased evaluation and selection processes.
Leadership training programs.
Employee feedback highlights respectful, supportive environment where everyone can “speak up,” and leaders are approachable.

Articles

It’s official – Trojan Technologies is a Great Place to Work!

Trojan Technologies Opens First U.S. Distribution Facility in Grand Rapids, Michigan

Careers

Role

Description

data workflows

data modeling

snowflake

matillion

elt pipelines

performance monitoring

Architect end-to-end data workflows that ensure high performance, reliability, and data integrity for both batch and near real-time use cases.
Define and implement best practices for data modeling, metadata management, data lineage, and governance, utilizing the features of Snowflake and Matillion.
Collaborate with cross-functional teams including Data Analysts, DevOps, and business stakeholders to gather requirements and deliver data solutions that drive value.
Optimize data storage, retrieval, and computation to ensure efficient processing and cost control within our cloud infrastructure.
Design, develop, and maintain scalable ELT/ETL pipelines using Matillion and Snowflake to support diverse data integration and transformation needs across the company.
Monitor, troubleshoot, and resolve issues related to data pipelines, performance bottlenecks, and data quality challenges

Requirements

aws

snowflake

matillion

mlops

data modeling

5+ years

Strong grasp of cloud platforms (AWS, Azure, or GCP) as they relate to data storage, processing, and security.
Exposure to machine learning workflows and MLOps in a data engineering context
Deep understanding of data modeling (dimensional, normalized, and denormalized), data governance, and data quality frameworks.
Bachelor’s or Master’s degree in Computer Science, Information Systems, Engineering, or a related field, or equivalent work experience.
Advanced knowledge of Snowflake, including schema design, security, performance tuning, stream and tasks, and cost optimization strategies.
Hands-on experience with data cataloging tools and metadata management frameworks.
5+ years of professional experience in data engineering, with at least 2 years in a senior role.
3+ years of continuous experience working with Matillion ELT/ETL for cloud data warehouses, including designing complex orchestration jobs, transformation components, and API integrations.
Proven experience in architecting large-scale, distributed data systems and implementing data lakes, warehouses, and marts.

Benefits

Flexible working hours
Career coaching and development opportunities
Professional onboarding and training options
Powerful team looking forward to working with you

Training + Development

Information not given or found

Interview process

technical assessments
architectural discussions
meetings with key stakeholders

Visa Sponsorship

Information not given or found

Security clearance

Information not given or found

Company

Overview

250+ Patents

Innovative Solutions

Trojan has secured over 250 patents in UV and filtration technology, showcasing their commitment to innovation.

760K+ Systems

Global Installations

Their systems are deployed across six continents, highlighting widespread adoption.

Billions Treated Daily

Water Treatment Impact

Trojan's systems treat billions of gallons of water daily, addressing critical water needs.

Founded nearly 50 years ago, Trojan Technologies pioneered UV and filtration systems to tackle global water challenges.
Their portfolio spans municipal water and wastewater projects, industrial applications, residential systems, and filtration.
Trojan products have become essential in major infrastructure—like the world’s largest UV drinking-water plant in NYC.
They design integrated UV‑AOP solutions that remove pathogens and chemical contaminants in a single, compact unit.
Manufacturing is global, with facilities in Canada, the U.S., and Austria, supporting clients in over 90 countries.
Trojan continues to win large-scale contracts, evolving UV technology for increasingly complex water treatment needs.

Culture + Values

Apply Insights – We listen and respond to external and internal customer needs, applying critical thinking, and cultivating breakthrough ideas.
Instill Trust – Our atmosphere of mutual respect exists because we act with integrity, and are genuine, open and honest.
Deliver Results – Customers challenge us - and we challenge us - to continuously improve and innovate.
Win as a Team – We create an environment where everyone feels that they belong, and feel motivated and enabled to do their best.

Environment + Sustainability

72/100 Score

EcoVadis Silver Medal 2025

Achieved a score of 72/100, placing in the 92nd percentile of companies assessed.

71/100 Score

EcoVadis Gold Medal 2023

Achieved a score of 71/100, placing in the 95th percentile of companies assessed.

80% Supply Chain

Sustainability Ratings Goal

Aiming to have at least 80% of the supply chain achieve positive EcoVadis sustainability ratings.

760k Installations

Water Treatment Systems

Over 760,000 UV and microfiltration installations on six continents, treating billions of gallons of water daily.

Part of Veralto’s sustainability agenda 'Safeguarding the World’s Most Vital Resources™.'
5 manufacturing facilities; 900+ associates across 16 countries; support network in 90 countries.

Inclusion & Diversity

2023

Great Place to Work Certification

Recognized as a Great Place to Work in Canada, highlighting exceptional workplace culture and employee satisfaction.

80%

Trust Index Score

Achieved a Trust Index score reflecting strong employee satisfaction across key workplace dimensions.

Regular associate engagement surveys to drive change.
Ongoing awareness initiatives including Day of Understanding, reverse mentorship, workshops, seminars and lunch‑and‑learns.
Associate resource groups: Women + Friends; Asian Descent + Friends; Black + Friends; LatinX + Friends; LGBTQ + Friends.
Women’s Leadership & Development Book Study Group.
Career development programs and unbiased evaluation and selection processes.
Leadership training programs.
Employee feedback highlights respectful, supportive environment where everyone can “speak up,” and leaders are approachable.

Articles

It’s official – Trojan Technologies is a Great Place to Work!

Trojan Technologies Opens First U.S. Distribution Facility in Grand Rapids, Michigan

Careers