Senior Cloud Data Engineer: Snowflake ELT & Modernization

Webstaurantstore; Lititz (Lancaster County); On-site; USD 140,000 - 195,000; Full time

Benefits offered by this job

Medical

Vision

Dental

PTO

Paid Maternity Leave

Paid Parental Leave

Life Insurance

Disability

401(k) matching

Bonus Opportunities

Employee Discounts

Company Discounts

AT&T & Verizon Discount

Wellness Incentives

Adoption Assistance

Job summary

WebstaurantStore is seeking a Senior Cloud Data Engineer to own the next generation of our data ingestion and integration ecosystem, guiding Snowflake modernization and migration from SQL Server.

You will mentor engineers, design scalable ELT pipelines, develop reusable data libraries, and partner with BI leadership to deliver enterprise-wide data products with strong governance and reliability.

Qualifications

• Bachelor’s degree or equivalent experience in CS/Engineering/IS.
• 7–10 years data engineering or cloud data development experience.
• 5+ years Snowflake ingestion architecture, performance optimization, and workload management.
• 4–6 years building pipelines using Fabric Pipelines or comparable orchestration frameworks.
• 4–6 years Python development for data automation and pipeline engineering.
• 5+ years advanced SQL experience, including SQL Server and CDC.
• 5+ years Agile/Scrum delivery experience.
• 3+ years in technical leadership within data engineering initiatives.
• Experience with event-based ingestion and streaming pipelines.
• Experience with Qlik Replicate and dbt Cloud.
• Microsoft Azure experience.
• Relevant cloud or data platform certifications preferred.

Responsibilities

• Lead design and implementation of a standardized ELT-based ingestion framework into Snowflake.
• Design scalable ingestion pipelines for structured and semi-structured data from APIs, databases, cloud storage, flat files, and collaboration platforms.
• Build and maintain Fabric Pipelines for cloud-native orchestration and pipeline automation.
• Develop reusable Python libraries and ingestion accelerators to standardize engineering practices.
• Implement robust monitoring, logging, and data reliability engineering to ensure SLAs.
• Refactor and optimize legacy ingestion processes to align with modern data stack best practices.
• Drive and support the migration from SQL Server to Snowflake.
• Act as the lead architect for enterprise ingestion strategy and mentor engineers.
• Champion CI/CD, version control, automated testing, and IaC in data engineering.
• Collaborate with BI leadership to plan capacity, priorities, and roadmaps.
• Ensure governance, security, and data quality controls.

Skills

Snowflake

Fabric Pipelines

Python

SQL

Agile/Scrum

Data Ingestion

Cloud Data Platforms

CI/CD

Data Modeling

Leadership

Education

Bachelor’s degree in CS/Engineering/IS

Tools

Microsoft Fabric Pipelines

Qlik Replicate

dbt Cloud

Microsoft Azure

Snowflake

Job description

WebstaurantStore is seeking a Senior Cloud Data Engineer to own the next generation of our data ingestion and integration ecosystem, guiding Snowflake modernization and migration from SQL Server.

You will mentor engineers, design scalable ELT pipelines, develop reusable data libraries, and partner with BI leadership to deliver enterprise-wide data products with strong governance and reliability.