Senior Snowflake Engineer responsible for designing, building, and optimizing cloud data platform. Collaborating with stakeholders to deliver secure data solutions powering analytics and decision-making.
Responsibilities
Design, develop, and maintain scalable data pipelines and ELT/ETL workflows on Snowflake, integrating data from diverse internal and external sources.
Architect and optimize Snowflake data models, schemas, and warehouses for performance, reliability, and cost efficiency.
Implement and enforce data governance, security, role-based access controls, and data quality standards across the platform.
Monitor and tune warehouse performance, query execution, and resource consumption to control costs and meet SLAs.
Build and maintain CI/CD pipelines for data infrastructure using tools such as dbt, Git, and orchestration frameworks (e.g., Airflow).
Leverage advanced Snowflake features — Snowpipe, Streams, Tasks, Time Travel, Dynamic Tables, and Snowpark — to deliver near-real-time and automated data solutions.
Collaborate with analysts, data scientists, and business stakeholders to translate requirements into robust data solutions.
Mentor junior engineers, conduct code reviews, and establish best practices for data engineering across the team.
Requirements
5+ years of data engineering experience, with 3+ years of hands-on Snowflake development in a production environment.
Expert-level SQL skills, including complex query design, optimization, and performance tuning.
Strong experience designing dimensional and/or data vault data models and building ELT pipelines.
Proficiency with dbt for data transformation and modeling.
Hands-on experience with at least one cloud platform (AWS, Azure, or GCP) and its data services.
Programming proficiency in Python for data processing, automation, and scripting.
Proficiency using GenAI and AI-assisted development tools (e.g., Claude Code, ChatGPT/OpenAI, GitHub Copilot, Cursor) to accelerate coding, debugging, and documentation.
Experience with workflow orchestration tools such as Airflow, Dagster, or Prefect.
Solid understanding of data warehousing concepts, data governance, and security best practices.
Bachelor's degree in Computer Science, Engineering, or a related field, or equivalent practical experience.
Senior I&C Engineer designing CANDU instrumentation and control systems for AtkinsRéalis, a Canadian nuclear engineering services company. Producing specifications, assessments, design documents, and engineering drawings.
Seeking a DDI Engineer with deep DNS expertise to support a large enterprise network in the GTA, ON. Contract role requiring hands - on experience with DNS/DHCP and IPAM platforms.
Fire engineer designing and evaluating fire protection systems for GHD’s Canadian architecture, engineering, and environmental projects. Conducting risk assessments, code reviews, inspections, project management, and mentoring junior engineers.
Engineer II performing design, analysis, testing, and field engineering for Framatome Canada’s nuclear technologies. Supporting safe, efficient CANDU reactor operations and product - life - cycle improvements.
Underground Geotechnical Engineer supporting ground control and mine planning at Coeur Silvertip, a Canadian precious - metals mining operation. Designing support systems, analyzing monitoring data, and managing geotechnical risk for underground excavations.
The City of Regina is hiring a Project Engineer/Coordinator for Water - Sewer Programming. Ideal for those with experience in municipal infrastructure, water/wastewater, engineering, or project management.
Validation Engineer testing SSD firmware, NVMe features, and NAND memory products for DATAmundi’s localization and data - services software business. Detecting defects, optimizing validation, and coordinating with firmware engineers and clients.
Project Engineer improving yield, efficiency, and raw - material utilization in Agropur’s dairy manufacturing operations. Leading process optimization and capital projects at the Granby facility.