Senior Cloud Data Engineer / Modern Data Stack Focus

WebstaurantStore

Lititz (Lancaster County)

Hybrid

USD 140,000 - 200,000

Full time

2 days ago

Be an early applicant

Get more replies from employers

Send a job-specific resume in minutes.

Benefits offered by this job

Medical

Dental

401(k) matching

Paid PTO

Bonus Opportunities

Job summary

WebstaurantStore is hiring a Senior Cloud Data Engineer to architect and own the modernization of our data ingestion and integration ecosystem. You will lead Snowflake onboarding, migrate from SQL Server, mentor engineers, and shape our cloud data architecture across analytics, marketing, supply chain, and operations.

Join a fast-growing data platform team building scalable pipelines, reusable libraries, and robust observability to enable enterprise-wide data products and trusted insights.

Qualifications

Bachelor’s degree in Computer Science, Engineering, Information Systems, or related discipline; or equivalent experience.
7–10 years of experience in data engineering or cloud data development roles.
5+ years of hands‑on Snowflake experience, including ingestion architecture, performance optimization, and workload management.
4–6 years building pipelines using Microsoft Fabric Pipelines or comparable orchestration frameworks.
4–6 years of Python development for data automation and pipeline engineering.
5+ years of advanced SQL experience, including deep expertise in SQL Server and CDC methodologies.
5+ years operating in Agile/Scrum delivery environments.
3+ years in a technical leadership capacity within data engineering initiatives.
Experience with event‑based ingestion, streaming pipelines, or data contract–driven architectures.
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 to support 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 practices to ensure SLA adherence.
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, mentoring engineers and guiding technical design decisions.
Champion best practices in CI/CD, version control, automated testing, and infrastructure‑as‑code principles within the data engineering function.
Perform code reviews and enforce architectural standards.
Partner with BI leadership to plan capacity, prioritize initiatives, and execute delivery roadmaps.
Foster a culture of engineering ownership, accountability, and innovation.
Collaborate with business and analytics stakeholders to translate requirements into scalable ingestion designs.
Evaluate emerging tools and technologies within the modern data stack ecosystem.
Contribute to long‑term cloud data strategy and architectural evolution.
Ensure enterprise‑grade governance, security, compliance, and data quality controls.

Skills

Python

SQL

Agile/Scrum

Data engineering

Leadership

Education

Bachelor’s degree in CS/Engineering or related field

Tools

Snowflake

Microsoft Fabric Pipelines

dbt Cloud

Qlik Replicate

Azure

Job description

Job Summary

The Enterprise BI & Analytics Team serves as the enterprise data and analytics center of excellence at WebstaurantStore. We transform billions of data points across marketing, supply chain, operations, and customer experience into trusted data foundations and actionable insights. Leveraging a modern cloud data platform, scalable ELT architecture, and automated DataOps workflows, 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 our modern 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 our data 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 are hands‑on technical leaders and trusted partners to BI developers, analytics engineers, and cross‑functional teams. You will drive innovation across our ingestion layer and enable scalable, reliable and governed data movement throughout the enterprise.

Modern Data Engineering & ELT Architecture

Lead the 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 to support 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 practices to ensure SLA adherence.
Refactor and optimize legacy ingestion processes to align with modern data stack best practices.
Drive and support the migration from SQL Server to Snowflake.

Technical Leadership

Act as the lead architect for enterprise ingestion strategy, mentoring engineers and guiding technical design decisions.
Champion best practices in CI/CD, version control, automated testing, and infrastructure‑as‑code principles within the data engineering function.
Perform code reviews and enforce architectural standards.
Partner with BI leadership to plan capacity, prioritize initiatives, and execute delivery roadmaps.
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 the modern data stack ecosystem.
Contribute to long‑term cloud data strategy and architectural evolution.
Ensure enterprise‑grade governance, security, compliance, and data quality controls.

Physical Requirements

Work is performed while sitting/standing and interfacing with a personal computer.
Requires the ability to communicate effectively using speech, vision, and hearing.
Requires the regular use of hands for simple grasping and fine manipulations.
Requires occasional bending, squatting, crawling, climbing, and reaching.
Requires the ability to occasionally lift, carry, push, or pull medium weights, up to 50lbs.

Remote Work Qualifications

Access to a reliable and secure high‑speed internet connection. Cable or fiber internet connections (at least 75mbps download/10mbps upload) are preferred, as satellite connections often cannot support the technologies used to perform day‑to‑day tasks.
Access to a home router and modem.
A dedicated home office space that is noise‑and‑distraction‑free. The space should have strong wireless connection or a wired Ethernet connection (wired connection is preferred, if possible).
A valid, physical address (apartment, suite, etc.). PO Boxes are not supported, as a physical address is required for you to receive your computer equipment.
The desire and ability to work and communicate with other team members via chat, webcam, etc.
Legal residents of one of the following states: (AK, AL, AR, AZ, CT, DE, FL, GA, IA, ID, IN, KS, KY, LA, MD, ME, MI, MN, MO, MS, MT, NC, ND, NE, NH, NM, NV, OH, OK, PA, SC, SD, TN, TX, UT, VA, VT, WI, WV, or WY). H-1B Visa Sponsorship Not Available, W2 only.

Experience

Bachelor’s degree in Computer Science, Engineering, Information Systems, or related discipline; or equivalent experience.
7–10 years of experience in data engineering or cloud data development roles.
5+ years of hands‑on Snowflake experience, including ingestion architecture, performance optimization, and workload management.
4–6 years building pipelines using Microsoft Fabric Pipelines or comparable orchestration frameworks.
4–6 years of Python development for data automation and pipeline engineering.
5+ years of advanced SQL experience, including deep expertise in SQL Server and CDC methodologies.
5+ years operating in Agile/Scrum delivery environments.
3+ years in a technical leadership capacity within data engineering initiatives.
Experience with event‑based ingestion, streaming pipelines, or data contract–driven architectures.
Experience with Qlik Replicate and dbt Cloud.
Microsoft Azure experience.
Relevant cloud or data platform certifications preferred.

Education

This role does not require a degree. We value relevant skills and experience and alignment with our core values above all else.

Desired Traits & Skills

Expertise in cloud data warehouse architecture and scalable ELT frameworks.
Strong command of Snowflake internals, optimization strategies, and ingestion design patterns.
Advanced Python and SQL proficiency.
Experience implementing data observability and pipeline reliability solutions.
Deep understanding of dimensional modeling and enterprise data warehousing concepts.
Proven ability to lead complex modernization initiatives.
Strong stakeholder engagement and technical communication skills.
Ability to thrive in a fast‑paced, growth‑oriented environment.
Passion for building reliable, scalable, and future‑ready data platforms.

Company Overview

The foodservice professional’s premier source for restaurant equipment, supplies, and knowledge online. Our purpose is to empower and equip people to run their businesses more profitably and efficiently.

Benefits