WebstaurantStore · 8 hours ago
Senior BI Engineer, Data
Lititz, PA
Full-time
Onsite
Senior Level
7+ years expWebstaurantStore is the foodservice professional’s premier source for restaurant equipment, supplies, and knowledge online. As a Senior BI Engineer, you will architect and own the next generation of the enterprise data ingestion ecosystem, leading the creation of a unified ingestion framework into Snowflake and mentoring engineers to deliver reliable data solutions.
Consumer GoodsIndustrialManufacturingService Industry
No H1B
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, including APIs, databases, cloud storage, flat files, and SharePoint
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
Analyze existing ingestion processes and drive modernization, consolidation, and optimization efforts
Support and guide the organization through the transition from SQL Server to Snowflake
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
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 and determine optimal ingestion strategies
Contribute to long term architectural roadmaps and data platform strategy
Ensure solutions meet enterprise standards for data quality, governance, and security
Lead or actively participate in 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 to maintain delivery momentum
Communicate status, challenges, and dependencies to BI Managers and stakeholders
Qualification
Required
Bachelor's degree in Computer Science, Information Systems, Engineering, or a related field; or equivalent professional experience
7–10 years of professional experience in data engineering
5+ years of hands-on experience with Snowflake, including ingestion, transformation, optimization, and platform performance tuning
4–6 years of experience building data pipelines using Microsoft Fabric Pipelines or equivalent orchestration tools
4–6 years of professional Python experience focused on automation, ingestion utilities, and framework development
5+ years of enterprise SQL experience, including advanced SQL Server work and hands-on Change Data Capture (CDC) implementation and support
5+ years of experience working in Agile/Scrum environments
3+ years of experience leading data engineering initiatives or serving as a technical lead on ingestion projects
Experience working with event sourcing or data contract–driven ingestion patterns
Experience using Qlik Replicate for data movement and replication
Experience using dbt Cloud for ELT transformation and orchestration
Microsoft Azure experience
Access to a reliable and secure high-speed internet connection
Access to a home router and modem
A dedicated home office space that is noise- and distraction-free
A valid, physical address (apartment, suite, etc.). PO Boxes are not supported
The desire and ability to work and communicate with other team members via chat, webcam, etc
Legal residents of one of the following states: (AK, AL, AR, AZ, CT, DE, FL, GA, IA, ID, IN, KS, KY, LA, MD, ME, MI, MN, MO, MS, NC, ND, NH, NM, NV, OH, OK, PA, SC, SD, TN, TX, UT, VA, VT, WI, WV, or WY). H-1B Visa Sponsorship Not Available, W2 only
Preferred
Certifications in dbt Cloud, Snowflake, or Microsoft Fabric preferred but not required
Benefits
Medical
Vision
Dental
PTO
Paid Maternity Leave
Paid Parental Leave
Life Insurance
Disability
Dependent Care FSA
401(k) matching
Employee Assistance Program
Wellness Incentives
Company Discounts
AT&T & Verizon Discount
Bonus Opportunities
Accident Insurance
Critical Illness Insurance
Adoption Assistance
On-Site Fitness Centers
Dog-friendly Offices
Company
WebstaurantStore
Since WebstaurantStore's start in 2004, we have worked hard to build an innovative, easy-to-use website that meets the purchasing needs of foodservice professionals throughout the world.
5001-10000 employees
Funding
Current Stage
Late StageLeadership Team
Laura Brent
Conversion Rate Optimization (CRO) Lead
Luara Da Silva, MBA
Partnership & Project Coordinator
Recent News
Company data provided by crunchbase