Senior BI Engineer, Data

Job Summary

The
Enterprise BI & Analytics Team
is the central hub of analytics and data engineering at Webstaurant Store. We transform
billions of data points
across marketing, supply chain, operations, and customer experience into trusted data foundations and actionable insights. Leveraging a
modern data stack
, scalable cloud technologies, and innovative

DataOpspractices, the team empowers smarter decisions, rapid growth, and new opportunities across the business.

As a
Senior 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 performance patterns that power analytics and data products across the organization. You will guide our transition from SQL Server to Snowflake, mentor engineers,establish engineering best practices, and collaborate closely with stakeholders to deliver reliable,enterprise gradedata solutions.

Senior BI Engineers are technical leaders and trusted partners
to BI developers, analysts, andcross functional teams. You will shape the future of our data platform by driving ingestion architecture, building modern pipelines, and enabling high impact engineering 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 and maintain
  
  Fabric Pipelines to support enterprise gradedata movement and orchestration.
• Develop Python based ingestion 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,provide architectural 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 term architectural 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,identify risks, and remove blockers tomaintaindelivery momentum.
• Communicate status, challenges, and dependencies to BI Managers and stakeholders.