Lead Data Engineer / Snowflake Engineer (AWS, Agentic AI)

Job Description – Lead Data Engineer / Snowflake Engineer (AWS, Agentic AI)

Location: Montreal, Canada 3-4 days onsite

Duration : Long Term

Role Overview

We are hiring a Lead Data Engineer / Snowflake Engineer with deep expertise in Snowflake on AWS and hands-on exposure to Agentic AI / Generative AI–driven data platforms. This role will lead the design, modernization, and scaling of cloud‑native data architectures that power analytics and AI initiatives.

Key Responsibilities

• Architect, design, and optimize Snowflake data platforms on AWS for high performance and cost efficiency
• Lead end‑to‑end ELT/ETL pipelines using Snowflake, AWS services, and modern data engineering tools
• Implement advanced Snowflake features (Performance Optimization, Warehousing strategy, Data Sharing, Streams & Tasks, Time Travel, Zero Copy Cloning)
• Design data foundations that support Agentic AI and GenAI workloads, including AI‑ready datasets, vectorized data, and metadata‑driven pipelines
• Collaborate with AI/ML teams to enable autonomous agents, LLM‑driven analytics, and intelligent data orchestration
• Provide technical leadership, code reviews, and mentoring to data engineering teams
• Partner with business and product stakeholders to translate analytics and AI requirements into scalable data solutions

Required Skills & Experience

• 8–10 years of experience in Big Data Engineering / Analytics
• Expert‑level Snowflake experience, including large‑scale production deployments
• Strong hands-on experience with AWS (S3, EC2, Lambda, Glue, Redshift/Athena, IAM, CloudWatch, Step Functions)
• Proven experience building cloud‑native data architectures on AWS
• Solid programming skills in Python and SQL
• Experience with data modeling for analytics and AI use cases
• Hands-on or applied exposure to Agentic AI, Generative AI, or AI‑driven data platforms
• Experience leading or mentoring engineering teams in enterprise environments

Highly Desirable

• Experience integrating LLMs, autonomous agents, or AI orchestration frameworks with data platforms
• Exposure to vector databases, embeddings, or AI‑optimized data pipelines
• Experience with dbt, Airflow, Kafka, Spark, or similar tools
• Prior onsite experience in large, complex enterprise data ecosystems

Thanks,

Amaresh

Sr. Technical Recruiter

Momento USA | Exceeding Customer Expectations

440 Benigno Blvd, Unit#A 2nd Floor. Bellmawr, NJ 08031

Interstate Business Park

Direct : Ext (1022)

Email: 

Are You LinkedIn?:

Minority Certified by SWAM
National Minority Certified by NMSDC

One of the fastest growing company in NJ
Awarded fastest growing Asian American business by Diversitybusiness.com
E-verified Company

Information transmitted by this e-mail is proprietary to Momento USA and/ or its Customers and is intended for use only by the individual or entity to which it is addressed, and may contain information that is privileged, confidential or exempt from disclosure under applicable law. If you are not the intended recipient or it appears that this mail has been forwarded to you without proper authority, you are notified that any use or dissemination of this information in any manner is strictly prohibited. In such cases, please notify us immediately at and delete this mail from your records.

Note: Momento USA is an Equal Opportunity/Affirmative Action Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, pregnancy, sexual orientation, gender identity, national origin, age, protected veteran status, or disability status.