Back to job search
HCLTech logo

Snowflake integration lead

  • Mississauga, ON
  • On-site
  • Posted Nov 19, 2026
  • 1 position

$90,000–$120,000 / year

Opens LinkedIn

Sign in to save this job
Employment type
Full-time
Minimum education
Bachelor’s degree
Posting language
English
Application method
Apply on LinkedIn (LinkedIn sign-in required)

Job summary

Design, develop, and optimize data pipelines, SQL queries, warehouses, and data models, translating business needs into reliable, reusable data solutions. Ensure quality and operational continuity through testing, documentation, monitoring, deployment support, incident resolution, and mentoring engineers.

Job details

Senior Technical Architect Duties & Responsibilities • Senior Architect who design, development, and optimization of ETL/ELT pipelines and workflows • Write, tune, and optimize advanced SQL queries for large-scale data processing • Build and maintain data warehouses and data models (relational, dimensional, star schema) • Translate business requirements into robust, well-architected, and reusable data solutions • Partner with analysts, data scientists, and stakeholders to deliver trusted, actionable datasets • Implement and maintain unit tests, integration tests, and validation frameworks to ensure pipeline reliability • Document workflows, and design decisions to support knowledge sharing and operational continuity • Apply coding standards, CI/CD practices, version control, and peer code reviews to ensure high-quality deliverables • Proactively monitor, optimize, and troubleshoot pipelines for performance, scalability, and cost efficiency • Support deployments and handle post-production monitoring and incident resolution • Mentor associate and mid-level engineers, providing technical guidance and feedback Requirements Education Requirements Minimum Bachelor’s Engineering Degree Preferred Master’s Degree Minimum Years of Experience 10+ Yrs. - Data Engineering & Architect 4+ Yrs. - Snowflake or any cloud Datawarehouse 1+ Yrs. - Python 1+ Yrs. - Cloud Platforms Basic Qualifications • Bachelor’s degree in computer science, Information Systems, Engineering, or a related field • 10-14 years of hands-on experience in data engineering or related fields • Expertise in SQL (query optimization, advanced functions, performance tuning) • Minimum 3 years of hands-on experience with Snowflake or equivalent modern cloud data warehouse • Minimum 2 years of hands-on experience in data modeling (relational & dimensional) • Minimum 2 years of hands-on Python development (ETL/ELT scripting, OOP, automation) • Strong hands-on experience with data warehousing concepts, design, and implementation • Strong knowledge of at least one major cloud platform (AWS, Azure, or GCP) • Experience with orchestration tools (e.g., Airflow, ADF, Luigi) for workflow management • Demonstrated ability to lead and mentor teams while managing multiple priorities • Strong communication and stakeholder management skills Preferred Qualifications • Hands-on experience with DBT (Data Build Tool) for data transformations • Familiarity with CI/CD, Git, and DevOps practices in a data engineering context • Experience with real-time/streaming platforms (Kafka, Spark Streaming, Flink) • Exposure to the e-commerce domain or large-scale customer data environments • Has the ability to break down problems and estimate time for development tasks • Experience mentoring and guiding junior engineers • Understands the technology landscape, up to date on current technology trends and new technology, brings new ideas to the team • Learns organization vision statement and decision-making framework. Able to understand how team and personal goals/objectives contribute to the organization vision

What you’ll do

Design, develop, and optimize data pipelines, SQL queries, warehouses, and data models, translating business needs into reliable, reusable data solutions. Ensure quality and operational continuity through testing, documentation, monitoring, deployment support, incident resolution, and mentoring engineers.

Requirements

Requires a bachelor's degree and 10–14 years of data engineering or related experience, including hands-on expertise in SQL, cloud data warehousing, data modeling, Python, and a major cloud platform. Candidates should also have workflow orchestration experience, strong communication and leadership skills, and the ability to manage priorities; DBT, CI/CD, and streaming technologies are preferred.

Listed skills

  • SQL · Preferred
  • Python · Preferred
  • CI/CD · Preferred
  • Git · Preferred
  • Team Leadership · Preferred
  • Stakeholder Management · Preferred

Other relevant skills

Identified from the job description. Confirm important requirements above.

  • Snowflake
  • SQL
  • Python
  • ETL/ELT
  • Data Engineering
  • Data Warehousing
  • Data Modeling
  • Cloud Platforms
  • Workflow Orchestration
  • Airflow
  • Azure Data Factory
  • Data Pipeline Optimization
  • CI/CD
  • Git
  • Team Leadership
  • Stakeholder Management

Job areas

  • Data & Analytics
  • Technology
  • Software
  • Management & Leadership
  • Consulting

More jobs from HCLTech

See all jobs from HCLTech