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