Snowflake Data engineer

Overview

Remote
Depends on Experience
Accepts corp to corp applications
Contract - W2
Contract - 12 Month(s)

Skills

SQL
Snowflake
Informatica IICS
Data Modeling
ETL/ELT Pipelines
Snowpipe
Streams & Tasks
Cloud Storage Integration (AWS/Azure)
Performance Tuning
Data Quality

Job Details

Job Title: Snowflake Data engineer
Location: Remote (Canada)
Duration/Term: Long-Term Contract


Job Summary:

We are looking for a seasoned Snowflake Data Engineer with strong expertise in Snowflake, SQL, and Informatica IICS to design, build, and optimize large-scale cloud-based data pipelines. This role involves end-to-end data integration, performance tuning, and data modeling to support enterprise analytics and reporting initiatives.


Key Responsibilities:

  • Write and optimize complex SQL queries and stored procedures for high-performance data processing.
  • Design, develop, and manage ETL/ELT pipelines using Informatica IICS across hybrid and cloud environments.
  • Architect scalable and efficient Snowflake data warehouses, including schema design, Snowpipe, Streams, Tasks, and tuning.
  • Integrate Snowflake with cloud storage platforms like AWS S3 or Azure Blob Storage.
  • Implement data modeling techniques such as star and snowflake schemas to support analytical workloads.
  • Develop and maintain Snowflake objects including warehouses, databases, schemas, tables, and access control structures.
  • Perform data quality checks, validation, and apply transformation rules to ensure data accuracy.
  • Monitor and troubleshoot job performance and optimize compute resources across Snowflake and IICS.


Required Skills & Experience:

  • Proficiency in SQL, query performance tuning, and working with large datasets.
  • Hands-on experience with Snowflake architecture, data pipelines, and automation.
  • Strong experience using Informatica IICS for ETL/ELT in cloud and hybrid settings.
  • Knowledge of data modeling principles, including dimensional modeling techniques.
  • Familiarity with cloud data storage solutions like AWS S3 and Azure Blob.
  • Experience in data integration, validation, and reconciliation techniques.
  • Strong communication and coordination abilities across technical and business teams.


Key Skills:

SQL, Snowflake, Informatica IICS, Data Modeling, ETL/ELT Pipelines, Snowpipe, Streams & Tasks, Cloud Storage Integration (AWS/Azure), Performance Tuning, Data Quality


VDart Group, a global leader in technology, product, and talent management, empowers businesses with comprehensive solutions through our four distinct, industry-leading business units With a diverse team of over 4,000 professionals across 13 countries, we deliver strong results across various industries, including Fortune 500 companies

Committed to "People, Purpose, Planet," we prioritize social responsibility and sustainability, as evidenced by our EcoVadis Bronze Medal Certification and participation in the UN Global Compact

Our dedication to delivering strong results has earned us recognition as a trusted advisor for businesses seeking to drive innovation and growth, including many Fortune 500 companies Join our network! Partner with VDart Group to leverage our global network, industry expertise, and proven track record with a diverse clientele

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.

About VDart, Inc.