Snowflake Architect - Data Engineering
First seen by Alion on Oct 22, 2026.
Key Responsibilities :
- Architect, design, and implement Snowflake-based data solutions for enterprise clients across BFSI and other domains.
- Lead end-to-end data migration and modernization projects, transitioning legacy environments to Snowflake.
- Expertly configure and optimize Snowpipe for automated, scalable data ingestion from diverse sources.
- Define and implement data governance, security, and compliance protocols leveraging Snowflake features (RBAC, masking, etc.).
- Collaborate with business stakeholders and technical teams to translate requirements into high-performance data models and workflows.
- Develop reusable frameworks and accelerators for Snowpipe-based batch and real-time ingestion pipelines.
- Monitor and troubleshoot Snowpipe jobs, optimizing costs, performance, and reliability.
- Document best practices, technical architectures, and implementation approaches for Snowflake-centric ecosystems.
- Mentor and guide junior staff and engineers in Snowflake, Snowpipe, and cloud-native ETL development.
Required Skills & Experience :
- 12 - 15 years overall Data Architect experience including high-volume data warehouse and lakehouse platforms.
- Minimum 5 years hands-on experience with Snowflake : Advanced data modeling, schema design, performance tuning, account setup, security, and data sharing.
- Strong expertise in Snowpipe : Building, scheduling, and monitoring ingestion pipelines, integrating with cloud storage (AWS S3, Azure Blob, GCP), and automating ingestion/alerting.
- Proficiency in ETL/ELT tools : Informatica, Talend, Matillion, dbt, Azure/AWS native.
- Solid scripting/programming skills : SQL, Python or Scala (for UDFs and orchestration).
- Cloud data platform knowledge (Azure, AWS, GCP) with focus on security, roles, and data governance.
- Excellent communication skills for client-facing discussions and solution presentations.
- Experience with data migration, modernization, and CI/CD for data pipelines.
Preferred/Bonus Skills :
- Snowflake certification (SnowPro Core/Advanced).
- Experience with Kafka or streaming data integration.
- BFSI or regulatory compliance data projects.
- Experience architecting solutions for high-availability and disaster recovery scenarios.
Education :
- Bachelors/Masters in Computer Science, Engineering, or related discipline.
Skills
Data Architect, Data Warehousing, ETL, Snowflake DB, Data Engineering, DataLake, Data Management, Data Ingestion