Search Jobs

SAP Architect (SAP BW/HANA)

| West Chester, Pennsylvania

Back to Jobs

The Robinson Group has been retained to fill a newly created position for an expanding analytics group – the position is a SAP Architect (SAP BW/HANA).

**Base salary + bonus + stock + great benefits + excellent work/life balance.

**Relocation assistance and visa transfer/sponsorship are offered.

**The company is a leader in their industry and consistently voted one of the best places to work.

The SAP Architect (BW/HANA) will provide the technical expertise for the design, modeling and implementation of the organization’s SAP BW on HANA Enterprise Data Warehouse.

*Knowledge of Snowflake or Cloud Data warehouse is a must.

*Looking for understanding of S4, Data Sphere , SAC etc. – forward thinking SAP (hands-on experience is not required).

*Looking for a database background.

Utilizes functionality of the SAP BW on HANA environment and its surrounding components to provide real time/near real time data availability and meet business decision-making requirements through reports, dashboards, self-service and advanced analytics capabilities.

Designs and manages integration/dynamic tiering of data between HANA and Snowflake.

Architect data solutions that integrate data in the EDW following established security policies.

Lays out foundational components to migrate SAP BW to SAP Data Sphere and integration between Snowflake and SAP data Sphere.

  • Responsible for the architecture and design of the data for SAP BW on HANA. Responsible for both structured and unstructured data design into SAP BW on HANA.
  • Perform data analysis, data modeling and data design tasks on complicated datasets with potentially complex data integration scenarios for Hadoop and SAP BW on HANA. Design Enterprise Data Warehouse using SAP BW on HANA and native HANA platform.
  • Translate complex business and functional specifications into detailed technical design documents, applying SAP BW on HANA best practices, to provide efficient and maintainable reporting solutions, Dashboards, Self-service analysis.
  • Enable Sap Analytics Cloud as operational reporting tool across multiple SAP products SAP BW, S4, SAP CAR. Set design principles for SAC.
  • Based on technical design, build integrated BI solutions using SAP BW on HANA objects. These include both persistence layer (DataSources, InfoSources, InfoObjects, aDSOs, Hierarchies, Open Hub Destinations) and virtual layer (Composite Providers, open ODS Views, external HANA views, attribute views, analytical views, and calculation views).
  • Lead major technical initiatives, large development projects and upgrades in SAP BW on HANA and HANA. Lead internal and inter-team development projects and initiatives. Facilitate issue resolution between the BI team and the external IT business partners as appropriate.
  • Design and build HANA data models for BI tools like Tableau, MicroStrategy and other tools that are introduced.
  • Design and build data transformation, extraction, and load processes (ETL), including enablement of delta loads for both SAP-sourced and non-SAP data. Use scripting (e.g. SQL, Python) or ABAP AMDP to create automated load processes. Objects include Transformations, APDs, HAPs (HANA Analysis Process).

Your background:

  • Bachelor’s degree in Information Technology or a technical discipline (e.g. engineering) preferred
  • Hands-on design and development experience including 3+ years of SAP BW, and 1-2 years with HANA. BW 7.4 on HANA, with BW 7.5 preferred
  • In depth experience with HANA Studio (e.g. Advanced DSO’s, ODS Views, Composite Providers etc.) and modeling in BW
  • Familiarity with Self-Service applications on top of SAP-BW/HANA
  • Understanding legacy BW infrastructure and relationship to HANA objects (e.g. InfoCubes and MultiProviders vs aDSOs, Composite Providers, and HANA Views)
  • Experience with S4 is a plus
  • Experience with BI extractors from the ECC system and working knowledge of SAP structures, object dependencies, and tables in version ECC 6.0 environment
  • Hands-on experience on ABAP in BW writing ABAP code in DataSource enhancements, function module extractors, routines, BEx exits
  • Experience with SAP HANA programming including SQL, SQL script
  • Experience with SAP HANA data provisioning (SDI – Smart Data Integration preferable)
  • Experience in using mixed scenarios with SAP BW components such as Composite Providers and Open ODS Views with native HANA Tools
  • Experience in handling integration among multiple systems for reporting such as SAP ECC, SAP BW, Hadoop, SAS, MicroStrategy, Tableau
  • Transport management of both classic BW and HANA objects
  • Knowledge of Hadoop
  • MicroStrategy or Tableau experience
  • Data administration experience including managing schemas and data model objects preferred
  • Familiarity with AMDP processes and structures needed for HANA Stored Procedures preferred
  • Experience leading large and complex projects
  • Possess deep technical knowledge of SAP BW on HANA including performance optimization, ETL/ELT, integration with big data platform and interaction with other systems and Business Intelligence tools (e.g. Hadoop, MicroStrategy, Tableau)
  • Experience with S4, Data sphere, data warehouse Cloud is a plus
  • Knowledge of Snowflake or Cloud Data warehouse is a must

  • Max. file size: 300 MB.

Your partner in career advancement

You want an advocate who represents both your goals and vision, that guides you and helps you navigate your career search. We will help you achieve your potential – we want to talk to you.
Contact