Senior Snowflake Engineer

🕒 March 24

Apply Now

Find Similar Remote Jobs

Receive Emails For Remote Jobs

📊 Check your resume score for this job

Improve your chances of getting an interview by checking your resume score before you apply.

Upload Resume

Lateral Group

WebsiteLinkedInAll Job Openings

201 - 500 employees

Founded 2008

🤖 Artificial Intelligence

🤝 B2B

🏢 Enterprise

Artificial Intelligence • B2B • Enterprise

Lateral Group is a profitable, award-winning design and technology company with over 20 years of experience designing and building digital products and transforming businesses. A globally distributed team of 200–300 engineers, designers and product specialists, the company offers product strategy, UX/UI, frontend and backend engineering, mobile development, and AI/ML capabilities to deliver high-quality, client-facing software solutions on time and on budget. Lateral Group primarily serves other organizations, partnering with clients to launch ventures and modernize products across industries.

📋 Description

• Design, develop, and maintain scalable data pipelines and transformation logic using Snowflake (SnowSQL, Snowpark, Streams, Tasks, Warehouses). • Build and optimize complex SQL, stored procedures, UDFs, and performance-tuned queries. • Implement data ingestion frameworks and integrations from multiple sources (APIs, files, SaaS systems, cloud storage, etc.). • Model and structure data (3NF, Data Vault, Dimensional Modeling) to support analytics and enterprise reporting. • Optimize Snowflake compute usage, warehouse sizing, caching strategies, and cost-performance tradeoffs. • Ensure data quality, lineage, observability, and reliability across the pipeline lifecycle. • Implement and improve CI/CD processes for data development, including version control, automated testing, and safe deployment patterns. • Work closely with TPMs and client stakeholders to clarify requirements, scope data work, communicate progress, and align on timelines. • Collaborate with engineers, analysts, and product teams to ensure data solutions actually solve real business needs. • Contribute to documentation, coding standards, and best practices across the data engineering function.

🎯 Requirements

• 5+ years of experience in data engineering , with at least 2–3 years dedicated to Snowflake development. • Advanced SQL expertise - highly optimized queries, analytical functions, complex transformations, performance tuning. • Hands-on experience with Snowflake features: Warehouses, RBAC, Streams, Tasks, Snowpipe, external stages, data sharing. • Strong experience with ETL/ELT tools and orchestration (e.g., dbt, Airflow, Azure Data Factory, AWS Glue, Matillion, etc.). • Experience modeling data for analytics and operational systems (star/snowflake schemas, Data Vault, etc.). • Deep understanding of data quality, governance, schema design, and lifecycle management. • Comfort working with cloud data ecosystems (AWS, Azure, or GCP). • Experience integrating Snowflake with BI tools (Tableau, Looker, Power BI) and downstream consumers. • Strong communication skills - clear, structured, and able to work with technical and non-technical stakeholders. • A high bar for craft, reliability, and accuracy.

🏖️ Benefits

• Real Impact: You’ll work on meaningful products that make a measurable difference - from healthcare and commerce to sustainability and next-gen tech. • Remote-First, Office Friendly: Work from wherever you’re most productive - whether that’s your home, a co-working space, or one of our offices. • An Outstanding Team: Talented, kind, and hard-working people who care deeply about their craft - and about each other. • Growth: You’ll be supported in growing your craft, exploring new paths, and stepping into greater responsibility - at your own pace. • A Culture of Excellence: We care deeply about doing the right thing - for our clients, our team, and ourselves. No burnout. No crunch. Just high-quality work, delivered sustainably. • Variety & Stability: We’re profitable, independent, and over a decade strong. Yet every project brings a fresh challenge. You’ll never be bored here.