Senior Data Platform / Analytics Engineering Focus

Clark Associates; Lititz (Lancaster County); On-site; USD 140,000 - 180,000; Full time

Job summary

WebstaurantStore is seeking a Senior Data Platform Engineer to architect and own the next generation of ingestion and data integration platforms. You will guide the transition from SQL Server to Snowflake, mentor engineers, and establish best practices for scalable, cloud-native data pipelines.

The role emphasizes building reliable, production-grade data solutions and collaborating with stakeholders to enable data-driven decision making across marketing, supply chain, operations, and customer

Qualifications

• Leadership in data ingestion architecture and data platforms.
• Strong collaboration with BI developers and analysts.
• Experience with cloud data architectures and DevOps practices.

Responsibilities

• Lead the design, development, and implementation of a standardized cloud data ingestion framework into Snowflake.
• Architect scalable, secure ingestion patterns for diverse data sources (APIs, databases, cloud storage, files, SharePoint).
• Build and maintain Fabric Pipelines to support enterprise-scale orchestration and workflow automation.
• Develop Python-based ingestion utilities, automation scripts, and reusable components.

Job description

Job Summary

The Enterprise BI & Analytics Team is the central hub of analytics and data engineering atWebstaurantStore. 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 innovativeDataOpspractices, the team empowers smarter decisions, rapid growth, and new opportunities across the business.

As aSenior Data Platform Engineer, you will architect and own the next generation of ourenterprise data integration and ingestion platform. You will lead the creation of a unified ingestion framework into Snowflake—building scalable, repeatable, andcloud-native, highly performant data pipeline patternsthat 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,production-grade cloud data solutions.

Responsibilities

Senior BI Engineers are technical leaders and trusted partners to BI developers, analysts, and cross functional teams. You will shape the future of ourenterprise data platformby driving ingestion architecture, building modern pipelines, and enabling high impact engineering capabilities across the business.

Key Areas of Ownership

• Lead the design, development, and implementation of a standardizedcloud data ingestion frameworkinto 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-scale orchestration and workflow automation.
• Develop Python-based ingestion utilities, automation scripts, and reusable components.
• Establish best practices for ingestion performance,observability, resiliency, error handling, logging, and monitoring.
• Analyze existing ingestion processes and drive modernization, consolidation, anddata platform optimization initiatives.
• Support and guide the organization through the transition from SQL Server to Snowflake.

Leadership & Team Enablement

• Serve as thetechnical authority for data integration and ingestion architecture, 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 todata engineering standards and DevOps principles.
• 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 intoscalable cloud data solutions.
• Lead the planning, design, and analysis of ingestion workflows and data engineering projects.
• Evaluate new data sources anddetermineoptimalingestion strategies.
• Contribute to long-termdata platform roadmap and cloud architecture strategy.
• Ensure solutions meet enterprise standards for data quality, governance, and security.