Sr. Snowflake Data Engineer
for
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
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
- 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.
