Skip to content
Search jobs inside your AI agent. Claude, ChatGPT, Claude Code, Codex, Gemini, Cursor and Grok
Connect

HCLTech

NewBe an early applicant

Senior Technical Architect (Data Engineering)

Posted

Summary

Senior Technical Architect focused on designing, building, and optimizing ETL/ELT data pipelines, data warehouses, and data models. Day-to-day work centers on advanced SQL, Snowflake, Python, and a major cloud platform (AWS/Azure/GCP), with CI/CD practices, pipeline monitoring, and mentoring of junior engineers. Onsite role in Mississauga, Ontario.

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


Education Requirements

Minimum Bachelor’s Engineering Degree Preferred Master’s Degree

• Bachelor’s degree in computer science, Information Systems, Engineering, or a related field


Technical Experience

• 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

Skills

What Senior Data Engineering jobs ask for — and how much of it you have →
Apply

See also

Data Engineering jobs by country — openings, pay and top skills →