Lead Consultant(Product/Domain)

HCLTech
Apply Now ↗
📍 Vancouver, Canada

About this role

Job Summary

Job Title: SAP NATIVE HANA Consultant

Overview

We are looking for an experienced SAP HANA Consultant with over 8+ years of hands-on experience in implementing, configuring, and supporting HANA systems in both standalone and sidecar architectures. Skilled in data modeling, SLT replication, performance tuning, and integration with S/4 & non-SAP systems. Proven ability to deliver real-time analytics solutions and optimize reporting performance.

 

Key Responsibilities

Responsibilities

  • Design and develop Attribute, Analytic, and Calculation Views (Graphical and SQLScript-based).
  • Create complex Calculation Views using Table Functions, and SQLScript.
  • Use variables and input parameters to enable dynamic data filtering.
  • Develop stored procedures and functions to handle business logic in the database layer.
  • Implement Hierarchies, Restricted, and Calculated Columns in HANA models.
  • Optimize joins, aggregations, and projections for faster execution.
  • Refactor complex Calculation Views by leveraging Aggregation Nodes, Star Join, and pruning techniques.
  • Integrate HANA models with BusinessObjects (BO), Tableau / Power BI.

Skill Requirements

Required Skillsets

  • Minimum 8+ years of experience in Native HANA development, data modeling, SQLScript, and performance optimization.
  • Proven expertise in designing end-to-end data models, optimizing complex HANA views, and delivering scalable analytics solutions.
  • Adept at integrating SAP HANA with S4 HANA and non-SAP systems to drive business intelligence and data-driven decision-making.
  • Expertise in SQLScript, Table Functions, and advanced Calculation Views.
  • Strong experience in SLT, SDI, SDA for data provisioning.
  • Knowledge of HANA XS/XS Advanced, OData services.
  • Experience with performance tuning and query optimization in HANA.
  • Strong experience in integration with BOA, Webi, Tableau, Power BI.
  • Strong analytical, problem-solving, and communication skills.

Other Requirements

Frequently Asked Questions

Is the salary disclosed for the Lead Consultant(Product/Domain) position at HCLTech?
The salary for this Lead Consultant(Product/Domain) role at HCLTech is not publicly listed. Click "Apply Now" to learn more about the compensation package on their official careers page.
Where is the Lead Consultant(Product/Domain) position at HCLTech located?
This Lead Consultant(Product/Domain) role at HCLTech is based in Vancouver, Canada. The position is listed as on-site or hybrid. Check the full job description or apply directly to confirm the work arrangement.
How do I apply for the Lead Consultant(Product/Domain) position at HCLTech?
Click the "Apply Now" button on this page. You will be redirected to HCLTech's official application portal hosted on successfactors where you can submit your application directly.
When was the Lead Consultant(Product/Domain) job at HCLTech posted?
This Lead Consultant(Product/Domain) position at HCLTech was posted on Oct 6, 2026. Apply as soon as possible — early applications are often reviewed first.
Lead Consultant(Product/Domain)
HCLTech
Apply for this role ↗

You'll be redirected to HCLTech's official application page on successfactors.