Lead Snowflake Data Engineer

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
Experience leading a teamDesign, 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