Senior Cloud Data Engineer / Modern Data Stack Focus

Webstaurantstore; Lititz (Lancaster County); On-site; USD 120,000 - 180,000; Full time

Job summary

WebstaurantStore is seeking a Senior Cloud Data Engineer to architect and own the next generation of our cloud data ingestion and integration ecosystem. You will lead scalable, automated data pipelines into Snowflake and guide the migration from SQL Server to Snowflake while mentoring engineers and aligning with BI stakeholders.

You will partner with cross-functional teams to enable governed data movement, reliability, and scalable data products across the enterprise.

Responsibilities

• Lead design and implementation of a standardized ELT-based ingestion framework into Snowflake.
• Build scalable ingestion pipelines for structured and semi-structured data from APIs, databases, cloud storage, flat files, and collaboration platforms.
• Develop reusable Python libraries and ingestion accelerators to standardize engineering practices.
• Implement robust monitoring, logging, and data reliability engineering to ensure SLA adherence.
• Migrate from SQL Server to Snowflake.

Tools

Snowflake

Python

ELT

CI/CD

IaC

Job description

Job Summary

The Enterprise BI & Analytics Team serves as theenterprise data and analytics center of excellenceatWebstaurantStore. We transform billions of data points across marketing, supply chain, operations, and customer experience into trusted data foundations and actionable insights. Leveraging amodern cloud data platform, scalable ELT architecture, and automatedDataOpsworkflows, the team empowers smarter decisions, rapid growth, and new opportunities across the business.

As a Senior Cloud Data Engineer, you will architect and own the next generation of ourmodern data ingestion and integration ecosystem. You will lead the development of a unified ingestion framework into Snowflake—building scalable, automated, and high-throughput data pipelines that power analytics and data products enterprise-wide. You will play a key role in ourdata warehouse modernization initiative, guide our transition from SQL Server to Snowflake, mentor engineers, and help define the future state of our cloud data architecture.

Responsibilities

Senior Cloud Data Engineers arehands‑on technical leadersand trusted partnerstoBI developers, analytics engineers, and cross-functional teams. You will drive innovation across our ingeston layer and enable scalable, reliable, and governed data movement throughout the enterprise.

Core Responsibilities

Modern Data Engineering & ELT Architecture

• Lead the design and implementation of a standardizedELT-based ingestion frameworkinto Snowflake.
• Design scalable ingestion pipelines for structured and semi-structured data from APIs, databases, cloud storage, flat files, and collaboration platforms.
• Build andmaintainFabric Pipelines to supportcloud-native orchestration and pipeline automation.
• Develop reusable Python libraries and ingestion accelerators to standardize engineering practices.
• Implement robust monitoring, logging, anddata reliability engineering practicesto ensure SLA adherence.
• Refactor andoptimizelegacy ingestion processes to align with modern data stack best practices.
• Drive and support the migration from SQL Server to Snowflake.

Technical Leadership

• Act as thelead architect for enterprise ingestion strategy, mentoring engineers and guiding technical design decisions.
• Champion best practices inCI/CD, version control, automated testing, and infrastructure-as-code principleswithin the data engineering function.
• Perform code reviews and enforce architectural standards.
• Partner with BI leadership to plan capacity, prioritize initiatives, and executedeliveryroadmaps.
• Foster a culture of engineering ownership, accountability, and innovation.

Strategy & Execution

• Collaborate with business and analytics stakeholders to translate requirements into scalable ingestion designs.
• Evaluate emerging tools and technologies within themodern data stack ecosystem.
• Contribute to long-term cloud data strategy and architectural evolution.
• Ensure enterprise-grade governance, security, compliance, and data quality controls.