Description

You will manage data ingestion and transformation workflows within a Snowflake and AWS environment.

Responsibilities

• Design and implement Snowpipe to automate data ingestion from Amazon S3 into Snowflake.
• Utilize Snowflake Streams to capture and manage data changes.
• Write and maintain stored procedures to process and transform data across Snowflake layers.
• Optimize Snowflake performance through query tuning and storage cost management.
• Diagnose and resolve issues related to data ingestion, transformation, and Snowflake operations.

Required Skills

• 10+ years of IT experience, including at least 4 years of hands-on Snowflake experience.
• Proven expertise with Snowpipe for data ingestion and Snowflake Streams for change data capture.
• Advanced SQL skills for complex queries, data manipulation, and performance optimization.
• Deep understanding of Snowflake architecture, features, and best practices.
• Experience integrating Snowflake with Amazon S3.
• Strong knowledge of ETL processes, data warehousing, data modeling, and data governance.
• Basic experience with AWS services, specifically Amazon S3.
• Bachelor’s degree in Computer Science, Information Technology, or a related field.

Preferred Skills

• Snowflake certification(s).
• Programming experience with Python or JavaScript.
• Advanced degree in a technical field.

Key Skills

Education

Bachelor’s degree in Computer Science, Information Technology, or a related field. Advanced degrees are a plus.