Senior Snowflake Developer | NY, NJ | Contract (C2H) / FTE

Healthcare Triangle, Inc.

New York (NY)

On-site

USD 140,000 - 190,000

Full time

16 hours ago
Be an early applicant

Get a reply from this employer

Your resume and cover letter, tailored to exactly what they’re hiring for.

Get past ATS filters

Job summary

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.

Qualifications

  • Proven experience designing scalable data pipelines in Snowflake.
  • Strong knowledge of dbt modeling, incremental processing, and data lineage.
  • Hands-on CDC and real-time/near-real-time ingestion architectures.
  • Expert SQL and Python for data transformations and tooling.

Responsibilities

  • Design, develop, and maintain ETL/ELT pipelines in Snowflake.
  • Architect and manage dbt environment with modular models and tests.
  • Implement CDC, Snowpipe, Streams, and Tasks with external tools as needed.
  • Build efficient Delta processing, merge strategies, and cost-aware patterns.
  • Perform performance tuning of queries, models, and warehouse config.
  • Enforce data governance, quality checks, and RBAC within Snowflake.

Skills

Snowflake architecture
Advanced dbt
CDC & Stream Processing
Delta processing
SQL
Python
Cloud platforms (AWS/Azure/GCP)
DevOps for data (GitHub Actions, CI/CD

Education

Tools

Snowpipe
Snowflake Streams
Tasks
dbt Cloud
Fivetran
Debezium
Kafk a
Schemachange

Job description

Role: Senior Snowflake Developer

Location: NY, NJ

Duration: C2H / FTE

Job Description

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.

Key Responsibilities
Data Pipeline & Architecture

Design, develop, and maintain robust, scalable ETL/ELT pipelines within Snowflake using SQL, Python, and modern data stack tools.

dbt Transformation Layer

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.

CDC & Ingestion

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).

Delta & Incremental Processing

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.

Performance Tuning

Optimize complex SQL queries, dbt models, clustering keys, and virtual warehouse configurations to ensure optimal query performance and cost-efficiency.

Data Governance & Quality

Implement automated data quality checks, data masking, row-level security, and role-based access control (RBAC) within Snowflake.

Required Skills & Qualifications
Snowflake Expertise

Deep understanding of Snowflake architecture (Cloud Services, Virtual Warehouses, Storage), semi-structured data handling (JSON, Parquet), Time Travel, Zero-Copy Cloning, and Snowpark.

Advanced dbt

Proven experience with dbt engineering, including complex macro development, incremental model strategies, package management, and performance tuning at scale.

CDC & Stream Processing

Hands-on experience capturing real-time or near-real-time source changes using Snowflake Streams & Tasks, Kafka, or log-based CDC tools.

Delta Processing & Handling

Strong grasp of delta logic, idempotency, slowly changing dimensions (SCD Type 1/2/4), and transaction handling.

Languages

Expert-level SQL proficiency (analytical functions, window functions, query optimization) and solid experience with Python for data processing.

Cloud Platforms

Experience working with cloud ecosystems (AWS, Azure, or Google Cloud Platform) and managing external stages.

DevOps for Data

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).

Preferred Qualifications
  • Snowflake Certified Data Engineer (or Advanced Certified).
  • Experience migrating legacy ETL workflows (e.g., Informatica, Talend, stored procedures) into Snowflake/dbt.
  • Experience with Iceberg tables or Databricks Delta Lake integration with Snowflake.
Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Senior Snowflake DBT Engineer – ELT & Data Modeling Leader
Senior Snowflake DBT Engineer – ELT & Data Modeling Leader

Compunnel Inc. • Irvine (CA)

On-site
USD 120,000 - 150,000
Senior Snowflake Architect: Lead Data Solutions
Senior Snowflake Architect: Lead Data Solutions

Compunnel Inc. • Alpharetta (GA)

Hybrid
USD 180,000 - 240,000
Senior Snowflake Developer (Snowflake + dbt )
Senior Snowflake Developer (Snowflake + dbt )

Anblicks • Dallas (TX)

On-site
USD 140,000 - 190,000
Snowflake Architect
Snowflake Architect

Compunnel Inc. • Alpharetta (GA)

On-site
USD 180,000 - 240,000
Snowflake DBT Engineer
Snowflake DBT Engineer

Compunnel Inc. • Irvine (CA)

On-site
USD 120,000 - 150,000
Senior DBT/Snowflake Developer
Senior DBT/Snowflake Developer

Go Fractional • New York (NY)

Remote
USD 96,000 - 152,000
Sr. Snowflake Data Engineer
Sr. Snowflake Data Engineer

BravoTECH • Plano (TX)

On-site
USD 120,000 - 150,000
Senior Data Engineer
Senior Data Engineer

Eliassen Group • United States

Remote
USD 101,000 - 162,000
Senior Data Engineer
Senior Data Engineer

Anblicks • Dallas (TX)

On-site
USD 100,000 - 130,000
Data Engineer (Snowflake) | Jobs in US
Data Engineer (Snowflake) | Jobs in US

DigitalXNode • United States

Remote
USD 140,000 - 190,000