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

📌 Moder - Snowflake Engineer - ETL Tools (India)
🏢 Moder Solutions
📍 India