Lateral Group · 1 month ago
Senior Snowflake Engineer (US, Pacific Time)
United States
Full-time
Remote
Senior Level
5+ years expLateral Group is a profitable, award-winning design and technology company with over 20 years of experience. They are seeking a Senior Snowflake Engineer to design and maintain data pipelines, optimize SQL queries, and ensure data quality while collaborating with various teams to deliver effective data solutions.
ConsultingSoftware
Responsibilities
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
Qualification
Required
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. We’re a remote-first company, but if you’re near an office, you’re welcome to drop in, collaborate in person, or work onsite regularly.
An Outstanding Team: Talented, kind, and hard-working people who care deeply about their craft - and about each other. No egos. No politics. Just professionals doing their best work.
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.
Company
Lateral Group
LATERAL (Technology with Passion) adds business value through full service technology solutions.
201-500 employees
H1B Sponsorship
Lateral Group has a track record of offering H1B sponsorships. Please note that this does not
guarantee sponsorship for this specific role. Below presents additional info for your
reference. (Data Powered by US Department of Labor)
Distribution of Different Job Fields Receiving Sponsorship
Represents job field similar to this job
Trends of Total Sponsorships
2020 (1)
Funding
Current Stage
Growth StageLeadership Team
Ciprian Morar
Founder and CEO
Company data provided by crunchbase