Sr. Snowflake Data Engineer for Next Pathway - The Automated Cloud Migration Company

Location: Downtown Toronto, ON (Onsite, Monday–Friday, 9:00 AM – 5:00 PM) Duration: 4-Month Contract (Strong Potential for Extension) 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 Data Pipeline Development 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 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). Experience with Snowflake-native features such as Streams, Tasks, Dynamic Tables, Snowpark, and Data Sharing. 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.