Snowflake Data Engineer

Job summary

Design, build, and maintain scalable ETL/ELT pipelines and Snowflake data models using Python, SQL, and DBT, while integrating data from multiple sources and improving pipeline performance, reliability, and cost efficiency. Collaborate with stakeholders and BI teams on reporting and visualization, implement data quality checks, and contribute to code reviews, documentation, and best practices.

Job details

Role - Snowflake Data Engineer Location: Remote (Anywhere in Canada) Experience: 5-8 Years Employment Type: Full-Time Job Summary 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) Data Lake Architecture PySpark or Spark API Integration Experience

What you’ll do

Design, build, and maintain scalable ETL/ELT pipelines and Snowflake data models using Python, SQL, and DBT, while integrating data from multiple sources and improving pipeline performance, reliability, and cost efficiency. Collaborate with stakeholders and BI teams on reporting and visualization, implement data quality checks, and contribute to code reviews, documentation, and best practices.

Requirements

Requires 5–8 years of data engineering experience, strong Python and advanced SQL skills, and hands-on experience with Snowflake, DBT, and Power BI or Tableau. Candidates should understand ETL/ELT and data warehousing, have experience with large datasets and cloud platforms, and be familiar with Git and CI/CD; a bachelor's or master's degree in a related field is listed.

Listed skills

• Power BI · Preferred
• SQL · Preferred
• Tableau · Preferred
• CI/CD · Preferred
• Git · Preferred
• Python · Preferred

Other relevant skills

Identified from the job description. Confirm important requirements above.

• Python
• SQL
• Snowflake
• DBT
• Power BI
• Tableau
• ETL/ELT
• Data Modeling
• Data Warehousing
• Data Quality
• Git
• CI/CD
• Cloud Data Platforms
• Snowflake Performance Tuning
• Airflow
• PySpark

Job areas

• Data & Analytics
• Technology
• Software