Job Title

Senior Snowflake Engineer (Canada, Pacific Time) Get AI-powered advice on this job and more exclusive features. 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 . 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 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. 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 home, 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. 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 You prefer welldefined structure. If you gravitate towards a clear hierarchy, welldefined 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. 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. Step 1: Express Your Interest 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 Do not include sensitive or proprietary material. If youre sharing team projects, let us know what your specific contributions were. 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. Expect indepth questions about your past experiences, career goals, company culture, availability, compensation, and other logistics. 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. Expect problemsolving exercises and discussions around your approach, reasoning, and solutions. Step 4: Operational interview Purpose: Understand your approach to prioritizing, collaborating, shipping, and iterating. Expect discussion on how you prioritize and break down work, collaborate across disciplines, and handle blockers, feedback, and iteration. Step 5: Reference Checks Purpose: Gain insight into your growth, strengths, and how you shine. We request 23 references from managers, peers, collaborators, or mentors. Step 6: Offer What Happens: If selected, you''''ll receive a comprehensive offer detailing compensation and other pertinent information. We encourage candidates to engage actively, ask questions, and view this as a twoway exploration. Join us and lets build something extraordinary. Job Details Seniority level: MidSenior level Employment type: Fulltime Job function: Engineering and Information Technology Industry: IT Services and IT Consulting Referrals increase your chances of interviewing at Lateral Group by 2x #J-18808-Ljbffr