Lead Consultant(Product/Domain)

Vancouver, British Columbia

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.
Solid 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.
Robust experience in integration with BOA, Webi, Tableau, Power BI.
Robust analytical, problem-solving, and communication skills.

Other Requirements

📌 Lead Consultant Product/domain Vancouver
🏢 HCLTech
📍 Vancouver