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