Data Engineer – Snowflake, AI/ML

Job Title: Data Engineer – Snowflake, AI/ML

Location: Markham, ON, Canada

Employment Type: Contract

Experience: 7+ Years

Job Summary

We are seeking an experienced Data Engineer with strong expertise in Snowflake, Snowflake AI/ML, Data Science, dbt Core, AWS Cloud, and modern data engineering practices. The ideal candidate will have a proven track record of delivering high-impact data projects from inception through warranty, developing scalable data pipelines, optimizing database performance, and collaborating with technical and business stakeholders.

Key Responsibilities

• Deliver high-impact data engineering projects from initial design and development through deployment and warranty support.
• Design, develop, and optimize data pipelines and solutions using Snowflake, dbt Core, and AWS cloud technologies.
• Apply Snowflake AI/ML and Data Science capabilities to support advanced analytics and data-driven solutions.
• Develop and maintain code using Python, Java, SQL, Shell scripting, and Terraform.
• Design, implement, and manage relational databases, including Snowflake, PostgreSQL, and Amazon Aurora.
• Use Snowflake tools such as Snowsight and Streamlit to support data analysis, application development, and operational monitoring.
• Build and manage data pipeline orchestration using Zena and AWS Managed Airflow.
• Improve performance, scalability, reusability, and maintainability across data platforms and workflows.
• Identify and resolve gaps in data architecture, design, and engineering processes.
• Collaborate with internal and external stakeholders and communicate technical solutions and business insights effectively.
• Develop and present data insights using reporting and visualization tools such as Qlik and SAP BusinessObjects.

Required Qualifications

• 7+ years of professional experience in data engineering, including delivery of 10+ high-impact data projects from inception through warranty.
• 5+ years of experience with Snowflake, dbt Core, and AWS cloud technologies.
• 5+ years of programming experience using languages such as Python and Java.
• Strong hands-on expertise in Snowflake AI/ML and Snowflake Data Science.
• Deep knowledge of relational databases, including Snowflake, PostgreSQL, and Amazon Aurora.
• Proficiency in SQL, Python, Shell scripting, and Terraform.
• Hands-on experience with Snowsight and Streamlit.
• Experience with data pipeline orchestration tools such as Zena and AWS Managed Airflow.
• Strong understanding of data performance optimization, reusable components, maintainable code, and scalable data architecture.
• Excellent technical and business communication and presentation skills.
• Ability to work effectively in fast-paced, ambiguous, and high-pressure environments.

Preferred Qualifications

Candidates holding two or more of the following certifications will be preferred:

• SnowPro Core
• SnowPro Advanced: Data Engineer (DEAC01 / DEAC02)
• SnowPro Advanced: Architect (ARAC01)
• AWS Certified Cloud Practitioner
• Relevant Qlik or SAP BusinessObjects certifications

Preferred Skills

• Data visualization and reporting using Qlik and SAP BusinessObjects.
• Experience translating complex data insights into actionable business recommendations.
• Strong stakeholder management and cross-functional collaboration skills.

Mandatory Skills: Snowflake AI/ML, Snowflake Data Science