Moder - Snowflake Architect - Data Engineering

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.