Search Jobs | Dice.com

Job Details

Skills

Data Engineering
Snowflake
Snow Flake Schema
Teradata
Terraform
Reporting
Data Masking
Data Governance
Data Security
Amazon S3
Amazon Web Services
Apache Hadoop
Financial Services

Summary

Role- Snowflake Data Engineer

Location- New York City NY - 3 days hybrid in a week

Note: Prefer local to NJ or NY candidates We are looking for 8+ years of exp.

Role Overview

Build and scale cloud data products on Snowflake supporting institutional trading, risk, and regulatory reporting. This is a hands-on build role — you will own pipelines end-to-end from ingestion through curated, governed consumption layers used by front-office, risk, and control functions.

Key Responsibilities

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.

Required Qualifications

8+ years in data engineering; 4+ years hands-on Snowflake in a production environment.
Expert SQL — window functions, CTEs, complex joins, query optimization, execution plan analysis.
dbt (Core or Cloud) — models, macros, snapshots, tests, exposures.
Orchestration: Airflow, Control-M, or Autosys.
AWS: S3, IAM, Glue, Lambda, Secrets Manager.
CI/CD and IaC: Git, Jenkins/GitHub Actions, Terraform or Schema change for Snowflake object deployment.
Dimensional and Data Vault modeling; slowly changing dimensions; late-arriving data handling.
Demonstrated Snowflake cost-governance ownership (not just development).

Preferred / Differentiators

SnowPro Core / Advanced Data Engineer certification.
Prior tier-1 investment bank or large financial-services experience.

Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.

Dice Id: 91173508
Position Id: 9041707
Posted 9 hours ago

Fitment

Dice Job Match Score™

⭐ Evaluating experience...

Contact the job poster

Nikhil Pathania

staffing specialist @ SVARA SOFTWARE SOLUTIONS INC

View Profile

Create job alert

Never miss an opportunity! Create an alert based on the job you applied for.

Similar Jobs

Snowflake Data Engineer

New York, New York

•

Today

Job Title: Snowflake Data Engineer Location: NY - NJ Role Overview: Build and scale cloud data products on Snowflake supporting institutional trading, risk, and regulatory reporting. This is a hands-on build role - you will own pipelines end-to-end from ingestion through curated, governed consumption layers used by front-office, risk, and control functions. Key Responsibilities: Design, develop, and optimize Snowflake data models (staging integration semantic/consumption layers) for institutio

Easy Apply

Full-time

Snowflake engineer - NYC Onsite

New York, New York

•

6d ago

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

Easy Apply

Full-time

Snowflake Data Engineer

New York, New York

•

Today

CTG is seeking a skilled Snowflake Data Engineer to join our client's growing data engineering team. This role is ideal for a data professional with strong Snowflake expertise who enjoys designing scalable cloud data warehouses, building high-performance ELT pipelines, and delivering reliable data solutions that power enterprise analytics. You'll collaborate with cross-functional teams to develop secure, optimized, and scalable data platforms in a cloud environment. Location: New York, NY Durat

Full-time

Snowflake Data Governance Steward (Engineer 3) - FreeWheel

New York, New York

•

Today

FreeWheel, a Comcast company, provides comprehensive ad platforms for publishers, advertisers, and media buyers. Powered by premium video content, robust data, and advanced technology, we're making it easier for buyers and sellers to transact across all screens, data types, and sales channels. As a global company, we have offices in nine countries and can insert advertisements around the world. Job Summary As a Snowflake Data Governance Steward/Engineer 3 on FreeWheel's Data Management and Plat

Full-time

USD 118,449.51 - 177,674.27 per year

Filter Results

Job post features

Posted date

Work settings

Employment type

Distance

Employer type

Work authorization

Full Time : Need Snowflake Data Engineer

Skills

Summary

Role Overview

Key Responsibilities

Required Qualifications

Preferred / Differentiators

Dice Job Match Score™

Nikhil Pathania

Similar Jobs

Full Time : Need Snowflake Data Engineer

Job Details

Skills

Summary

Role Overview

Key Responsibilities

Required Qualifications

Preferred / Differentiators

Dice Job Match Score™

Nikhil Pathania

Similar Jobs