Data Engineer

Techtronic Industries; Toronto; On-site; CAD 80,000 - 100,000; Full time

Job summary

A leading technology company is seeking a Data Engineer in Toronto to lead the delivery of scalable data infrastructure solutions. Responsibilities include designing data pipelines, ensuring data integrity, and collaborating with cross-functional teams. Candidates should have 3-5 years of experience and strong SQL skills. This role offers extensive health benefits and a competitive salary.

Benefits

Extensive health benefits, including vision and dental care

Retirement Savings Plan with Employer Matching Contributions

Annual $500 Wellness Program allowance

Paid time off and employee discount programs

iPhone, and laptop

Qualifications

• 3–5 years of experience as a Data Engineer or similar role.
• Experience with ETL/ELT tools and cloud platforms.
• Familiarity with big data file formats and distributed processing frameworks.

Responsibilities

• Design and maintain data pipelines for analytics and BI needs.
• Integrate data from various sources into a centralized data lake.
• Collaborate with cross-functional teams to translate requirements into solutions.

Skills

Strong SQL skills

Data pipeline orchestration

Programming skills in Python or Scala

Excellent problem-solving abilities

Attention to detail

Education

Bachelor’s Degree in Computer Science or related field

Tools

Azure Data Factory

SQL Server

Snowflake

Databricks

Job description

What You Will Do

The Data Engineer will lead the delivery of scalable and high-impact data infrastructure solutions from concept to deployment.

In this position, the Data Engineer will :

• Design, develop, and maintain efficient data pipelines to support analytics and BI needs.
• Ingest and integrate data from multiple sources, including on-premises SQL Server, cloud platforms, APIs, and flat files.
• Implement data transformation logic to clean, enrich, and prepare data for reporting and advanced analytics.
• Collaborate with Data Analysts, BI Developers, Data Scientists, and business stakeholders to understand requirements and translate them into technical solutions.
• Ensure data integrity, consistency, and accuracy through validation, monitoring, and governance practices.
• Optimize ETL / ELT processes for performance, scalability, and cost-effectiveness.
• Work with cloud-based data platforms (e.g., Azure, Snowflake, Databricks) to modernize TTI Canada’s data ecosystem.
• Support the development of a centralized data lake / data warehouse architecture.
• Implement best practices for data security, access control, and compliance.
• Monitor pipelines and troubleshoot ingestion or transformation failures.
• Create and maintain technical documentation for data pipelines, workflows, and architectures.
• Contribute to continuous improvement initiatives by evaluating and implementing emerging data engineering tools and practices.

What You Will Bring

• Legally entitled to work full-time in Canada and able to travel to the United States.
• Bachelor’s Degree in Computer Science, Information Systems, Engineering, or related field.
• 3–5 years of experience as a Data Engineer, Database Developer, or related role.
• Strong SQL skills and experience working with relational databases (e.g., SQL Server, Oracle, PostgreSQL).
• Proficiency with ETL / ELT tools and data pipeline orchestration (e.g., Azure Data Factory, dbt).
• Experience with cloud platforms such as Microsoft Azure, Snowflake, or Databricks.
• Strong programming skills in Python or Scala for data processing and automation.
• Familiarity with big data file formats (e.g., Parquet, ORC, JSON) and distributed processing frameworks (e.g., Spark).
• Understanding of data modeling, data warehousing, and dimensional design principles.
• Knowledge of data governance, security, and compliance best practices.
• Excellent problem-solving abilities, attention to detail, and communication skills.
• Ability to work collaboratively in cross-functional teams and adapt to a fast-paced environment.

What You Will Benefit From

• Extensive health benefits, including vision and dental care
• Retirement Savings Plan with Employer Matching Contributions
• Competitive Base Salary
• iPhone, and laptop
• Paid time off and employee discount programs
• Annual $500 Wellness Program allowance