Snowflake Data Engineer

Role- Snowflake Data Engineer

Location- NYC, NY

Job Type: Fulltime

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.

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.