← Back to jobs

United IT Solutions Logo
Snowflake Data Engineer

United IT Solutions

 

New York City, NY, USA

Posted On: Just posted
Experience: 7+ years
Availability: Onsite
Openings: 1
Category: Snowflake Data Engineer
Tenure: No Preference/Any
Related Jobs

No related jobs found

Description

Build and scale cloud data products on Snowflake, owning pipelines end-to-end from ingestion through curated consumption layers.

This role is on-site.

Responsibilities

  • Design and optimize Snowflake data models across staging, integration, and semantic layers for trade, position, and market data.
  • Build ingestion pipelines using Snowpipe, 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 via warehouse right-sizing, clustering, query profiling, and credit-consumption reporting.
  • Implement data security (RBAC, masking, row access policies) and migrate legacy Oracle/Teradata/Hadoop workloads.

Required Skills

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

Preferred Skills

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

Education

Any Graduate

Related Jobs

No related jobs found

← Back to jobs