Technology

Snowflake engineer - NYC Onsite

Staffingine LLCNew York, NY🇺🇸United StatesPosted Sep 27, 2026

Why This Role Stands Out

This role offers a fantastic opportunity to deepen your expertise in Snowflake and data engineering by designing and optimizing robust data models and pipelines. You'll thrive here if you're a mid-senior engineer passionate about performance tuning, data security, and collaborating within an Agile team environment. Apply today to make a significant impact with a leading company in NYC!

Quick Overview

Seniority

Mid Senior

Work mode

On Site

Location

New York, NY, United States

Posted

4 days ago

OracleSQLSnowflakeAgileHadoopdbt

Job Description

Job Title: Snowflake engineer
Job Location: NYC/onsite
Job Type: Full-Time

Job Description:

Design, develop, and optimize Snowflake data models (staging integration semantic/consumption layers) for institutional trade, position, reference, and market data.
Build ingestion pipelines using Snowpipe / Snowpipe Streaming, Streams & Tasks, Dynamic Tables, and external stages against S3.
Develop transformation logic in SQL and dbt with version control, CI/CD, and automated testing.
Tune performance and cost: warehouse right-sizing, clustering keys, micro-partition pruning, query profiling, result caching, resource monitors, and credit-consumption reporting.
Implement data security and entitlements: RBAC hierarchy, dynamic data masking, row access policies, secure views, and secure data sharing across LOBs.
Migrate legacy Oracle / Teradata / Sybase / Hadoop workloads to Snowflake, including reconciliation and parallel-run validation.
Partner with data governance on lineage, cataloging, data quality rules, and audit/regulatory evidence.
Support production: incident triage, root-cause analysis, SLA adherence, and on-call rotation for critical batch cycles.
Work in Agile squads with BAs, QA, and platform engineering; participate in design reviews and code reviews.