Senior Cloud Data Engineer / Modern Data Stack Focus

Clark Associates; Lititz (Lancaster County); Vor Ort; USD 130.000 - 180.000; Vollzeit

Zusammenfassung

The Enterprise BI & Analytics Team at WebstaurantStore drives the data foundation and analytics across marketing, supply chain, operations, and customer experience. You will architect the next generation of data ingestion and integration, leading a unified Snowflake-based framework, and guiding modernization from SQL Server to Snowflake.

You will mentor engineers, champion CI/CD and IaC, and partner with BI leadership to plan capacity and delivery roadmaps while ensuring governance and data

Qualifikationen

• Experience designing ELT-based ingestion frameworks into Snowflake.
• Mentor engineers and set architectural standards.
• Strong background in cloud data platforms and data quality.

Aufgaben

• Lead design and implement standardized ELT ingestion into Snowflake.
• Build scalable ingestion pipelines from APIs, databases, cloud storage, and files.
• Develop reusable Python libraries and ingestion accelerators.
• Mentor engineers and enforce architectural standards.
• Collaborate with BI and analytics stakeholders to translate requirements.

Kenntnisse

Snowflake ingestion

Python libraries

ELT architecture

CI/CD practices

Data pipelines

Mentoring engineers

Monitoring & reliability

Tools

Snowflake

SQL Server

Git

Jobbeschreibung

Job Summary

The Enterprise BI & Analytics Team serves as theenterprise data and analytics center of excellenceatWebstaurantStore. We transform billions of data points across marketing, supply chain, operations, and customer experience into trusted data foundations and actionable insights. Leveraging amodern cloud data platform, scalable ELT architecture, and automatedDataOpsworkflows, the team empowers smarter decisions, rapid growth, and new opportunities across the business.

As a Senior Cloud Data Engineer, you will architect and own the next generation of ourmodern data ingestion and integration ecosystem. You will lead the development of a unified ingestion framework into Snowflake—building scalable, automated, and high-throughput data pipelines that power analytics and data products enterprise-wide. You will play a key role in ourdata warehouse modernization initiative, guide our transition from SQL Server to Snowflake, mentor engineers, and help define the future state of our cloud data architecture.

Responsibilities

Core Responsibilities

Modern Data Engineering & ELT Architecture

• Lead the design and implementation of a standardizedELT-based ingestion frameworkinto Snowflake.
• Design scalable ingestion pipelines for structured and semi-structured data from APIs, databases, cloud storage, flat files, and collaboration platforms.
• Build andmaintainFabric Pipelines to supportcloud-native orchestration and pipeline automation.
• Develop reusable Python libraries and ingestion accelerators to standardize engineering practices.
• Implement robust monitoring, logging, anddata reliability engineering practicesto ensure SLA adherence.
• Refactor andoptimizelegacy ingestion processes to align with modern data stack best practices.
• Drive and support the migration from SQL Server to Snowflake.

Technical Leadership

• Act as thelead architect for enterprise ingestion strategy, mentoring engineers and guiding technical design decisions.
• Champion best practices inCI/CD, version control, automated testing, and infrastructure-as-code principleswithin the data engineering function.
• Perform code reviews and enforce architectural standards.
• Partner with BI leadership to plan capacity, prioritize initiatives, and executedeliveryroadmaps.
• Foster a culture of engineering ownership, accountability, and innovation.

Strategy & Execution

• Collaborate with business and analytics stakeholders to translate requirements into scalable ingestion designs.
• Evaluate emerging tools and technologies within themodern data stack ecosystem.
• Contribute to long-term cloud data strategy and architectural evolution.
• Ensure enterprise-grade governance, security, compliance, and data quality controls.