Senior Snowflake Engineer developing scalable data solutions for a tech company. Focused on data pipelines, SQL optimization, and collaboration with cross-functional teams.
Responsibilities
Design, develop, and maintain scalable data pipelines and transformation logic using Snowflake (SnowSQL, Snowpark, Streams, Tasks, Warehouses).
Build and optimize complex SQL, stored procedures, UDFs, and performance-tuned queries.
Implement data ingestion frameworks and integrations from multiple sources (APIs, files, SaaS systems, cloud storage, etc.).
Model and structure data (3NF, Data Vault, Dimensional Modeling) to support analytics and enterprise reporting.
Hands-on experience with Snowflake features: Warehouses, RBAC, Streams, Tasks, Snowpipe, external stages, data sharing.
Strong experience with ETL/ELT tools and orchestration (e.g., dbt, Airflow, Azure Data Factory, AWS Glue, Matillion, etc.).
Experience modeling data for analytics and operational systems (star/snowflake schemas, Data Vault, etc.).
Deep understanding of data quality, governance, schema design, and lifecycle management.
Comfort working with cloud data ecosystems (AWS, Azure, or GCP).
Experience integrating Snowflake with BI tools (Tableau, Looker, Power BI) and downstream consumers.
Strong communication skills - clear, structured, and able to work with technical and non-technical stakeholders.
A high bar for craft, reliability, and accuracy.
Benefits
Real Impact: You’ll work on meaningful products that make a measurable difference - from healthcare and commerce to sustainability and next-gen tech.
Remote-First, Office Friendly: Work from wherever you’re most productive - whether that’s your home, a co-working space, or one of our offices.
An Outstanding Team: Talented, kind, and hard-working people who care deeply about their craft - and about each other.
Growth: You’ll be supported in growing your craft, exploring new paths, and stepping into greater responsibility - at your own pace.
A Culture of Excellence: We care deeply about doing the right thing - for our clients, our team, and ourselves. No burnout. No crunch. Just high-quality work, delivered sustainably.
Variety & Stability: We’re profitable, independent, and over a decade strong. Yet every project brings a fresh challenge. You’ll never be bored here.
Intermediate Coastal Engineer delivering hydrotechnical engineering projects within the Water Resources Technical Team. Collaborating with multidisciplinary teams in Stantec’s Atlantic Canadian office locations.
Senior Process Safety Engineer supporting complex energy and industrial projects across Canada. Leading safety studies and compliance for multidisciplinary projects in a hybrid environment.
Senior Saviynt Engineer for IAM/PAM consultancy. Remote contract role implementing Saviynt platform solutions including identity lifecycle, integrations, and access certifications.
Services Engineer providing technical support and maintenance for fitness equipment in Toronto. Focusing on customer satisfaction and maintaining service standards.
Engineer responsible for the design and modeling of Wagabox solutions to convert waste methane into renewable natural gas. Collaborating with engineering firms and ensuring compliance with North American standards.
Senior Fire Protection Engineer designing fire protection systems for institutional and commercial projects across Canada. Collaborating with multidisciplinary teams and mentoring junior engineers.
Intermediate/Senior Geotechnical Engineer specializing in Northern Climate Geotechnical Engineering at Stantec. Collaborating with multidisciplinary teams on varied engineering projects focusing on sustainability and innovation.
Intermediate Water Resources Engineer supporting mine water management projects across Atlantic Canada. Collaborating with multidisciplinary teams to ensure effective water management solutions.
Senior Water Resources Engineer leading mine water management projects across Atlantic Canada. Focusing on technical delivery, project outcomes, and mentorship for junior staff.