Senior Cloud Data Engineer / Modern Data Stack Focus

WebstaurantStore is an online source for restaurant equipment, supplies, and knowledge that helps foodservice businesses operate more profitably and efficiently. The Senior Cloud Data Engineer will architect and own a modern data ingestion and integration ecosystem, leading Snowflake-based ELT pipelines, data warehouse modernization, and the transition from SQL Server to Snowflake. The role also provides technical leadership, mentoring, governance, and collaboration with BI, analytics, and business stakeholders.

Responsibilities:

• 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
• 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
• 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
• 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

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
• • 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
• • 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
• • 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
• • Relevant cloud or data platform certifications preferred