Senior BI Engineer, Data

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

Job Summary

TheEnterprise BI & Analytics Teamis the central hub of analytics and data engineering at WebstaurantStore. We transformbillions of data pointsacross marketing, supply chain, operations, and customer experience into trusted data foundations and actionable insights. Leveraging amodern data stack, scalable cloud technologies, and innovativeDataOpspractices, the team empowers smarter decisions, rapid growth, and new opportunities across the business.

As aSenior BI Engineer, you will architect and own the next generation of our enterprise data ingestion ecosystem. You will lead the creation of a unified ingestion framework into Snowflake—building scalable, repeatable, andhigh performancepatterns that power analytics and data products across the organization. You will guide our transition from SQL Server to Snowflake, mentor engineers,establishengineering best practices, and collaborate closely with stakeholders to deliver reliable,enterprise gradedata solutions.

Responsibilities

Senior BI Engineers are technical leaders and trusted partnersto BI developers, analysts, andcross functionalteams. You will shape the future of our data platform by driving ingestion architecture, building modern pipelines, and enablinghigh impactengineering capabilities across the business.

Key areas of ownership include:

Data Engineering & Architecture

• 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, including APIs, databases, cloud storage, flat files, and SharePoint.
• Build andmaintainFabric Pipelines to supportenterprise gradedata movement and orchestration.
• DevelopPython basedingestion utilities, automation scripts, and reusable components.
• Establish best practices for ingestion performance, error handling, logging, and monitoring.
• Analyze existing ingestion processes and drive modernization, consolidation, and optimization efforts.
• Support and guide the organization through the transition from SQL Server to Snowflake.

Leadership & Team Enablement

• Serve as the technical lead for data ingestion initiatives, providing direction, mentorship, and oversight to BI developers.
• Delegate work effectively and coach team members on ingestion patterns, frameworks, and best practices.
• Conduct code reviews,providearchitectural guidance, and ensure adherence to engineering standards.
• Collaborate with BI Managers to align resources, timelines, and priorities.
• Promote a culture of knowledge sharing, continuous improvement, and engineering excellence.

Planning, Analysis & Delivery

• Partner with analysts and business stakeholders to understand ingestion requirements and translate them into scalable technical solutions.
• Lead the planning, design, and analysis of ingestion workflows and data engineering projects.
• Evaluate new data sources anddetermineoptimalingestion strategies.
• Contribute tolong termarchitectural roadmaps and data platform strategy.
• Ensure solutions meet enterprise standards for data quality, governance, and security.

Agile / Scrum Responsibilities

• Lead or activelyparticipatein Agile ceremonies including standups, grooming, sprint planning, and retrospectives.
• Collaborate with product owners, analysts, and developers to refine and prioritize the backlog.
• Track team progress,identifyrisks, and remove blockers tomaintaindelivery momentum.
• Communicate status, challenges, and dependencies to BI Managers and stakeholders.