Job Description

About Brillio:
Brillio is one of the fastest growing digital technology service providers and a partner of choice for many Fortune 1000 companies seeking to turn disruption into a competitive advantage through innovative digital adoption. Brillio, renowned for its world-class professionals, referred to as "Brillians", distinguishes itself through their capacity to seamlessly integrate cutting-edge digital and design thinking skills with an unwavering dedication to client satisfaction. Brillio takes pride in its status as an employer of choice, consistently attracting the most exceptional and talented individuals due to its unwavering emphasis on contemporary, groundbreaking technologies, and exclusive digital projects. Brillio's relentless commitment to providing an exceptional experience to its Brillians and nurturing their full potential consistently garners them the Great Place to Work® certification year after year.
Lead Data Engineer / Snowflake Engineer (AWS, Agentic AI)

Specialization

Big Data Analytics, Snowflake and Agentic AI, LLM

Job requirements

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

Location: Montreal, Canada
Work Model: 3-4 days onsite

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

Know what it’s like to work and grow at Brillio: Click here