Senior Snowflake & Ingestion Architect

Webstaurantstore; Lititz (Lancaster County); Remote; USD 150,000 - 190,000; Full time

Job summary

WebstaurantStore is seeking a Senior BI Engineer to architect and own the next generation of our enterprise data ingestion ecosystem. You will lead the unified ingestion framework into Snowflake, building scalable patterns that power analytics and data products across marketing, supply chain, operations, and customer experience.

You will mentor engineers, drive modernization from SQL Server to Snowflake, and collaborate with stakeholders to deliver reliable, enterprise-grade data solutions

Qualifications

• 7–10 years of professional experience in data engineering.
• 5+ years hands-on experience with Snowflake ingestion, transformation, optimization, and performance tuning.
• 4–6 years building data pipelines using Fabric Pipelines or similar orchestration tools.
• 4–6 years of Python experience focused on automation and ingestion utilities.
• 5+ years of enterprise SQL experience, including CDC implementation and support.
• 5+ years of experience in Agile/Scrum environments.
• 3+ years leading data engineering initiatives or technical ingestion leadership.
• Experience with event sourcing or data contract–driven ingestion patterns.

Responsibilities

• Lead design and implementation of standardized data ingestion framework into Snowflake.
• Architect scalable, secure, reusable ingestion patterns for diverse data sources.
• Build and maintain Fabric Pipelines for enterprise-grade data movement.
• Develop Python utilities and reusable ingestion components.
• Establish best practices for ingestion performance, error handling, and monitoring.
• Guide SQL Server to Snowflake transition and mentor engineers.
• Lead Agile ceremonies and coach team on ingestion patterns and best practices.

Skills

Data ingestion

Python

Agile/Scrum

Leadership

Communication

Education

Bachelor’s degree in Computer Science or related field

Equivalent professional experience

Tools

Snowflake

Microsoft Fabric Pipelines

Qlik Replicate

dbt Cloud

Microsoft Azure

Job description

WebstaurantStore is seeking a Senior BI Engineer to architect and own the next generation of our enterprise data ingestion ecosystem. You will lead the unified ingestion framework into Snowflake, building scalable patterns that power analytics and data products across marketing, supply chain, operations, and customer experience.

You will mentor engineers, drive modernization from SQL Server to Snowflake, and collaborate with stakeholders to deliver reliable, enterprise-grade data solutions