Snowflake Data Engineer

Tredence Inc.; Canada; On-site; CAD 90,000 - 130,000; Full time

Job summary

Tredence Inc. in Canada is seeking a Mid-Level Data Engineer to design, build, and maintain scalable data pipelines and data warehouse solutions using Python, SQL, Snowflake, DBT, and BI tools.

You will collaborate with analytics teams, data architects, and business stakeholders to deliver reliable data solutions, optimize performance, and ensure data quality across cloud platforms.

Qualifications

• 5-8 years of experience in Data Engineering or related roles.
• Strong programming experience in Python.
• Advanced proficiency in SQL for data extraction, transformation, and optimization.
• Hands-on experience with Snowflake Data Warehouse.
• Strong experience with DBT for data transformation and modeling.
• Experience with Power BI or Tableau for reporting and data visualization.
• Knowledge of ETL/ELT concepts and data warehousing principles.

Responsibilities

• Design, develop, and maintain robust ETL/ELT pipelines using Python, SQL, and DBT.
• Build and optimize data models within Snowflake to support analytics and reporting requirements.
• Develop reusable and scalable data transformation frameworks using DBT.
• Monitor, troubleshoot, and enhance existing data pipelines for performance and reliability.
• Integrate data from multiple source systems into Snowflake data warehouses.
• Collaborate with BI developers and business users to understand reporting requirements.
• Support dashboard development and data visualization initiatives using Power BI or Tableau.
• Implement data quality checks, validation processes, and monitoring mechanisms.
• Optimize SQL queries and Snowflake workloads for improved performance and cost efficiency.
• Participate in code reviews, documentation, and best practice adoption.

Skills

Python

SQL

Snowflake

DBT

Power BI

Tableau

ETL/ELT

Git

CI/CD

Cloud platforms

Airflow

Agile/Scrum

Data governance

Education

Bachelor's or Master's in Computer Science / IT / Engineering

Tools

Power BI

Tableau

Airflow

DBT

Job description

We are seeking a talented Mid-Level Data Engineer to join our growing data team. The ideal candidate will have hands‑on experience in building, optimizing, and maintaining scalable data pipelines and data warehouse solutions. You will work closely with business stakeholders, analytics teams, and data architects to deliver reliable and high‑quality data solutions using Python, SQL, Snowflake, DBT, and a BI tool such as Power BI or Tableau.

Key Responsibilities

• Design, develop, and maintain robust ETL/ELT pipelines using Python, SQL, and DBT.
• Build and optimize data models within Snowflake to support analytics and reporting requirements.
• Develop reusable and scalable data transformation frameworks using DBT.
• Monitor, troubleshoot, and enhance existing data pipelines for performance and reliability.
• Integrate data from multiple source systems into Snowflake data warehouses.
• Collaborate with BI developers and business users to understand reporting requirements.
• Support dashboard development and data visualization initiatives using Power BI or Tableau.
• Implement data quality checks, validation processes, and monitoring mechanisms.
• Optimize SQL queries and Snowflake workloads for improved performance and cost efficiency.
• Participate in code reviews, documentation, and best practice adoption.

Required Skills

• 5-8 years of experience in Data Engineering or related roles.
• Strong programming experience in Python.
• Advanced proficiency in SQL for data extraction, transformation, and optimization.
• Hands‑on experience with Snowflake Data Warehouse.
• Strong experience with DBT (Data Build Tool) for data transformation and modeling.
• Experience with Power BI or Tableau for reporting and data visualization.
• Knowledge of ETL/ELT concepts and data warehousing principles.
• Experience working with large‑scale datasets and cloud‑based data platforms.
• Familiarity with Git and CI/CD practices.
• Strong analytical and problem‑solving skills.

Preferred Qualifications

• Experience with cloud platforms such as AWS, Azure, or GCP.
• Knowledge of orchestration tools such as Airflow, Prefect, or Azure Data Factory.
• Understanding of data governance, data quality, and security best practices.
• Exposure to Agile/Scrum development methodologies.

Education

• Bachelor's or Master's degree in Computer Science, Information Technology, Engineering, or a related field.

Nice‑to‑Have Skills

• Snowflake Performance Tuning
• Data Modeling (Star Schema, Dimensional Modeling)