Sr. Snowflake Data Engineer

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

Job summary

Next Pathway, the Automated Cloud Migration Company, seeks an experienced Snowflake Data Engineer to lead a team and build a new cloud data platform on Snowflake. You will mentor engineers while delivering scalable data pipelines and ensuring governance and security.

The role focuses on ELT/ETL development, data modeling, and enterprise analytics, with on-site duties in Downtown Toronto (Tue-Thu).

Qualifications

• Snowflake-native features including Streams, Tasks, Dynamic Tables.
• 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.
• Experience developing dimensional models and data marts.
• Understanding of ELT/ETL design patterns and best practices.
• Experience with AWS, Azure, or Google Cloud.
• Strong problem-solving and stakeholder communication skills.

Responsibilities

• Lead a team of data engineers.
• Design, build, and maintain scalable data pipelines to ingest, transform, and deliver data into Snowflake.
• Develop ELT/ETL processes for batch and near real-time data integration.
• Integrate data from enterprise applications, databases, APIs, and cloud sources.
• Ensure data quality, reliability, and consistency across the data lifecycle.
• Develop Snowflake objects (databases, schemas, tables, views, tasks, streams).
• Collaborate with platform engineers to meet governance and security standards.
• Design data marts and semantic models for analytics.
• Optimize models, transformations, and queries for performance.

Skills

Snowflake

SQL

Data pipelines

Team leadership

Data modeling

ELT/ETL design

Cloud platforms

Data quality

Stakeholder communication

Performance tuning

Tools

Snowflake

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 with experience leading a team, to support a major enterprise client that is building a new cloud data platform on Snowflake.

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

• Experience leading a team
• 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

• 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

• SnowPro Certification (Core or Advanced) - (nice to have)
• 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.