Snowflake Data Engineer

We are seeking a dynamic Snowflake Data Engineer with proven expertise in Snow pipe data ingestion and foundational experience with Snowflake in an AWS Cloud environment. This role is hands-on, focusing on building, optimizing, and modernizing data pipelines for large-scale analytical platforms.

Key Responsibilities

Design, develop, and maintain Snow pipe-based automated data ingestion pipelines from diverse enterprise sources.

Integrate new data assets (structured & semi-structured) into Snowflake using cloud-native services and ETL tools.

Optimize pipeline performance, reliability, and monitoring to ensure timely and accurate data availability. Collaborate with Data Architects, business analysts, and application teams to translate requirements into scalable data workflows.

Troubleshoot, debug, and support Snow pipe ingestion jobs in production environments.

Implement basic data modeling and partitioning strategies in Snowflake (fact/dimension tables, streams, tasks).

Ensure cloud best practices for security, cost management, and compliance in an AWS-hosted Snowflake instance.

Document technical specifications, data flow diagrams, and operational runbooks.

Required Skills & Experience

3+ years hands-on experience as a Data Engineer in cloud or enterprise environments.

Practical expertise building Snow pipe data ingestion pipelines (creation, configuration, scheduling, troubleshooting).

Basic understanding of Snowflake architecture in AWS:

Warehouses, roles, resource monitors

Connecting Snowflake to S3 buckets

Data sharing and integration features

Strong SQL development skills (DML, DDL, query optimization).

Experience with ETL/ELT tools (dbt, Informatica, Talend, Matillion, or cloud-native alternatives).

Familiarity with scripting languages: Python preferred (for orchestration, transformation, or error handling). Experience working with semi-structured data formats (JSON, Parquet, Avro).

Basic AWS Cloud knowledge:

Understanding of S3, IAM, and networking concepts

Working with AWS-based Snowflake deployments

Excellent problem-solving and communication skills.

Preferred/Bonus Skills

Experience with streaming data integration (Kafka, Kinesis) into Snowflake.

Exposure to Snowflake utilities: Streams, Tasks, Materialized Views.

Familiarity with data monitoring and alerting tools. SnowPro Core Certification (optional).

Education

Bachelor’s degree in computer science, Engineering, Information Systems, or related field.