Lead Snowflake Data Engineer

Elios AI

New York (NY)

On-site

USD 120,000 - 160,000

Full time

14 days+

A complete application in a minute

Tailored resume and cover letter, ready to send.

Get past ATS filters

Job summary

Elios AI is seeking a senior Lead Data Engineer for a fully onsite contract engagement in New York, NY. This role requires ownership of production-grade data platforms using Snowflake, covering ingestion, transformation, and delivery.

The ideal candidate will have deep expertise in query tuning, clustering, and data governance, along with experience in AWS and Python. This senior-level position entails significant technical leadership and collaboration with various stakeholders.

Qualifications

  • Deep hands-on expertise with Snowflake, specifically with query tuning and clustering strategies.
  • Experience in building end-to-end data platforms with Snowflake in a cloud environment.
  • Ability to explain and defend architecture decisions in client-facing scenarios.

Responsibilities

  • Architect scalable ELT pipelines for large-scale cloud data workloads.
  • Design and optimize dimensional models and data marts.
  • Mentor engineering teams and take active coding responsibilities.

Skills

Snowflake
Python
PySpark
AWS
Data governance
Data security
Query optimization
Client-facing delivery
Dimensional modeling
React

Job description

Snowflake Cortex AI PySpark ELT Dimensional modeling Query optimization Clustering keys Micro-partitioning Warehouse scaling Data marts Distributed processing Data governance Data security AWS Client-facing delivery Python SQL React

Job Description

We are seeking a senior Lead Data Engineer for a fully onsite contract engagement in New York, NY with a global consulting firm serving large financial services and enterprise clients. This role owns the end-to-end design, development, and delivery of production-grade data platforms in Snowflake, from ingestion through transformation, modeling, and consumption. The engineer will architect scalable ELT pipelines, design dimensional models and data marts, build backend data services in Python and PySpark, and optimize performance across large-scale cloud data workloads. The role requires deep hands-on expertise with Snowflake, including query tuning, clustering strategy, warehouse scaling, micro-partitioning, and cost-performance tradeoff decisions, along with hands-on experience integrating Snowflake Cortex AI for advanced analytics and intelligent data products. This person will also enforce data governance, security, and compliance standards, partner with analytics, business, and engineering stakeholders, and operate in a client-facing capacity where they must clearly explain and defend architecture decisions. AWS experience is preferred, and working knowledge of React is helpful for collaboration on user-facing data products. This is a senior technical leadership role with meaningful architectural ownership, active coding responsibility, and mentorship of engineering teams.

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Lead Snowflake Data Engineer
Lead Snowflake Data Engineer

Elios, Inc. • New York (NY)

Hybrid
USD 150,000 - 190,000
Senior Snowflake Engineer
Senior Snowflake Engineer

Spyrosoft Ltd • United States

Remote
USD 120,000 - 180,000
Senior Snowflake Engineer - Technical Lead
Senior Snowflake Engineer - Technical Lead

Apollopros • South San Francisco (CA)

Hybrid
USD 152,000 - 234,000
Lead Snowflake Data Engineer - Onsite NY, Cloud Pipelines
Lead Snowflake Data Engineer - Onsite NY, Cloud Pipelines

Omm IT Solutions • New York (NY)

On-site
USD 180,000 - 260,000
Senior Snowflake Data Architect & ELT Lead
Senior Snowflake Data Architect & ELT Lead

Elios, Inc. • New York (NY)

Hybrid
USD 150,000 - 190,000
Lead / Principal Snowflake Engineer
Lead / Principal Snowflake Engineer

Anblicks Inc. • Dallas (TX)

On-site
USD 135,000 - 165,000
Snowflake Data Lead/ Architect
Snowflake Data Lead/ Architect

DATAECONOMY Inc • New York (NY)

On-site
USD 150,000 - 210,000
Lead Data Engineer
Lead Data Engineer

Madison-Davis • New York (NY)

On-site
USD 150,000 - 190,000
Lead Snowflake Data Engineer
Lead Snowflake Data Engineer

TechDigital Group • Rosemont (IL)

On-site
USD 120,000 - 145,000
Senior Snowflake Data Engineer - Talent Pipeline
Senior Snowflake Data Engineer - Talent Pipeline

BlueCloud • United States

On-site
USD 150,000 - 210,000