Description

3 months remote across Canada

50-65/HR

Required Skills & Experience

  • Experience leading multi-skilled agile teams as a Sr Data Engineer.
  • Proven, hands-on experience designing, building and productionizing modern data-intensive applications, including orchestration and operation.
  • Deep, hands-on Snowflake expertise: warehouse design, SQL/Snowpark, dbt, dynamic tables, data sharing, cost/performance optimization.
  • Strong Apache NiFi / Snowflake Openflow skills: designing, deploying and monitoring flow-based pipelines, custom processors, and CDC/streaming ingestion at scale.
  • Broad knowledge of the full spectrum of data technologies (ingestion, transformation, storage, presentation, consumption) and the ability to integrate them into successful solutions.
  • Strategic design-thinking experience: problem conceptualization, roadmap definition, architecture realization, and risk management.
  • Strong Proficiency in SQL and Python, with a solid understanding of ETL/ELT patterns, data modelling (star/snowflake schema, SCD), and CI/CD for data (Git, testing, orchestration).

Job Description

Design and hands-on build of end-to-end data solutions on Snowflake, owning functional and non-functional designs from concept through to production.

Develop ingestion and integration pipelines using Snowflake Openflow (Apache NiFi 2.0-based): building visual, low-code flow definitions to ingest multi-source data (CDC from SQL Server/Oracle, REST APIs, event streams, files, SharePoint) into Snowflake without managing separate ETL infrastructure.

Configure NiFi processors, controller services, and parameter groups for structured, semi-structured, streaming and unstructured data movement in both batch and streaming modes, applying secure OAuth2/TLS authentication and RBAC.

Work closely with Ops and Infrastructure architects to productionize robust, resilient, and maintainable solutions, and with customer architects to agree functional and non-functional designs, advising, questioning, and guiding sound design outcomes.

Build Snowflake-native transformations (dbt, Snowpark, Notebooks, tasks/streams, dynamic tables) and medallion (Bronze/Silver/Gold) architectures with automated, metadata-driven pipelines and robust error handling.

Develop policy and standards, share knowledge, and mentor, coach and develop a small number of staff.

We may use artificial intelligence tools to assist with the screening, assessment, or selection of potential applicants for this position.