Senior Snowflake Engineer (Canada, Pacific Time) at Lateral Group

Ottawa, Ontario, Canada -

Full Time

Start Date

Immediate

Expiry Date

10 Mar, 26

Salary

0.0

Posted On

10 Dec, 25

Experience

5 year(s) or above

Remote Job

Yes

Telecommute

Yes

Sponsor Visa

Skills

Snowflake, SQL, Data Engineering, ETL, Data Modeling, Data Quality, Cloud Data Ecosystems, BI Tools, Performance Tuning, Data Governance, CI/CD, Collaboration, Documentation, Agility, Problem Solving, Communication

Industry

IT Services and IT Consulting

Description

Lateral stands for technology excellence. We’re 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 isn’t just the talent of our team - it’s the way we work: We Have A Bias For Action & Results. We are doers - we spot the gaps, connect the dots, anticipate what’s 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 It’s the Right Thing to Do Right over easy. Integrity isn’t up for negotiation. We hold the bar high even when no one’s watching. We take pride in doing great work the right way - not the easy way. We Keep Improving The best teams keep improving and we’re never done learning. We iterate. We reflect on what’s working and what’s not. Feedback fuels us, we receive it openly, and adapt quickly. Progress over perfection. We’re Obsessed With Agility, Not The Agile Manifesto We don’t 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 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. Whatever the challenge, you’ll be building software that changes lives and moves industries forward. We measure success through: Evaluating results (what you’ve shipped) Quality and reliability of your code. Consistency in delivery. Feedback from peers and leads. Your ability to work independently and unblock others. What We’re Looking For We are seeking for team members who are both highly technical and deeply care about their craft and how the work gets done. We’re looking for a strong, hands-on 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 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. Why You’ll Love Working Here 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. We prioritize async collaboration, respect your time zone, and focus on outcomes over hours. 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. This Role Might Not Be for You We want to respect your time by being clear about what this role isn’t. 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 self-managed style challenging. Distributed work isn’t your thing. If you find async communication, design documentation and being proactive without a manager nearby difficult, our setup won’t suit you. Feedback doesn't excite you. We’re obsessed with quality and believe in continuous improvement. That means we give feedback that’s sometimes nitpicky. If refining the work until it’s excellent feels over the top, you are likely going to find working here frustrating. Change makes you uncomfortable. We’re 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, we’d 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 everyone’s 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 doesn’t mean you’re not great at what you do. Sometimes it’s about timing, team fit, or simply what we’re looking for at the moment. Step 1: Express Your Interest If this sounds like your kind of team and you’re 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 don’t include anything sensitive or proprietary. If you’re sharing team projects, let us know what your specific contributions were. We review every application with care. If there’s a fit, we’ll 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 Lateral's values. What to Expect: In-depth questions about your past experiences and decision-making 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 problem-solving abilities. Format: A collaborative session with our engineering team, focusing on real-world scenarios relevant to the role. What to Expect: Problem-solving 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 didn’t, what you’d 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: we’ll ask you for 2–3 people who’ve worked closely with you. These are often: former managers, senior peers or collaborators, mentors or people you've mentored. What we ask: We focus on how you’ve 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 here’s our commitment: if anything surprising or unclear comes up in a backchannel, we’ll bring it directly to you. We believe in “no stories without you in the room.” You’ll 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 two-way exploration. Join us and let’s build something extraordinary.

Responsibilities

As a Senior Snowflake Engineer, you will design, develop, and maintain scalable data pipelines and transformation logic using Snowflake. You will also collaborate with various teams to ensure data solutions meet real business needs.