The Lead Applications Analyst-Business Warehouse is responsible for technical design, construction, and performance tuning of SAP business warehouse InfoProviders (DSO, Master Data, and Infocubes), and Systems (including web interface, BI Portals) related to delivery of business intelligence analytics to users. Plan, develop, coordinate, and test maintenance activities for SAP BW with the SAP Basis team. Day to day support with End Users and System/Job monitoring. Advanced working knowledge of the SAP applications / BW tools/data environment as well as excellent systems and business process analysis, project management, portfolio management, and communication skills required.
Perform business requirement determination, analysis, and design for SAP business warehouse and business intelligence initiatives. Determine best solution and tools to best meet current and future business requirements. Develop and Review design specifications for data conversions and data transfers (ETL). Create or modify data models and star schema diagrams pertinent per approved specifications. With the business users, design formatted workbook reports and Dashboards. Provide estimates; manage time line and deliverables for responsible projects and tasks. Ensure validity and accuracy of BW data. Working with the team, create and maintain data warehouse and business intelligence standards, policies, procedures, and documentation; and ensure best practices are followed. Create and/or modify BW InfoProviders, according to design specifications. Coordinate and complete data conversions, data transfers, and other development with ABAP development team. Configure SAP ECC Data sources. Design and create BW queries and reports using Bex Query Designer and Analyzer. Design and create web analyzer queries/templates, and publish reports as required. Balancing BW data targets with the source data.