AIT Global, Inc.
AIT Global, Inc.

Snowflake Data Engineer

New York, NY, US • Posted 4 hours ago • Updated 4 hours ago
Full Time
On-site
Fitment

Dice Job Match Score™

📊 Calculating match score...

Job Details

Skills

  • sql
  • hadoop
  • oracle
  • Jenkins
  • Sybase
  • S3
  • CI/CD
  • Git
  • Snowflake
  • Teradata

Summary

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 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:
  • 7+ 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: 10106248
  • Position Id: 2026-4320/138041
  • Posted 4 hours ago
Create job alert
Set job alertNever miss an opportunity! Create an alert based on the job you applied for.

Similar Jobs

Full Time : Need Snowflake Data Engineer

New York, New York

•

Today

Easy Apply

Full-time

110,000 - 120,000

Snowflake engineer - NYC Onsite

New York, New York

•

6d ago

Easy Apply

Full-time

Snowflake Data Engineer

New York, New York

•

Today

Full-time

Snowflake Solution Architect

Hybrid in New York, New York

•

Today

Easy Apply

Full-time

Depends on Experience

Search all similar jobs
More jobs at AIT Global, Inc. in New York, NY