JobHabor
Menu

Senior Snowflake Data Engineer

Steneral Consulting · Location not stated · Hybrid

Weak hiring record · median 125 days open

100100

Hiring signal

Actively hiring

Posted today · Never reposted · Checked today · How we score

First seen
16 November 2026
Reposted
Not since September 2026
Last checked
Today · still on the employer's board
All reasons
  • 77% of this employer's openings are over 60 days old
  • No location stated

In its favour

  • Posted yesterday
  • Still listed on the employer's own board
  • Publishes a salary range

Did you apply?

Senior Snowflake Data Engineer at Steneral Consulting. We’ll keep it in your applied jobs, so you can see it later and be warned before applying to the same employer twice.

Locals first for Hybrid if not get then 100 % for remote but must be in EST or CST

Please ensure candidates accurately represent their experience and are not using AI to tailor resumes specifically to this role. We are seeing too many candidates misrepresent their experience.

Important Screening Guidance

Please do not submit candidates who simply list Snowflake, SCD Type 2, or dimensional modeling as keywords.

Candidates must be able to explain specific production solutions they personally developed.

We are particularly interested in engineers who can explain:

  • How they have implemented SCD Type 2, including change detection, historical records, and effective dates.
  • Snowflake stored procedures they personally developed, including exception handling and transaction management.
  • How they use Snowflake query profiles to identify and resolve performance issues.
  • How they implement data quality checks and handle failed data loads.
  • How they optimize Snowflake performance, runtime, and warehouse costs.

The client needs a technically independent Senior Data Engineer who can build solutions, troubleshoot problems, and make sound engineering decisions without extensive guidance.

Position

Senior Snowflake Data Engineer

Location

Media, PA

Onsite

3–4 days per week — strongly prefer local candidates over relocations. If someone is very strong and Remote we will consider.

Duration

Through June 30, 2027, initially

Candidates must work directly for your company. No additional vendor layers.

Vendor Submission Requirements

Please provide

  • Candidate's full name
  • Current employer
  • Work authorization
  • Current location
  • Confirmation of onsite availability in Media, PA (3–4 days/week)
  • Availability/start date
  • Expected hourly rate
  • Updated resume with month/year employment dates

Position Overview

Wawa is seeking a highly experienced, hands-on Senior Snowflake Data Engineer to design, develop, optimize, and support enterprise data pipelines and dimensional data warehouse solutions.

This position requires someone who has personally built production Snowflake solutions and possesses a deep understanding of data warehousing fundamentals, stored procedures, SCD Type 2, data quality, transaction management, and performance optimization.

This is not an architecture or advisory role. We need someone who can independently develop, troubleshoot, and deliver production-quality data engineering solutions.

Key Responsibilities

  • Design, develop, and maintain enterprise data pipelines and transformations in Snowflake.
  • Develop complex SQL and Snowflake stored procedures.
  • Implement dimensional models, including star schemas and Snowflake schemas.
  • Develop and maintain Slowly Changing Dimensions (SCD Type 2).
  • Build data loading logic that correctly handles inserts, updates, unchanged records, and historical tracking.
  • Implement data quality checks, validation, and reconciliation.
  • Develop exception handling, transaction management, rollback, and recovery processes.
  • Analyze Snowflake query profiles and troubleshoot performance bottlenecks.
  • Optimize Snowflake queries, data loads, warehouse utilization, and consumption costs.
  • Perform unit testing and support QA/UAT activities.
  • Troubleshoot production data issues and determine appropriate remediation.
  • Work independently after initial onboarding while collaborating with technical leads.

Required Technical Skills

MUST HAVE

  • Deep hands-on Snowflake data engineering experience.
  • Advanced SQL development.
  • Hands-on Snowflake stored procedure development.
  • Strong understanding of exception handling, transactions, and rollback.
  • Deep knowledge of dimensional data warehousing.
  • Hands-on SCD Type 2 implementation.
  • Experience with star schemas and Snowflake schemas.
  • Production data pipeline development and maintenance.
  • Data quality checks, validation, and reconciliation.
  • Snowflake query profiling and performance optimization.
  • Experience optimizing warehouse utilization and cost.
  • Strong troubleshooting and production support experience.

Preferred

  • AI-assisted coding tools such as Snowflake Cortex Code, Claude Code, or GitHub Copilot.
  • Experience migrating workloads from Databricks to Snowflake.
  • Data lineage and governance knowledge.

More jobs at Steneral Consulting

All 5,661

Similar roles