WAWA – Wawa, Inc. – Corporate Office
Job Summary : 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. Leads internal and inter-team development projects and initiatives.
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.
Partner with administrative system management teams on BI performance, system maintenance, and SAP security. Establish a performance baseline. Monitor system load and reporting and tune for peak performance. Use resources including SAP Knowledge Base and Notes.
Develop, promote and implement team processes and technical standards, including technical and support documentation for any modified or developed BI components.
Support nightly BI batch processes and identify and resolve any recurring issues.
Research and implement new technologies to increase productivity and performance. Participate and provide input and guidance to tool selection.
Adhere to Corporate EIM (Enterprise Information Management) standards throughout BI reporting.
Adhere to IT Security Policies, Standards and Procedures.
Practice BW query management process to maintain queries in BI environment.
Work individually, with minimal supervision, as well as in team environments
Detail oriented, well organized work skills
Manage time and stress appropriately
Prioritize work, considering the bigger picture, ensuring alignment with department objectives
Analyze and solve development, maintenance, and support challenges
Handle multiple projects simultaneously and independently
Work well with people within the team and the department, and with outside people, as required
Proven self-starter with demonstrated ability to make decisions in their assigned work
On-call 24/7 required (rotating)
Contribute to the development of peers, including cross-training to ensure coverage and shared departmental knowledge
Create work plans with specific dates, and adhere to them and to external deadlines
Facilitate inter-team issue resolution
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
Knowledge of Hadoop
MicroStrategy or Tableau experience preferred
Data Administration experience including managing schemas and data model objects preferred
Familiarity with AMDP processes and structures needed for HANA Stored procedures preferred
Wawa will provide reasonable accommodation to complete an application upon request, consistent with applicable law. If you require an accommodation, please contact our Associate Service Center at [email protected] or 1-800-444-9292.
Wawa, Inc. is an equal opportunity employer. Wawa maintains a work environment in which Associates are treated fairly and with respect and in which discrimination of any kind will not be tolerated. In accordance with federal, state and local laws, we recruit, hire, promote and evaluate all applicants and Associates without regard to race, color, religion, sex, age, national origin, ancestry, familial status, marital status, sexual orientation or preference, gender identity or expression, citizenship status, disability, veteran or military status, genetic information, domestic or sexual violence victim status or any other characteristic protected by applicable law. Unlawful discrimination will not be a factor in any employment decision.