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
