Snowflake Data Engineer
Expert In Recruitment Solutions · Media, PA
Strong hiring record · median 21 days open
- 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
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- Back-End Salesforce Marketing Cloud DeveloperExpert In Recruitment Solutions · Tampa, FLtoday
- Apriso Support Developer (O&M Support)Expert In Recruitment Solutions · Remote, ILtoday
- ETL DeveloperExpert In Recruitment Solutions · Melbourne, FLtoday
- Full Stack DeveloperExpert In Recruitment Solutions · Englewood, COtoday
- Automation EngineerExpert In Recruitment Solutions · San Antonio, TXtoday
Similar roles
- Data Management Specialist - Data EngineerJobgether · UStoday
- Data Engineer II, JVMPlayStation Global · United States, Austin, TX · USD 150,100–225,100/yrtoday
- Data Engineer AstronomerPinnacle Bank, a Tennessee bank, d/b/a Synovus Bank · Atlanta, GA, United States · Roswell, GA, United Statestoday
- Sr Data ScientistCastellum · Alexandria, VA, United States · USD 170,000–184,000/yrtoday
- Founding Data EngineerClera · San Francisco · USD 170,000–200,000/yrtoday
- Business Systems & Data EngineerHpe · Chippewa Falls, Wisconsin, United States of AmericaUpdated today