Role Overview :

We are seeking a dynamic Snowflake Data Engineer with proven expertise in Snowpipe 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 Snowpipe-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 Snowpipe 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 Snowpipe data ingestion pipelines (creation, configuration, scheduling, troubleshooting).

- Basic understanding of Snowflake architecture in AWS (Warehouses, roles, resource monitors, S3 buckets, data sharing).

- 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.

- Experience working with semi-structured data formats (JSON, Parquet, Avro).

- Basic AWS Cloud knowledge (S3, IAM, networking).

Preferred/Bonus Skills :

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

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

- SnowPro Core Certification (optional).

Education :

- Bachelors degree in computer science, Engineering, Information Systems, or related field.