Start searching
Back to Jobs
Recently postedTechnology

Snowflake engineer - NYC Onsite

Staffingine LLCNew York, NY🇺🇸United States

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

SeniorityMid Senior
Work modeOn Site
LocationNew York, NY, United States
OracleSQLSnowflakeHadoopdbtAgileCI/CD

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.

Similar jobs

Apply