Senior SAP BI Engineer

Employment Type

: Full-Time

Industry

: Information Technology



Loading some great jobs for you...





The Robinson Group has partnered with longstanding client to fill a critical, newly created position. The company is successful, growing, has excellent work/life balance, and offers a competitive base salary, bonus and long term incentives. Please send your resume to joliverrobinsongroup.com to start the process. The Senior Engineer BI designs, develops and enhances functionality in the SAP BW on HANA environment to meet new business requirements and data availability through reports, dashboards, etc. Possesses deep technical understanding of SAP BW on HANA including data modeling, optimization, data extraction, loading, transformation and reporting. Manages escalation and resolution of complex issues. Participates in the design and implementation of new technical solutions and tools. Responsibilities Translate business and functional specifications into detailed technical design documents, applying SAP BW on HANA best practices, to provide optimal reporting solutions for projects. Based on technical design, build 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). Create data transformation, extraction, and load processes (ETL), including enablement of delta loads for both SAP-sourced and non-SAP data. Use SQL scripting or ABAP AMDP to build transformational processes. Establish automated load processes, eliminating manual processes. Objects include Transformations, DTPs, APDs, HAPs (HANA Analysis Process). Create SAP reporting objects, including queries, variables, and reporting structures using BEx Query Designer or Eclipse-based BW Query functionality of HANA Studio. Use Web Application Designer for iViews and SAP Portal integration. Create MicroStrategy reporting objects, including attributes, facts, metrics, reports, documents, dossiers, and dashboards. As needed, create SAP HANA views for use as MicroStrategy or other reporting tool source. Implement bi-directional integration of HANA with Hadoop data lake big data infrastructure, using SDI, SDA, HDFS, or other ETL tool. Implement bi-directional integration of HANA with MicroStrategy, Tableau, and other reporting and analytical tools. Maintain all objects to achieve optimal performance across all reporting tools. Build and enable report distribution via broadcast, SAP portal, MicroStrategy, or other tools. Handle testing technical side for all phases from unit testing through integration testing. Debug SAP BW HANA and related components. Implement solutions in production, including BW and HANA transports, and job scheduling, including process chains. Maintain legacy BW objects as required, or convert to newer object types. Legacy objects include DSOs, InfoCubes, MultiProviders, InfoSets, Update rules, Transfer rules. Investigate and resolve Business Intelligence production problems. Identify the root causes quickly and facilitate resolution between the BI team and external IT business partners. Qualifications Bachelor s degree in Information Technology or a technical discipline (e.g. engineering) preferred 7 years of hands-on design and development experience including 3-5 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 working with BW models 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 ADSO s, Composite Providers, and HANA Views) 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 - provided by Dice
Associated topics: business analyst, business intelligence, business systems, business systems analyst, client, consultant, crm, customer, information technology consultant, sales

Launch your career - Upload your resume now!

Upload your resume

Loading some great jobs for you...