Senior BW Consultant – SAP Trade Promotion Management (TPM)

About the role

Infosys is looking for an experienced Senior BW Consultant to lead the design, architecture, and delivery of enterprise‑wide Trade Promotion Management (TPM), Customer Business Planning (CBP), Trade Spend Management, and analytics solutions. The role will be based in Calgary (with potential work in Mississauga) and involves close collaboration with technical and functional teams.

Key responsibilities

• Lead end‑to‑end architecture for SAP TPM, CBP, Trade Spend, Forecasting, and Accrual Reporting solutions.
• Design and govern SAP BW/4HANA data models, reporting, planning, and analytics solutions.
• Architect integrations between SAP TPM, S/4HANA, CRM, BW, and IBP environments.
• Drive promotion effectiveness reporting, trade spend analytics, gross‑to‑net reporting, and customer profitability analytics.
• Lead BW‑IP planning models, planning functions, planning sequences, and forecasting solutions.
• Mentor technical teams and provide architectural governance for delivery and support initiatives.

Required profile

• Bachelor’s degree or equivalent, or three years of progressive experience in lieu of each year of education.
• At least 4 years of Information Technology experience.
• Located within commuting distance of Mississauga or willing to relocate; travel within Canada may be required.
• Authorized to work in Canada without employer‑based visa sponsorship.

Required skills

• Strong experience in SAP BW/4HANA development and administration.
• Hands‑on expertise with ADSO, Composite Providers, Open ODS Views, Process Chains, Transformations, DTPs, and BW Query Design.
• Extensive SAP BW‑IP implementation experience, including FOX formulas, Planning Functions, Planning Sequences, and Aggregation Levels.
• Knowledge of SAP HANA modeling and SQLScript, as well as AMDP development.
• Experience integrating SAP CRM and SAP S/4HANA with BW/4HANA environments.