Standard Bank Job Description – SAP Analytics Cloud Planning DeveloperIdentifiersFunctional Job title*SAP Planning DeveloperKey ResponsibilitiesSAP Analytics Cloud development· Development of SAC Planning models and dimensions· Import jobs from various source systems into SAC· Maintain and develop of data actions including advanced formulas· Ability to create processes of integration within SAC planning models using cross model copy· Assist with security build and issues experienced using teams/roles and data access control within SAC· Understand business requirements and translate to a technical build within SAC· Solutioning designs and various options with business in order to provide optimal output· Monthly maintenance of master data and loading of actual data set into models· Build and maintenance of FX currency models and tables· Reconciliation build between A4O and SAC· Support during planning cycles with assisting users build input templates and successfully reportBPC and BW skills (Experience and Skill is advantageous)· Ability to work in SAP BW and understanding of technical objects and data flow within BWOutput group 1*System SupportOutputs and measures*In conjunction with business requirements and best practise the following is required for each suite/application:SAC Modelling:· Creating, Updating, Amending the user interface/screens· Amending model designs and structures· Understanding of model preferences and output of each setting· Maintain data locks within model with minimal impact on users· Use of multiple hierarchies (BW and custom hierarchies)· Data access control (security) setup on dimensions· Ability to create models with optimal performance benefit· Ability to work closely with the source system (BW/SQL) and integrate into SAC· Able to work with complex structures and high volumes of data· Setting up import jobs in an adequate and best practice manner· Scheduling and automation of import jobs into BW· Resolution of technical issues is necessarySAC Data Actions· Creation of cross model copy with best ways to integrate across models including mappings of different hierarchies between source and target model (detailed model to aggregated model)· Copy within models· Allocation processes build process and rules and maintain· Advanced formula- using scripting functionality and ability to script advanced calculations is required (eg. Float variables, link formulas, member set declaration, for each loop etc)· Ability to resolve complex errors is required· Usage of embedded data actions and multi-actions (automate processes)SAC Predictive· Creation of SMART predict scenarios and models· Automation of the scenarios to run· Integrating them into multi-actionsInput templates· Ability to create templates in analytics application and designer using subset of JavaScript is advantageous· Creation of input templates using stories and the functionalities of a story· Support and resolve any technical issues users experience on inputting dataSAC Security· Ability to create security for users within SAC using data access control set on public dimensions· Familiar with creation and maintenance of teams/users and roles· Model privacy is advantageousBW Eclipse/bex queries (advantageous)· Creation of queries based on composite providers in BW· Maintenance and testing of queries· Creation of structures and filters to meet the custom hierarchies created in SAC· Ability to reconcile the development of the queries to the SAC dataFinance Knowledge & Experience· Some financial background and experience required, preferably in the banking sector.Output and measures *Output group 2*Change and GovernanceOutputs and measures *Perform change in accordance with Group IT Governance and policiesPerform System Functionality Configuration/Customization/CodingSolution Design for new functionalityAnalyse Epics, Features and based on business requirementDocumentation of Functional Specifications for Development work and assisting with Functional understanding for the scope of Development work.Provide high level consulting and expertise to provide direction and leadership on projects and changesEnsure integration with upstream and downstream systems/processesOptimise the environments in support of the ‘Always On’ and ‘Resilience’ IT strategyOutput group 3*Adhere to Agile Methodologies and Follow Agile PrinciplesOutputs and measures *Develop stories in conjunction with businessDetermine Effort estimation of stories to be developedContinuously finding ways to improve own and teams’ deliveryAssisting with Feature identificationWorks in partnership with Product OwnerCollaboration with Business and IT representatives (Daily stand-ups, Workshops, Meetings and other Agile Ceremonies etc.)Output group 4Testing of Configuration and Development Work for Enhancements or ProjectsOutputs and measuresTesting of Code and Config for Dev work in all cycles:Unit Testing – Dev System, Testing config and dev changes.Facilitate User Acceptance (UAT) and Integration (SIT) Testing on the Quality Assurance System.Testing of full functionality, regression testing after the changes have been implemented, assisting with User Acceptance Testing and Integration Testing into other modules.Create test cases and test sets on HP Quality Centre (QC) and ensuring test sets are run successfully to support testing documentation.Output group 5Risks Analysis for All Changes and to Follow Release MethodologyOutputs and measuresEnsuring changes are implemented successfully in accordance with change governance.Perform validations once changes are deployed to Production.Communication of changes deployed to the finance user base.Output group 6Administration and DocumentationOutputs and measuresDocumentation to be completed for changes: Change Impact Analysis (CIA), Gap Analysis, Enterprise Architecture (EA) Technical/Functional Process mappingOutput group 7To Continuously Improve Skills and CapabilitiesOutputs and measuresTo enhance knowledge and skills:- Attending Office 365 App training and Alteryx training (including inhouse) where applicableQualificationsFormal minimum qualification 1Type of qualification: Diploma/DegreeField of study: BSc Computer Sciences/ Finance and AccountingOther qualifications, certifications or professional membershipsBW Certification (advantageous)SAP Analytical Cloud Certification
