Lateral Group logo
Lateral Group

Quality People. Quality Software.

Senior Snowflake Engineer

EngineerEngineerFull TimeRemoteSeniorTeam 201-500Since 2008H1B No SponsorCompany SiteLinkedIn

Location

Canada

Posted

79 days ago

Salary

0

Seniority

Senior

Job Description

Senior Snowflake Engineer

Lateral Group

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

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

Related Categories

Related Job Pages

More Engineer Jobs

Full TimeRemoteTeam 201-500H1B No Sponsor

• Provide technical and administrative support • Undergo “on-the-job” training • Manage all types of projects • Perform energy yield assessments, and opine on renewable energy project level documentation such as permitting, contracts and commissioning • Control productivity of projects: time/product ratio • Control productivity of team members • Manage deadlines and expectations • Control and assure quality of work • Assist the team assigned to the project • Assist the project manager with communications with the client • Assist the team with discussions between the different project participants • Taking full responsibility of the tasks assigned with autonomy

North Carolina
Job Closed
Prometeo Talent logo

Senior Customer Delivery Consulting Engineer

Prometeo Talent

Empowering startups to scale by connecting you with top 1% global talent. Since 2010. www.prometeotalent.com/

Engineer79 days ago
Full TimeRemoteTeam 11-50Since 2010H1B No Sponsor

• Plan and execute solution validation activities in collaboration with customers and internal stakeholders • Implement and integrate complex network platforms and technologies in laboratory environments • Validate architectures, develop test plans, and document results clearly • Troubleshoot complex network issues across routing, switching, VPN, and MPLS environments • Collaborate with engineering teams to identify issues and drive successful solution delivery • Act as a technical point of contact for customers during solution validation and delivery phases

Colombia
Job Closed
Genie AI logo

Agentic Engineer

Genie AI

Your AI Legal Assistant

Engineer79 days ago
Full TimeRemoteTeam 11-50Since 2017H1B No Sponsor

• Architect and build AI-powered products end-to-end • Build and manage a fleet of agents • Design technical systems that multiply team output • Help us build the Agentic Legal Framework and our Knowledge Intelligence Platform • Safeguard the team’s future by elevating engineering from individual contribution to 10x team output • Design AI-first technical systems: Own technical design from first principles, use design patterns deliberately and architect scalable Node.js systems • Manage and orchestrate AI agents: Build, deploy and maintain subagents, improving agentic effectiveness and design workflows that scale with agents • Build end to end products : Own features from ideation -> architecture -> implementation -> shipping and move beyond ‘frontend’ or ‘backend’ silos • Collaborate as a 10x team: Backcast from product outcomes and build most of the solution at once, share knowledge openly, elevate peers and design for collective intelligence • Contribute to core strategic initiatives : Agentic Legal Framework, Knowledge Intelligence Platform, AIOps evolution

United States
Job Closed
Yazen Health logo

Full-Stack Engineer

Yazen Health

Proven weight control. For life.

Engineer79 days ago
Full TimeRemoteTeam 201-500Since 2021H1B No Sponsor

• Collaborate with designers, developers, and product minds to craft seamless, full-stack solutions that make healthcare smarter. • Build and refine both front-end and back-end features for performance, reliability, and beauty. • Write clean, maintainable, and testable code — and continuously raise the bar for quality. • Explore, evaluate, and implement new technologies that make us faster, smarter, and more effective. • Troubleshoot issues and deliver solutions with empathy — because every bug fixed means a better experience for a patient.

Sweden
Job Closed