Lead Consultant(Product/Domain)
Canada
Job Description
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.
  • 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

Information at a Glance

Why HCLTech?

At HCLTech, you'll supercharge your potential. You'll find your career. And you'll find your spark. All at a place that knows that helping its customers stay on top starts by putting its people first.

HCLTech is a global technology company, home to more than 223,000 people across 60 countries, delivering industry-leading capabilities centered around digital, engineering, cloud and AI, powered by a broad portfolio of technology services and products. We work with clients across all major verticals, providing industry solutions for Financial Services, Manufacturing, Life Sciences and Healthcare, Technology and Services, Telecom and Media, Retail and CPG, and Public Services. Consolidated revenues as of 12 months ending June 2026 totaled $14.8 billion.