Job Title: SAP BW Architect

Job Location: Toronto, Canada (Hybrid)

Technical Experience

▪ Minimum 10 years of SAP BW experience, with at least 3 full end-to-end BW/4HANA conversion or greenfield implementation projects.

▪ Demonstrated hands-on delivery of the SAP Remote Conversion (Brown Field) approach, including SUM execution,

Starter Add-on installation, RFC remote transfer, and BW/4HANA-native simplification.

▪ Deep expertise in BW/4HANA-native structures: ADSO (standard, write-optimised, direct-update), CompositeProvider,

Open ODS View, HANA Calculation Views, and LSA++ architecture.

▪ Proficiency in HANA pushdown optimisation: AMDPs, SQLScript, HANA database procedures, partition strategies and columnar storage tuning.

▪ Robust ABAP development background: code inspector, ATC, SPAU/SPDD execution, HANA-compatibility remediation,

user exits, BAdIs, transformation routines.

▪ Experience with the SAP BW/4HANA Readiness Assessment toolset (pre-check programs, SWPM, code analysis reports) and interpretation of the output for planning purposes.

▪ Proven experience managing large BW landscapes: comfortable designing and executing migrations with 5,000+

objects and 400+ GB data volumes.

▪ Integration competency:



SAP ODP framework, SAP CPI, SOAP/REST web services, SuccessFactors, ServiceNow,

Fieldglass extractors, Open Hub, Finance BW outbound feeds.

▪ Reporting-layer expertise: BEx Query Designer, Analysis for Office, SAP Analysis for Office, Power BI connectivity to

BW/4HANA, BusinessObjects universe administration.

▪ SAP security and authorisation framework in BW/4HANA: analysis authorisations, GRC-integrated role design, SSO configuration.

Domain Knowledge

▪ Prior experience in the HR / HCM reporting domain strongly preferred: familiarity with SAP HCM, SuccessFactors and payroll data structures.

▪ Experience in the Energy & Utilities industry or other regulated environments is an advantage.

Preferred / Differentiating Skills

▪ SAP Certified Technology Associate — SAP BW/4HANA or equivalent BW certification.

▪ Knowledge of SAP BASIS activities relevant to BW/4HANA: SWPM, transport management, system refresh, OS/DB migration.

▪ Familiarity with Power BI semantic model design and DirectQuery / Import mode connectivity to BW/4HANA.

Experience - 11+

Thanks & Regards

Michael [email protected]

📌 SAP BW Architect (Toronto)
🏢 Ampstek
📍 Toronto