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.
Sign in
To continue your applicationor continue with email
By continuing you agree to our Terms & Privacy Policy.
