Senior BI Engineer: Snowflake Ingestion Lead

WebstaurantStore; Lititz (Lancaster County); Hybrid; USD 120,000 - 180,000; Full time

Benefits offered by this job

Medical

Vision

Dental

PTO

Paid Maternity Leave

Paid Parental Leave

Life Insurance

Disability

401(k) matching

Employee Assistance Program

Wellness Incentives

Company Discounts

Bonus Opportunities

Accident Insurance

Critical Illness Insurance

Adoption Assistance

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, repeatable pipelines and guiding the transition from SQL Server to Snowflake.

You will mentor engineers, establish engineering best practices, and collaborate with stakeholders to deliver enterprise-grade data solutions that empower analytics across marketing, supply chain,

Qualifications

• 7–10 years of professional experience in data engineering.
• 5+ years hands-on Snowflake experience including ingestion and optimization.
• 4–6 years building data pipelines with Microsoft Fabric Pipelines or equivalent orchestration tools.
• 5+ years of enterprise SQL experience including CDC and SQL Server.
• 5+ years of Agile/Scrum experience.
• 3+ years leading data engineering initiatives or serving as a technical lead on ingestion projects.
• Experience with event sourcing or data contract–driven ingestion patterns.
• Experience using dbt Cloud for ELT transformation and orchestration.
• Microsoft Azure experience.

Responsibilities

• Lead the design, development, and implementation of a standardized data ingestion framework into Snowflake.
• Architect scalable, secure, and reusable ingestion patterns for diverse data sources.
• Build and maintain Fabric Pipelines to support enterprise grade data movement and orchestration.
• Develop Python based ingestion utilities, automation scripts, and reusable components.
• Establish best practices for ingestion performance, error handling, logging, and monitoring.
• Guide organization through the transition from SQL Server to Snowflake.

Tools

Snowflake

dbt Cloud

Microsoft Fabric Pipelines

Python

SQL Server

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, repeatable pipelines and guiding the transition from SQL Server to Snowflake.

You will mentor engineers, establish engineering best practices, and collaborate with stakeholders to deliver enterprise-grade data solutions that empower analytics across marketing, supply chain,