About the role
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.
Not the right fit? Search for Data Engineer jobs in Canada
About Insight Global
Insight Global is an international professional services and staffing company specializing in delivering talent and technical solutions to Fortune 1000 companies across the IT, Non-IT, Healthcare, and Engineering industries. Fueled by staffing and talent experts, Evergreen, our professional services brand, brings technical advisors and culture consultants to help customers tackle their biggest challenges. With over 70 locations across North America, Europe, and Asia, and global staffing capabilities in 50+ countries, our teams of tech-enabled recruiters are dedicated to finding the right talent and technical solutions to help our customers thrive. At our core, we are dedicated to empowering people to do great things. That’s why we’re passionate about developing our people personally, professionally, and financially so they can be the light to the world around them. n, Evergreen. To find out more, visit www.insightglobal.com
Similar Jobs
About the role
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.
Not the right fit? Search for Data Engineer jobs in Canada
About Insight Global
Insight Global is an international professional services and staffing company specializing in delivering talent and technical solutions to Fortune 1000 companies across the IT, Non-IT, Healthcare, and Engineering industries. Fueled by staffing and talent experts, Evergreen, our professional services brand, brings technical advisors and culture consultants to help customers tackle their biggest challenges. With over 70 locations across North America, Europe, and Asia, and global staffing capabilities in 50+ countries, our teams of tech-enabled recruiters are dedicated to finding the right talent and technical solutions to help our customers thrive. At our core, we are dedicated to empowering people to do great things. That’s why we’re passionate about developing our people personally, professionally, and financially so they can be the light to the world around them. n, Evergreen. To find out more, visit www.insightglobal.com