Quality People. Quality Software.
Senior Snowflake Engineer
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 Guides
Related Categories
Related Job Pages
More Engineer Jobs
• 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
Senior Customer Delivery Consulting Engineer
Prometeo TalentEmpowering startups to scale by connecting you with top 1% global talent. Since 2010. www.prometeotalent.com/
• 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
• 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
• 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.




