Note: The job is a remote job and is open to candidates in USA. WebstaurantStore is an online source for restaurant equipment, supplies, and knowledge that helps foodservice businesses operate more profitably and efficiently. The Senior Cloud Data Engineer will architect and own a modern data ingestion and integration ecosystem, leading Snowflake-based ELT pipelines, data warehouse modernization, and the migration from SQL Server. The role also provides technical leadership, mentors engineers, and partners with BI and analytics teams to deliver reliable, governed enterprise data platforms.
Responsibilities
- Lead the design and implementation of a standardized ELT-based ingestion framework into Snowflake
- Design scalable ingestion pipelines for structured and semi-structured data from APIs, databases, cloud storage, flat files, and collaboration platforms
- Build and maintain Fabric Pipelines to support cloud-native orchestration and pipeline automation
- Develop reusable Python libraries and ingestion accelerators to standardize engineering practices
- Implement robust monitoring, logging, and data reliability engineering practices to ensure SLA adherence
- Refactor and optimize legacy ingestion processes to align with modern data stack best practices
- Drive and support the migration from SQL Server to Snowflake
- Act as the lead architect for enterprise ingestion strategy, mentoring engineers and guiding technical design decisions
- Champion best practices in CI/CD, version control, automated testing, and infrastructure-as-code principles within the data engineering function
- Perform code reviews and enforce architectural standards
- Partner with BI leadership to plan capacity, prioritize initiatives, and execute delivery roadmaps
- Foster a culture of engineering ownership, accountability, and innovation
- Collaborate with business and analytics stakeholders to translate requirements into scalable ingestion designs
- Evaluate emerging tools and technologies within the modern data stack ecosystem
- Contribute to long-term cloud data strategy and architectural evolution
- Ensure enterprise-grade governance, security, compliance, and data quality controls
Skills
- Bachelor's degree in Computer Science, Engineering, Information Systems, or related discipline; or equivalent experience
- 7–10 years of experience in data engineering or cloud data development roles
- 5+ years of hands-on Snowflake experience, including ingestion architecture, performance optimization, and workload management
- 4–6 years building pipelines using Microsoft Fabric Pipelines or comparable orchestration frameworks
- 4–6 years of Python development for data automation and pipeline engineering
- 5+ years of advanced SQL experience, including deep expertise in SQL Server and CDC methodologies
- 5+ years operating in Agile/Scrum delivery environments
- 3+ years in a technical leadership capacity within data engineering initiatives
- Experience with event-based ingestion, streaming pipelines, or data contract–driven architectures
- Experience with Qlik Replicate and dbt Cloud
- Microsoft Azure experience
- Expertise in cloud data warehouse architecture and scalable ELT frameworks
- Strong command of Snowflake internals, optimization strategies, and ingestion design patterns
- Advanced Python and SQL proficiency
- Experience implementing data observability and pipeline reliability solutions
- Deep understanding of dimensional modeling and enterprise data warehousing concepts
- Proven ability to lead complex modernization initiatives
- Strong stakeholder engagement and technical communication skills
- Ability to thrive in a fast-paced, growth-oriented environment
- Passion for building reliable, scalable, and future-ready data platforms
- Relevant cloud or data platform certifications preferred
Benefits
- Medical
- Vision
- Dental
- PTO
- Paid Maternity Leave
- Paid Parental Leave
- Life Insurance
- Disability
- Dependent Care FSA
- 401(k) matching
- Employee Assistance Program
- Wellness Incentives
- Company Discounts
- AT&T & Verizon Discount
- Bonus Opportunities
- Accident Insurance
- Critical Illness Insurance
- Adoption Assistance
- Available at HQ Locations Only: On-Site Fitness Centers
- Available at HQ Locations Only: Dog-friendly Offices
Company Overview