YOUR ROLE
Snowflake Expert Developer
Experience: 10+ years of Snowflake development experience
Practice: Data Engineering
About the Role
We are seeking a highly experienced Snowflake Expert Developer to lead the design, development, optimization, and management of end-to-end data pipelines on the Snowflake platform. The ideal candidate will have deep expertise in modern data engineering practices and a strong track record of delivering scalable, secure, and high-performance data solutions.
In this role, you will be responsible for building and maintaining data pipelines from ingestion through transformation to consumption, working across batch, micro-batch, and real-time processing patterns. You will leverage the full Snowflake ecosystem to enable efficient, reliable, and governed data operations that support enterprise analytics and business initiatives.
The successful candidate will bring hands-on experience across the Snowflake data engineering stack, a strong understanding of cloud-based data architectures, and the ability to drive solutions from design through production support and optimization.
YOUR PROFILE
What You'll Do
- Design and build end-to-end ELT pipelines following the Stage → Raw → Stream → Task → Target pattern.
- Set up and manage automated, near real-time data ingestion using Snowpipe and low-latency, event-based streaming ingestion using Snowpipe Streaming.
- Configure Internal and External Stages to ingest data from Amazon S3, Azure Blob Storage, and Google Cloud Storage (GCS), including appropriate file formats and External Tables for semi-structured and unstructured data.
- Implement Streams for Change Data Capture (CDC) covering inserts, updates, and deletes, and orchestrate pipelines using Tasks and DAG-based Task Graphs.
- Build SQL-based ELT transformations and Dynamic Tables for continuous transformation pipelines, and extend transformations using Snowpark (Python, Java, or Scala) where required.
- Manage Virtual Warehouses and the broader storage layer, including tables, schemas, and centralized data structures.
- Integrate native connectors such as Kafka and Kinesis, and work with external ETL/ELT tools including Azure Data Factory (ADF), Airbyte, and AWS Glue.
- Leverage Snowflake Openflow for enterprise-scale data integration and CDC use cases.
- Build data validation, monitoring, and pipeline observability capabilities from the outset.
- Apply strong governance, security, and access control best practices across all pipelines, and integrate with Collibra where applicable.
What We're Looking For
- 10+ years of hands-on experience in Snowflake development.
- Working knowledge of Snowflake Openflow, Snowflake CoCo, and Cortex Cost Management.
- Strong expertise in CDC (Change Data Capture) and incremental data processing techniques.
- Experience working with batch, micro-batch, and real-time ingestion patterns.
- A builder's mindset with the ability to own data pipelines end-to-end, from architecture and development through production deployment and monitoring.