
Senior Snowflake Data Engineer
Steneral Consulting · Location not stated · Hybrid
Weak hiring record · median 125 days open
- 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
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- DevOps EngineerSteneral Consulting · Hartford, CT, United States · USD 50–55/hrtoday
- Android Mobile DeveloperSteneral Consulting · Remote · USD 45–50/hrtoday
- IT Infrastructure Support ConsultantSteneral Consulting · New York City, NY, United States · USD 80–85/hrtoday
- Senior Integration DeveloperSteneral Consulting · Orrville, OH, United States · USD 50–55/hrtoday
- Sr .NET DeveloperSteneral Consulting · Austin, TX, United States · USD 60–65/hrtoday
Similar roles
- Enterprise Data Analyst/ModelerCNRL Professional · Calgary, AB, Canadatoday
- Untitled roleIndependentsoftware · Location not statedtoday
- Untitled roleIndependentsoftware · Location not statedtoday
- Untitled roleIndependentsoftware · Location not statedtoday
- Untitled roleIndependentsoftware · Location not statedtoday
- Untitled roleIndependentsoftware · Location not statedtoday