Senior Snowflake Engineer

This is a fully remote position, open to applicants in Canada.

📋 Description

• Design, develop, and sustain scalable data pipelines and ELT/ETL workflows on Snowflake, incorporating data from various internal and external sources.

• Architect and enhance Snowflake data models, schemas, and warehouses to ensure performance, reliability, and cost-effectiveness.

• Implement and uphold data governance, security protocols, role-based access controls, and data quality standards throughout the platform.

• Monitor and optimize warehouse performance, query execution, and resource utilization to manage costs and fulfill SLAs.

• Construct and maintain CI/CD pipelines for data infrastructure utilizing tools such as dbt, Git, and orchestration frameworks (e.g., Airflow).

• Utilize advanced Snowflake functionalities — Snowpipe, Streams, Tasks, Time Travel, Dynamic Tables, and Snowpark — to provide near-real-time and automated data solutions.

• Collaborate with analysts, data scientists, and business stakeholders to translate requirements into effective data solutions.

• Mentor junior engineers, perform code reviews, and establish best practices for data engineering within the team.

⛳️ Requirements

• Over 5 years of data engineering experience, including more than 3 years of hands-on Snowflake development in a production setting.

• Mastery of SQL, with capabilities in complex query design, optimization, and performance tuning.

• Significant experience in designing dimensional and/or data vault data models and constructing ELT pipelines.

• Proficient with dbt for data transformation and modeling.

• Practical experience with at least one cloud platform (AWS, Azure, or GCP) and its data services.

• Programming expertise in Python for data processing, automation, and scripting tasks.

• Proficient in leveraging GenAI and AI-assisted development tools (e.g., Claude Code, ChatGPT/OpenAI, GitHub Copilot, Cursor) to enhance coding, debugging, and documentation efforts.

• Familiarity with workflow orchestration tools such as Airflow, Dagster, or Prefect.

• Strong 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.

🏝️ Benefits

• Competitive salary and performance-based bonuses.

• Comprehensive health, dental, and vision insurance.

• Generous paid time off and flexible working arrangements.

• Opportunities for professional development and continuous learning.

• Collaborative and innovative team environment.