Gullview Technologies
Senior Snowflake Data Engineer
Gullview Technologies, Minneapolis, Minnesota, United States, 55400
Sr. Snowflake Data EngineerGullview 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 OverviewWe 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 RoleThe
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.ResponsibilitiesProvide understanding of Snowflake, Data Warehouse, Data Movement, Data Curation, and Data Staging best practices in relation to existing Snowflake implementationsProvide resolution to an extensive range of complicated data pipeline related problems, proactively and as issues surfaceBuild processes supporting data transformation, data structures, metadata, dependency and workload managementCreate and contribute to automation of essential processes related to infrastructure solution deployment creating repeatable and robust deploymentsProvide Snowflake solutions, including hands on keyboard (implementation)Overall ownership of the “platform” and supporting essential platform capabilitiesResponsible for day-to-day sustainment and configuration of the platform including
System Health and TelemetryPerformance and performance tuningData Quality, Protection, and Availability
Responsible for developing and implementing solutions related to Snowflake and preparing data for Business IntelligenceFully document all solution work including designs and configurationsPlay an essential role in troubleshooting data system problems and provide viable solution optionsRequirementsQualificationsMinimum 10 years of experience in IT with focus on Enterprise Data SolutionsMinimum 5 of years of experience in:
Snowflake Data Solutions, hands-onData warehousing methodologies and modelling techniques Data migration methods of on-prem to cloud data solutions including ELT/ETL Tools and conceptsWorking with Batch and Stream dataSQL, preferrable Snowflake SQLMassively Parallel Processing (MPP) Analytical Datastores
Experience in Snowflake utilities including SnowSLQ, Snowpipe, Snowlight for handling Streaming data is a plusExpertise 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 featuresExperience in in re-clustering Snowflake data with good understanding of Micro-Partition within SnowflakeExpertise in deploying Snowflake features such as
data sharing, events and lake-house patternsExperience in handling semi-structured data (JSON, XML) in SnowflakeMinimum of 2 years of hands-on experience in Cloud technologies such aso Azure - Blob Storage, Cool Blob Storage, Virtual Machine, Functions, SQL DatawarehouseCertified
Snowflake cloud data warehouse
Architect (Desirable).Should be able to troubleshoot problems across infrastructure, platform and application domains.Must have experience of Agile development methodologiesStrong written communication skills. Is effective and persuasive in both written and oral communicationDeep understanding of
relational
as well as
NoSQL data stores , methods and approaches (star and snowflake, dimensional modelling)Education RequirementsBachelor’s degree in computer science, engineering, or Management Information Systems, or related IT field.Position TypeFull time employee
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.ResponsibilitiesProvide understanding of Snowflake, Data Warehouse, Data Movement, Data Curation, and Data Staging best practices in relation to existing Snowflake implementationsProvide resolution to an extensive range of complicated data pipeline related problems, proactively and as issues surfaceBuild processes supporting data transformation, data structures, metadata, dependency and workload managementCreate and contribute to automation of essential processes related to infrastructure solution deployment creating repeatable and robust deploymentsProvide Snowflake solutions, including hands on keyboard (implementation)Overall ownership of the “platform” and supporting essential platform capabilitiesResponsible for day-to-day sustainment and configuration of the platform including
System Health and TelemetryPerformance and performance tuningData Quality, Protection, and Availability
Responsible for developing and implementing solutions related to Snowflake and preparing data for Business IntelligenceFully document all solution work including designs and configurationsPlay an essential role in troubleshooting data system problems and provide viable solution optionsRequirementsQualificationsMinimum 10 years of experience in IT with focus on Enterprise Data SolutionsMinimum 5 of years of experience in:
Snowflake Data Solutions, hands-onData warehousing methodologies and modelling techniques Data migration methods of on-prem to cloud data solutions including ELT/ETL Tools and conceptsWorking with Batch and Stream dataSQL, preferrable Snowflake SQLMassively Parallel Processing (MPP) Analytical Datastores
Experience in Snowflake utilities including SnowSLQ, Snowpipe, Snowlight for handling Streaming data is a plusExpertise 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 featuresExperience in in re-clustering Snowflake data with good understanding of Micro-Partition within SnowflakeExpertise in deploying Snowflake features such as
data sharing, events and lake-house patternsExperience in handling semi-structured data (JSON, XML) in SnowflakeMinimum of 2 years of hands-on experience in Cloud technologies such aso Azure - Blob Storage, Cool Blob Storage, Virtual Machine, Functions, SQL DatawarehouseCertified
Snowflake cloud data warehouse
Architect (Desirable).Should be able to troubleshoot problems across infrastructure, platform and application domains.Must have experience of Agile development methodologiesStrong written communication skills. Is effective and persuasive in both written and oral communicationDeep understanding of
relational
as well as
NoSQL data stores , methods and approaches (star and snowflake, dimensional modelling)Education RequirementsBachelor’s degree in computer science, engineering, or Management Information Systems, or related IT field.Position TypeFull time employee