Sr. Snowflake Data Engineer

Next Pathway - The Automated Cloud Migration CompanyLocation: 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. #J-18808-Ljbffr