Skip to Main Content

Job Title


Senior Snowflake Engineer (Canada, Pacific Time)


Company : Lateralgroup


Location : Montreal, Montreal (administrative regio


Created : 2025-12-12


Job Type : Full Time


Job Description

Lateral stands for technology excellence. Were a profitable, award-winning design and technology company with over 20 years of experience launching bold ventures and transforming businesses. A globally distributed team of 200+ experts united by a shared purpose: the continuous pursuit of quality. Our clients come to us for results, quality and craft - and stay because we keep raising the bar. We Do Things Differently at Lateral Our mission is simple: design and build great products. What sets us apart isnt just the talent of our team its the way we work: We Have A Bias For Action & Results. We are doers - we spot the gaps, connect the dots, anticipate whats around the corner and take action. We move fast, stay focused, and let the results not the effort speak for themselves. We Work On Time, On Budget, On Quality Discipline is our edge - a commitment we make to each other, to our clients, and to the standards we hold ourselves to. We Care Deeply. We care about our work and about each other. Care Is A Competitive Advantage. Every detail matters. Every design, every line of code, every decision. Thoughtful by default. We Do Things Right -Because Its the Right Thing to Do Right over easy. Integrity isnt up for negotiation. We hold the bar high even when no ones watching. We take pride in doing great work the right way -not the easy way. We Keep Improving The best teams keep improving and were never done learning. We iterate. We reflect on whats working and whats not. Feedback fuels us, we receive it openly, and adapt quickly. Progress over perfection. Were Obsessed With Agility, Not The Agile Manifesto We dont chase dogma or rituals - we chase momentum. We adapt processes to fit problems, not the other way around. We Take Ownership Everyone leads something here. You will have room to run with ideas, and the trust to execute. That trust is built on how you show up: thinking things through, sweating the details, and following through. What You'll Do As a Senior Snowflake Engineer you will: - 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 performancetuned 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 costperformance 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. Whatever the challenge, youll be building software that changes lives and moves industries forward. We measure success through: - Evaluating results (what youve shipped) - Quality and reliability of your code. - Consistency in delivery. - Feedback from peers and leads. - Your ability to work independently and unblock others. What Were Looking For Team members who are both highly technical and care deeply about their craft and how the work gets done. Were looking for a strong, handson Snowflake engineer who brings technical depth, good judgment, and a thoughtful approach to data engineering. You must bring: - 5+ years of experience in data engineering, with at least 23 years dedicated to Snowflake development. - Advanced SQL expertise highly optimized queries, analytical functions, complex transformations, performance tuning. - Handson 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 nontechnical stakeholders. - A high bar for craft, reliability, and accuracy. Why Youll Love Working Here - Real Impact: Youll work on meaningful products that make a measurable difference from healthcare and commerce to sustainability and nextgen tech. - RemoteFirst, Office Friendly: Work from wherever youre most productive whether thats your home, a coworking space, or one of our offices. Were a remotefirst company, but if youre near an office, youre welcome to drop in, collaborate in person, or work onsite regularly. We prioritize async collaboration, respect your time zone, and focus on outcomes over hours. - An Outstanding Team: Talented, kind, and hardworking people who care deeply about their craft and about each other. No egos. No politics. Just professionals doing their best work. - Growth: Youll 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 highquality work, delivered sustainably. - Variety & Stability: Were profitable, independent, and over a decade strong. Yet every project brings a fresh challenge. Youll never be bored here. This Role Might Not Be for You We want to respect your time by being clear about what this role isnt. You should skip this opportunity if: - You prefer well defined structure. If you gravitate towards a clear hierarchy, well defined roles and swim lanes, you may find our selfmanaged style challenging. - Distributed work isnt your thing. If you find async communication, design documentation and being proactive without a manager nearby difficult, our setup wont suit you. - Feedback doesn't excite you. Were obsessed with quality and believe in continuous improvement. That means we give feedback thats sometimes nitpicky. If refining the work until its excellent feels over the top, you are likely going to find working here frustrating. - Change makes you uncomfortable. Were scaling and maturing. That means not everything is perfect yet. Priorities shift. Processes evolve. If ambiguity is uncomfortable, this may feel bumpy. However, if this sounds like fuel, wed love to talk! How to apply and what to expect in the interview process Our hiring process is structured as a sequence of steps. Moving forward is based on how well the previous step goes. This helps us stay focused, fair, and respectful of everyones time. We will always: - Let you know clearly what the next step is. - Share updates and feedback wherever possible. - Invite questions if anything feels unclear. Not everyone progresses through every stage. That doesnt mean youre not great at what you do. Sometimes its about timing, team fit, or simply what were looking for at the moment. Step 1: Express Your Interest If this sounds like your kind of team and youre ready to bring your craft to Lateral, we want to hear from you. Please send us: - Your resume. - A short note about what excites you about this role. - Links to your work: GitHub/Code snippets, portfolio, architecture /design docs, blog posts, or anything that shows us how you think and build. Please dont include anything sensitive or proprietary. If youre sharing team projects, let us know what your specific contributions were. We review every application with care. If theres a fit, well reach out to schedule next steps. Step 2: Talent Partner Conversation Purpose: A structured discussion with our People Experience team to delve into your career trajectory, motivations, and alignment with Laterals values. What to Expect: - Indepth questions about your past experiences and decisionmaking processes. - Exploration of your career goals and how they align with the role. - Discussion about our company culture, availability, compensation and other logistics. - Motivators and demotivators. - Your life outside coding. Preparation Tips: - Reflect on your career journey and pivotal moments. - Be ready to discuss challenges you've overcome and lessons learned. - Familiarize yourself with the Job Description, Lateral's mission and values. Step 3: Technical interview Purpose: Assess your technical proficiency and problemsolving abilities. Format: A collaborative session with our engineering team, focusing on realworld scenarios relevant to the role. What to Expect: - Problemsolving exercises/questions that mirror tasks you'd encounter in the position. - Discussions around your approach, reasoning, and solutions. Preparation Tips: - Practice articulating your thought process clearly and concisely. - Be prepared to discuss in depth past projects and the technologies used. Step 4: Operational interview Purpose: Understand your approach to prioritizing, collaborating, shipping, and iterating. What to expect: - How you prioritize and break down work. - How you collaborate across disciplines. - How you handle blockers, feedback, and iteration. Preparation Tips: - Pick 1-2 meaningful projects you led or heavily contributed to. - Walk through your process: what worked, what didnt, what youd do differently. - Think about how you manage time, scope, and changing requirements. Step 5: Reference Checks Purpose: We believe references are about understanding, not just validation. We do not look for perfection, but to understand patterns, strengths, and context. We use them to learn how to support you best. What to Expect: well ask you for 23 people whove worked closely with you. These are often: former managers, senior peers or collaborators, mentors or people youve mentored. What we ask: We focus on how youve grown, where you shine, how you like to be led, and what support sets you up for success. We want practical advice for making this a great fit for you. Yes, we do backchannels too: We do this when we feel we need more context. We will check with you if there are folks we should avoid reaching out due to confidentiality or other reasons. And heres our commitment: if anything surprising or unclear comes up in a backchannel, well bring it directly to you. We believe in no stories without you in the room. Youll always get the chance to share your side, context, or clarification. Step 6: Offer What Happens: If selected, you'll receive a comprehensive offer detailing compensation, and other pertinent information. Our hiring process is designed to be thorough yet respectful, ensuring a mutual fit. We encourage candidates to engage actively, ask questions, and view this as a twoway exploration. Join us and lets build something extraordinary. #J-18808-Ljbffr