What are the responsibilities and job description for the Snowflake engineer - NYC Onsite position at Staffingine LLC?
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.