SAP BW Architect

Ampstek; Toronto; On-site; CAD 130,000 - 180,000; Full time

Job summary

Ampstek seeks a senior SAP BW/4HANA professional with 10+ years of SAP BW experience and a proven track record of end-to-end BW/4HANA migrations. You will lead complex landscapes, perform readiness assessments, and drive data architecture using ADSOs, Open ODS, and HANA calculations.

Expertise in ABAP, security, and reporting tools such as BEx, Analysis for Office, and Power BI is essential. Strong communication and project leadership are required.

Qualifications

• Minimum 10 years of SAP BW experience with 3+ full end‑to‑end BW/4HANA projects.
• Hands‑on delivery of SAP Remote Conversion (Brown Field) with SUM, Starter Add‑on, RFC remote transfer, BW/4HANA simplification.

Responsibilities

• Lead large BW landscapes design and migrations (5,000+ objects, 400+ GB data).
• Deliver BW/4HANA readiness assessments and interpret SWPM outputs for planning.

Skills

SAP BW/4HANA

ABAP development

HANA optimization

BW/4HANA migrations

Power BI connectivity

BEx/Analysis for Office

Open Hub/OLAP sources

GRC/SSO/ security

HANA XS/ADSOs

Data volume management

Education

SAP BW/4HANA Certification

Tools

SWPM

RFC remote transfer

HANA calculation views

BEx Query Designer

Analysis for Office

Job description

• 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
• 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.
• 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
• 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
• 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.