Sr. Snowflake Data Engineer

Job summary

Lead a team in designing, building, and maintaining scalable data pipelines and Snowflake solutions, including ingestion, transformation, integration, and performance optimization. Develop trusted data marts and analytics-ready datasets, ensure data quality and governance, and collaborate with business and technical stakeholders to support reporting and analytics.

Job details

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 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 Data Pipeline Development 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 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.

What you’ll do

Lead a team in designing, building, and maintaining scalable data pipelines and Snowflake solutions, including ingestion, transformation, integration, and performance optimization. Develop trusted data marts and analytics-ready datasets, ensure data quality and governance, and collaborate with business and technical stakeholders to support reporting and analytics.

Requirements

Requires a SnowPro Core or Advanced certification, at least four years of data engineering or data platform experience, and at least two years of hands-on Snowflake development. Candidates should have strong SQL and data modeling skills, enterprise pipeline experience, cloud platform familiarity, and effective communication and troubleshooting abilities.

Listed skills

• SQL · Preferred
• Team Leadership · Preferred

Other relevant skills

Identified from the job description. Confirm important requirements above.

• Snowflake
• SQL
• Data Engineering
• Data Pipeline Development
• ETL/ELT
• Data Modeling
• Data Warehousing
• Snowflake Streams
• Snowflake Tasks
• Dynamic Tables
• Data Marts
• Cloud Platforms
• Performance Optimization
• Data Quality
• Team Leadership
• SnowPro Certification

Job areas

• Data & Analytics
• Technology
• Software
• Management & Leadership

More jobs from Next Pathway