Get a reply from this employer
Your resume and cover letter, tailored to exactly what they’re hiring for.
Healthcare Triangle, Inc. is seeking a Senior Snowflake Developer Specialist to design and optimize a next‑generation data platform. You will build scalable ETL/ELT pipelines in Snowflake using dbt, implement CDC and delta processing, and optimize performance with advanced SQL and Python.
You will work with cloud platforms (AWS/Azure/GCP) and CI/CD pipelines to ensure robust, scalable and auditable data flows. Strong collaboration across teams is essential.
Role: Senior Snowflake Developer
Location: NY, NJ
Duration: C2H / FTE
Senior Snowflake Developer Specialist in dbt, CDC & Delta ProcessingWe are looking for a Senior Snowflake Developer with strong expertise in dbt (Data Build Tool), Change Data Capture (CDC), and Delta Processing to design, build, and optimize our next-generation data platform. In this role, you will be responsible for building scalable data pipelines, implementing efficient data transformation layers, and managing real-time/near-real-time data streaming architectures. The ideal candidate possesses deep technical knowledge of Snowflake architecture, advanced data modeling using dbt, and efficient patterns for handling incremental data processing.
Design, develop, and maintain robust, scalable ETL/ELT pipelines within Snowflake using SQL, Python, and modern data stack tools.
Architect and manage the dbt environment (dbt Core or dbt Cloud). Write modular, highly optimized dbt models, macros, and tests, ensuring clean data lineage and documentation.
Implement and optimize continuous data ingestion and Change Data Capture (CDC) mechanisms from various source systems (Transactional DBs, SaaS APIs) into Snowflake using tools like Snowflake Pipes (Snowpipe), Streams, Tasks, or external replication tools (e.g., Fivetran, Debezium, Qlik).
Design efficient Delta processing architectures utilizing dbt incremental models, Snowflake Streams, and merge strategies to process only modified or new data, minimizing compute costs and latency.
Optimize complex SQL queries, dbt models, clustering keys, and virtual warehouse configurations to ensure optimal query performance and cost-efficiency.
Implement automated data quality checks, data masking, row-level security, and role-based access control (RBAC) within Snowflake.
Deep understanding of Snowflake architecture (Cloud Services, Virtual Warehouses, Storage), semi-structured data handling (JSON, Parquet), Time Travel, Zero-Copy Cloning, and Snowpark.
Proven experience with dbt engineering, including complex macro development, incremental model strategies, package management, and performance tuning at scale.
Hands-on experience capturing real-time or near-real-time source changes using Snowflake Streams & Tasks, Kafka, or log-based CDC tools.
Strong grasp of delta logic, idempotency, slowly changing dimensions (SCD Type 1/2/4), and transaction handling.
Expert-level SQL proficiency (analytical functions, window functions, query optimization) and solid experience with Python for data processing.
Experience working with cloud ecosystems (AWS, Azure, or Google Cloud Platform) and managing external stages.
Familiarity with Git, CI/CD pipelines (GitHub Actions, GitLab CI) for deploying dbt code and Snowflake schema changes (e.g., using Schemachange or dbt commands).