AWS Engineer with Snowflake Job at GATE Insight, Inc., Franklin, TN

cG90eWFoNnhCampKWEtMaitnaDBmTTVlbkE9PQ==
  • GATE Insight, Inc.
  • Franklin, TN

Job Description

Position : AWS Engineer with Snowflake Location :- Franklin TN (Day 1 onsite) Duration : Long Term Overall 10yrs experience Key skills :- Strong AWS with some snowflake Exp Responsibilities:

  • Design, implement, and manage Snowpipe to automate and streamline the ingestion of data files from Amazon S3 into Snowflake.
  • Ensure the reliability and timeliness of data ingestion processes, and monitor their performance.
  • Utilize Snowflake Streams to capture and manage changes in data.
  • Write and maintain stored procedures to process, transform, and move data between different layers within Snowflake.
  • Optimize Snowflake performance through query tuning and managing storage costs.
  • Collaborate with data architects, data analysts, and other team members to understand data requirements and align with project goals.
  • Coordinate with stakeholders to identify and resolve data-related issues or improvements.
  • Diagnose and resolve issues related to data ingestion, transformation, and Snowflake operations.
  • Provide support for ongoing maintenance and enhancement of Snowflake data solutions.
  • Develop and maintain comprehensive documentation for Snowflake architecture, data pipelines, transformation processes, and best practices.
Required Skills:
  • Minimum of 10+ years of experience in IT, including at least 4 years of hands-on experience with Snowflake.
  • Proven experience with Snowflake's Snowpipe for data ingestion, Snowflake Streams for change data capture, and stored procedures for data processing and transformation.
  • In-depth knowledge of Snowflake's architecture, features, and best practices.
  • Strong understanding of integrating Snowflake with Amazon S3 for data ingestion and management.
  • Advanced SQL skills, including the ability to write complex queries, perform data manipulation, and optimize query performance.
  • Comprehensive knowledge of data warehousing concepts, data modeling, ETL processes, and data governance.
  • Strong analytical skills for troubleshooting and resolving complex data issues and performance problems.
  • Excellent communication skills to convey technical information clearly to non-technical stakeholders.
  • Ability to work collaboratively with team members and stakeholders across different departments.
  • Basic experience with AWS services, including fundamental understanding and use of services such as Amazon S3.
Preferred Skills:
  • Snowflake certification(s) is a plus.
  • Experience with programming languages such as Python or JavaScript GATE Insight, Inc.

Job Tags

Similar Jobs

Sterling Consulting Solutions, Inc.

Home-Based Appointment Setter (Entry Level) Job at Sterling Consulting Solutions, Inc.

 ...Job Title: Home-Based Appointment Setter (Entry Level) Location: Remote Job Responsibilities: Data Entry and Record Management: Maintain accurate records of bookings, payments, and customer interactions using our CRM system. Schedule Appointments : Schedule... 

WeConnect International Inc

Accounts Receivable and Budget Manager Job at WeConnect International Inc

 ...Job Description Job Description Job Title: Accounts Receivable and Budget Manager Department: Operations Location: Washington, DC Metropolitan Area - Hybrid FLSA Status: Exempt Reporting to: Chief Operating Officer ____________________________________... 

Tutoring of Nashville

Private Tutor - ACT Test Prep Job at Tutoring of Nashville

 ...organization and we are fully invested in the success of our students, tutors, and employees. We provide in-home, one-on-one tutoring for...  ...:We are looking for an experienced and highly qualified private tutor to assist high school students in their preparation for the... 

The Pingry School

Upper School Biology/ Chemistry Teacher Job at The Pingry School

 ...Teaching 3 sections of Biology and/or Chemistry with lab. Supervise student research lab during morning and afternoon research periods, providing mentorship in conducting research safely and with scientific soundness. Serve as an advisor to a group of students.... 

Perth Amboy Public Schools

ESL Teacher Job at Perth Amboy Public Schools

Position Type: Elementary School Teaching/ESL Date Posted: 2/9/2024 Location: Dual Language School Description: Must have ESL Certification Attachment(s): ~ Click here for Job Description Perth Amboy Public Schools