Senior Snowflake Data Engineer

Sr. Snowflake Data Engineer

Gullview Technologies is an exciting and rapidly growing technology company focused on taking on the most vital and challenging business and technical challenges our clients face in our highly connected business world today. We have an exceptional focus at Gullview on developing deep and long-lasting relationships (several years and counting) with our clients. This focus enables us to deliver an ongoing continuum of projects and solutions to them with high value, meaningful impact, and predictable performance.

Position Overview

We have a great opportunity to help refine a Snowflake Data Solution for a strategic client of ours as part of their Enterprise Data journey. This is a fantastic opportunity to join our firm, and work with our client in the foundational stages of a Data Practice for Gullview and the Enterprise Data Practice for the client with significant opportunities to influence Enterprise Data and Analytics capabilities.

Initially, this role will be an individual contributor with opportunities of leadership in supporting mission critical systems for our clients.

Focus of Role

The Sr. Snowflake Data Engineer will lead a discovery and resolution for our client's current Snowflake implementation. The talented individual in this role will collaborate with Gullview and Client Leadership, Architects, and Engineers to build out a Snowflake Data Solution focusing on delivering business value. This role will initially be an individual contributor with future opportunities for leadership if desired. You will help with the overall Data Strategy including infrastructure, software, utilities/tools, Public Cloud Solutions, and Business Intelligence Solutions for the organization. This is a Sr. level engineering position, not an architecture role.

Responsibilities

Provide understanding of Snowflake, Data Warehouse, Data Movement, Data Curation, and Data Staging best practices in relation to existing Snowflake implementations

Provide resolution to an extensive range of complicated data pipeline related problems, proactively and as issues surface

Build processes supporting data transformation, data structures, metadata, dependency and workload management

Create and contribute to automation of essential processes related to infrastructure solution deployment creating repeatable and robust deployments

Provide Snowflake solutions, including hands on keyboard (implementation)

Overall ownership of the "platform" and supporting essential platform capabilities

Responsible for day-to-day sustainment and configuration of the platform including System Health and Telemetry

Performance and performance tuning

Data Quality, Protection, and Availability

Responsible for developing and implementing solutions related to Snowflake and preparing data for Business Intelligence

Fully document all solution work including designs and configurations

Play an essential role in troubleshooting data system problems and provide viable solution options

Requirements

Qualifications

Minimum 10 years of experience in IT with focus on Enterprise Data Solutions

Minimum 5 of years of experience in: Snowflake Data Solutions, hands-on

Data warehousing methodologies and modelling techniques Data migration methods of on-prem to cloud data solutions including ELT/ETL Tools and concepts

Working with Batch and Stream data

SQL, preferrable Snowflake SQL

Massively Parallel Processing (MPP) Analytical Datastores

Experience in Snowflake utilities including SnowSLQ, Snowpipe, Snowlight for handling Streaming data is a plus

Expertise in Snowflake advanced concepts like setting up resource monitors, RBAC controls, virtual warehouse sizing, query performance tuning, Zero copy clone, time travel and understand how to use these features

Experience in in re-clustering Snowflake data with good understanding of Micro-Partition within Snowflake

Expertise in deploying Snowflake features such as data sharing, events and lake-house patterns

Experience in handling semi-structured data (JSON, XML) in Snowflake

Minimum of 2 years of hands-on experience in Cloud technologies such as
o Azure - Blob Storage, Cool Blob Storage, Virtual Machine, Functions, SQL Datawarehouse

Certified Snowflake cloud data warehouse Architect (Desirable).

Should be able to troubleshoot problems across infrastructure, platform and application domains.

Must have experience of Agile development methodologies

Strong written communication skills. Is effective and persuasive in both written and oral communication

Deep understanding of relational as well as NoSQL data stores, methods and approaches (star and snowflake, dimensional modelling)

Education Requirements

Bachelor's degree in computer science, engineering, or Management Information Systems, or related IT field.

Position Type

Full time employee