Snowflake Engineer - ETL Tools
First seen by Alion on Nov 12, 2026.
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.
Skills
Data Engineering, Snowflake DB, Data Pipeline, ETL, ETL Tools, Data Ingestion, AWS, Python, Data Integration