SNOWFLAKE ENGINEER

Overview

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

Skills

SQL
Snowpipe
Tasks
UDF
Dynamic Tables
PYTHON
CIDC

Job Details

OPEN TO CANADIAN PERMANENT RESIDENTS AND CANADIAN CITIZENS ONLY

Snowflake Engineer

Calgary

5-8 years

Technical Skills: Good HandS on experience on Snowflake with strong programming experience in SQL.

Competence in Snowflake data engineering components such as Snowpipe, Tasks, UDF s and Dynamic Tables, experience in python

Hands on experience in databases, stored procedures, optimizations of huge data

In-depth knowledge of ingestion techniques, data cleaning, de-dupe, partitioning.

Knowledge of multi-layer data architectures (e.g. bronze, silver, gold)

Experience in streaming / real-time / event driven data platforms.

Create and maintain optimal data pipelines, using the most appropriate features within Snowflake .

Implement data pipelines utilizing industry standards around IaC, CICD and automated testing.

Collaborate with stakeholders to understand data & non-functional requirements.

Assemble large, complex data sets that meet functional as well as non-functional business requirements.

Collaborate with the team on building data models and schema design.

Implement data quality checks and data governance standards.

Build the infrastructure required for optimal extraction, transformation, and loading of data.

Consult with product, engineering, and business stakeholders to understand business problems and identify the best way to deliver a solution educating stakeholders about options where required.

Prepare high-level ETL mapping specifications.

Test data pipelines and perform bug fixes.

Develop best practices for database design and development activities.

Actively participate in agile and design meetings to drive the technical outcomes. Certifications Needed:

Any relevant certification would be added advantage

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.