Senior BI Engineer, Data

WebstaurantStore’s Enterprise BI & Analytics Team serves as the company’s central hub for analytics and data engineering. The Senior BI Engineer will architect and own a unified Snowflake data ingestion ecosystem, lead the transition from SQL Server to Snowflake, build scalable pipelines, mentor engineers, and establish engineering best practices.

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
• Work is performed while sitting/standing and interfacing with a personal computer
• Requires the ability to communicate effectively using speech, vision, and hearing
• Requires the regular use of hands for simple grasping and fine manipulations
• Requires occasional bending, squatting, crawling, climbing, and reaching
• Requires the ability to occasionally lift, carry, push, or pull medium weights, up to 50lbs

Requirements:

• • 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.)
• • 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, MT, NC, ND, NE, NH, NM, NV, OH, OK, PA, SC, SD, TN, TX, UT, VA, VT, WI, WV, and WY)
• We only accept W-2 candidates, H-1B sponsorship is not available
• • 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
• • Deep expertise in building and maintaining data ingestion pipelines across diverse platforms
• • Strong proficiency with Snowflake architecture, Snowflake ingestion patterns, and SQL
• • Advanced Python skills for automation, ingestion utilities, and framework development
• • Hands-on experience with Microsoft Fabric Pipelines or similar orchestration tools
• • Strong understanding of data modeling, data warehousing, and ETL/ELT best practices
• • Ability to lead technical initiatives, mentor team members, and influence engineering direction
• • Strong analytical and problem solving skills with the ability to design scalable solutions
• • Excellent communication skills, capable of translating complex technical concepts for nontechnical audiences
• • High degree of adaptability, emotional intelligence, and collaborative mindset
• • Customer focused approach with a commitment to delivering high quality solutions
• • Cable or fiber internet connections (at least 75mbps download/10mbps upload) are preferred, as satellite connections often cannot support the technologies used to perform day-to-day tasks
• • Certifications in dbt Cloud, Snowflake, or Microsoft Fabric preferred