Python Automation Testing Jobs in Lancaster, PA (NOW HIRING)

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. 

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. 

Core Responsibilities 

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. 

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

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

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

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.

• Medical
• Vision
• Dental
• PTO
• Paid Maternity Leave
• Paid Parental Leave
• Life Insurance
• Disability
• Dependent Care FSA
• 401(k) matching
• Employee Assistance Program
• Wellness Incentives
• Company Discounts
• AT&T & Verizon Discount
• Bonus Opportunities
• Accident Insurance
• Critical Illness Insurance
• Adoption Assistance

• On-Site Fitness Centers
• Dog-friendly Offices