Senior BI Engineer: Snowflake Data Ingestion Architect

Clark Mechanical Services, Inc.; Lititz (Lancaster County); On-site; USD 130,000 - 180,000; Full time

Job summary

WebstaurantStore is seeking a Senior BI Engineer to own the enterprise data ingestion ecosystem. You will architect a unified ingestion framework into Snowflake, mentor engineers, and guide the transition from SQL Server to Snowflake while partnering with stakeholders on reliable, enterprise-grade data solutions.

The role emphasizes technical leadership in data ingestion, architecture, and performance, with collaboration across analytics, marketing, and operations teams.

Qualifications

• Lead design and implementation of ingestion framework into Snowflake.
• Architect scalable ingestion patterns for diverse data sources.
• Develop Python-based ingestion utilities and automation scripts.
• Ensure performance, logging, and monitoring best practices.

Responsibilities

• Lead ingestion framework from design to deployment in Snowflake.
• Architect scalable ingestion patterns for APIs, databases, and files.
• Build and maintain Fabric Pipelines for data movement.
• Mentor BI developers and review code.
• Collaborate with BI managers on priorities.
• Lead Agile ceremonies and backlog refinement.
• Align ingestion work with enterprise data standards.

Skills

Snowflake ingestion

Python

Data pipelines

Data architecture

Mentorship

Tools

Fabric Pipelines

APIs

SharePoint

Job description

WebstaurantStore is seeking a Senior BI Engineer to own the enterprise data ingestion ecosystem. You will architect a unified ingestion framework into Snowflake, mentor engineers, and guide the transition from SQL Server to Snowflake while partnering with stakeholders on reliable, enterprise-grade data solutions.

The role emphasizes technical leadership in data ingestion, architecture, and performance, with collaboration across analytics, marketing, and operations teams.