Sr. Snowflake Data Engineer

Next Pathway; Toronto; On-site; CAD 110,000 - 150,000; Full time

Job summary

Next Pathway, the Automated Cloud Migration Company, seeks a Snowflake Data Engineer for a greenfield cloud data platform. You will design and implement scalable ETL/ELT pipelines, leverage Snowflake-native capabilities, and deliver analytics-ready data for business users.

The role emphasizes building robust data models, data marts, and optimized data transformations while adhering to governance and security standards. Onsite in Downtown Toronto, Tue–Thu.

Qualifications

• SnowPro Certification (Core or Advanced) is required or in progress.
• 4+ years in data engineering, data warehousing, or cloud data platform development.
• 2+ years hands-on Snowflake development experience.
• Strong SQL development and data modeling skills.
• Experience building enterprise data pipelines and data integration solutions.
• Experience with dimensional models, data marts, and analytics-ready datasets.
• Experience with AWS, Azure, or Google Cloud.

Responsibilities

• Design, build, and maintain scalable data pipelines to Snowflake.
• Develop ELT/ETL processes for batch and near real-time data integration.
• Integrate data from enterprise apps, databases, APIs, and cloud sources.
• Ensure data quality, reliability, and consistency across the data lifecycle.
• Build Snowflake objects: databases, schemas, tables, views, tasks, streams.
• Collaborate with platform engineers on governance and security standards.

Skills

Snowflake

SQL

Data modeling

ETL/ELT

Cloud platforms

Education

Bachelor's degree in Computer Science, Information Systems, or related field

Tools

dbt

Airflow

Job description

Next Pathway - The Automated Cloud Migration Company

Location: Downtown Toronto, ON (Onsite, Tuesday-Thursday)

Company: Next Pathway

Next Pathway is seeking an experienced Snowflake Data Engineer to support a major enterprise client that is building a new cloud data platform on Snowflake. This is a greenfield implementation where the successful candidate will help design and develop modern data pipelines, leverage Snowflake-native capabilities, and enable business users with trusted, analytics-ready data.

The ideal candidate combines strong data engineering skills with hands-on Snowflake expertise and a passion for building scalable, high-performance data solutions that drive business value.

Responsibilities

• Design, build, and maintain scalable data pipelines to ingest, transform, and deliver data into Snowflake.
• Develop ELT/ETL processes to support batch and near real-time data integration requirements.
• Integrate data from various enterprise applications, databases, APIs, and cloud-based sources.
• Ensure data quality, reliability, and consistency throughout the data lifecycle.

Snowflake Solution Development

• Leverage Snowflake-native capabilities to build efficient, scalable, and maintainable data solutions.
• Develop and optimize Snowflake objects including databases, schemas, tables, views, tasks, streams, and dynamic tables.
• Utilize Snowflake features to support data transformation, orchestration, and performance optimization.
• Collaborate with platform engineers to ensure solutions align with governance, security, and operational standards.

Data Mart & Analytics Enablement

• Support the design and development of business-focused data marts and semantic data models.
• Create curated datasets that enable self-service reporting and analytics.
• Partner with business stakeholders, analysts, and data consumers to understand reporting and analytics requirements.
• Enable new analytics capabilities through the delivery of high-quality, trusted data assets.

Performance & Optimization

• Optimize data models, transformations, and queries for performance and scalability.
• Monitor pipeline execution and troubleshoot data processing issues.
• Implement best practices for cost management, performance tuning, and operational efficiency within Snowflake.
• Contribute to data engineering standards, documentation, and development processes.

Required Qualifications

• SnowPro Certification (Core or Advanced).
• Experience with Snowflake-native features such as Streams, Tasks, Dynamic Tables, 4+ years of experience in data engineering, data warehousing, or cloud data platform development.
• 2+ years of hands-on Snowflake development experience.
• Strong SQL development and data modeling skills.
• Experience building and maintaining enterprise data pipelines and data integration solutions.
• Experience developing dimensional models, data marts, and analytics-ready datasets.
• Understanding of modern ELT/ETL design patterns and best practices.
• Experience working with cloud platforms such as AWS, Azure, or Google Cloud.
• Strong problem-solving, troubleshooting, and analytical skills.
• Excellent communication skills and ability to work directly with business and technical stakeholders.

Preferred Qualifications

• Experience with data orchestration and integration tools.
• Familiarity with CI/CD, DevOps, and DataOps practices.
• Experience supporting enterprise reporting, analytics, and business intelligence initiatives.
• Knowledge of modern data architecture and cloud-native data platform design.

What Success Looks Like

• Reliable and scalable data pipelines delivering trusted enterprise data.
• Well-designed data marts that support reporting, dashboards, and analytics.
• Effective use of Snowflake-native capabilities to maximize platform value.
• High-quality, governed datasets available for business consumption.
• Delivery of new analytics capabilities that improve business decision-making.