Senior Cloud Data Engineer - Snowflake & ELT Architect

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

Job summary

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

Qualifications

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

Responsibilities

• 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.

Skills

Snowflake ingestion

Python libraries

ELT architecture

CI/CD practices

Data pipelines

Mentoring engineers

Monitoring & reliability

Tools

Snowflake

SQL Server

Git

Job description

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