JobHabor
Menu

Snowflake Data Engineer

Expert In Recruitment Solutions · Media, PA

Strong hiring record · median 21 days open

100100

Hiring signal

Actively hiring

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

First seen
17 November 2026
Reposted
Not since September 2026
Last checked
Today · still on the employer's board
All reasons

In its favour

  • Posted today
  • Still listed on the employer's own board

Did you apply?

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

Title

Senior Snowflake Data Engineer

Location

Media, PA - 3–4 days per week — strongly prefer local candidates over relocations.

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 and will remove vendors who submit them. We would much prefer 1–2 highly qualified candidates over multiple subpar submissions.

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

Position Overview

Customer 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.

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.

More jobs at Expert In Recruitment Solutions

All 173

Similar roles