Sr. Snowflake Data Engineer

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.