19 Nov
|
HCLTech
|
Mississauga
19 Nov
HCLTech
Mississauga
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) •
- Robust 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
📌 Snowflake integration lead (Mississauga)
🏢 HCLTech
📍 Mississauga