Senior Cloud Data Architect - Snowflake & ELT Pipelines

Webstaurantstore; Lititz (Lancaster County); On-site; USD 120,000 - 180,000; Full time

Job summary

WebstaurantStore is seeking a Senior Cloud Data Engineer to architect and own the next generation of our cloud data ingestion and integration ecosystem. You will lead scalable, automated data pipelines into Snowflake and guide the migration from SQL Server to Snowflake while mentoring engineers and aligning with BI stakeholders.

You will partner with cross-functional teams to enable governed data movement, reliability, and scalable data products across the enterprise.

Responsibilities

• Lead design and implementation of a standardized ELT-based ingestion framework into Snowflake.
• Build scalable ingestion pipelines for structured and semi-structured data from APIs, databases, cloud storage, flat files, and collaboration platforms.
• Develop reusable Python libraries and ingestion accelerators to standardize engineering practices.
• Implement robust monitoring, logging, and data reliability engineering to ensure SLA adherence.
• Migrate from SQL Server to Snowflake.

Tools

Snowflake

Python

ELT

CI/CD

IaC

Job description

WebstaurantStore is seeking a Senior Cloud Data Engineer to architect and own the next generation of our cloud data ingestion and integration ecosystem. You will lead scalable, automated data pipelines into Snowflake and guide the migration from SQL Server to Snowflake while mentoring engineers and aligning with BI stakeholders.

You will partner with cross-functional teams to enable governed data movement, reliability, and scalable data products across the enterprise.