Description:
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.
▪ Strong 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.
| Organization | Ampstek |
| Industry | Architect / Interior Design Jobs |
| Occupational Category | SAP BW Architect |
| Job Location | Toronto,Canada |
| Shift Type | Morning |
| Job Type | Full Time |
| Gender | No Preference |
| Career Level | Experienced Professional |
| Experience | 10 Years |
| Posted at | 2026-08-31 2:54 pm |
| Expires on | 2026-10-15 |