SAP BW Architect

Ampstek; Toronto; On-site; CAD 120,000 - 160,000; Full time

Job summary

Ampstek is seeking an SAP BW/4HANA architect with a decade of BW experience to lead complex migrations and enhance reporting capabilities. The role requires hands-on delivery across BW/4HANA structures, HANA optimisation, ABAP background, and integration with SAP ecosystem tools.

The candidate will design end-to-end solutions for large data landscapes, review readiness assessments, and collaborate with onshore/offshore teams in a hybrid delivery model.

Qualifications

• Minimum 10 years of SAP BW experience with at least 3 end-to-end BW/4HANA projects.
• Hands-on delivery of SAP Remote Conversion (Brown Field) incl. SUM, Starter Add-on, RFC remote transfer.
• Deep expertise in BW/4HANA structures: ADSO, CompositeProvider, Open ODS View, HANA views, LSA++.
• Proficiency in HANA pushdown optimisation: AMDPs, SQLScript, HANA procedures, partitioning, and columnar storage tuning.
• Strong ABAP background: code inspector, ATC, SPAU/SPDD, HANA compatibility remediation.
• Experience with BW/4HANA Readiness tools, pre-checks, SWPM, and interpretation for planning.
• Proven large BW landscape management: migrations with 5k+ objects and 400+ GB data.
• Integration with ODP, CPI, SOAP/REST, SuccessFactors, ServiceNow, Fieldglass, Open Hub.
• Reporting layer: BEx, Analysis for Office, SAP Analysis for Office, Power BI connectivity to BW/4HANA.
• Security: BW/4HANA authorization, SSO, GRC-based roles.

Responsibilities

Skills

SAP BW

BW/4HANA

ADSO

CompositeProvider

Open ODS View

HANA Calc. Views

LSA++

AMDPs

SQLScript

HANA procedures

Partitioning

Columnar storage

ABAP development

Code Inspector

ATC

SPAU/SPDD

Readiness assessment

SWPM

5,000+ objects

400+ GB data

ODP framework

CPI

SOAP/REST

SuccessFactors

Fieldglass

Open Hub

BEx Query

Analysis for Office

Power BI BW

BO universe

SSO

GRC

Architecture docs

Tools

SAP BW/4HANA

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 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.
• Track record of leading technical delivery on fixed-price SAP programmes with formal milestone governance.
• Comfortable presenting technical risks, architectural decisions and cutover plans to client CTO / IT Director level.
• Experience working in a hybrid onshore / offshore delivery model; ability to direct and review offshore team output effectively.
• Strong written communication: ability to produce Architecture Design Documents, Conversion Runbooks, Test Strategy documents and Technical Specifications to a client-publishable standard.