Reporting Specialist Data Presentation at Absa Group Limited (Absa)

Job Summary

Work as part of an integrated (run & build) tribe in lower complexity environments to provide enterprise wide application support across multiple stakeholder groups by maintaining & optimizing enterprise-grade applications (tech products & services).
Job Description

Role Requirements:

• Azure or AWS certified
• SQL (snr level) including SSIS and SSRS
• Extensive experience with ETL design and execution
• Experience with Flexera stack
• Experience with PowerBi, Qlikview or Tableau reporting
• Experience with the analysis of customer needs for the design of reports
• Database Architecture
• Databases on Cloud (AWS & AZURE)
• Supporting SQL in multiple domains
• SQL on VM Infrastructure
• Database Performance Monitoring and Tuning
• Ensure Database Availability at all times
• Database Security and Audit
• Database Backup and Recovery with Data team
• Capacity Management
• Maintain Data Integrity
• Migration
• Troubleshoot of incidents and permanent fixes
• Monitor and analyses performance issues.
• Ensure compliance with operational / change management guidelines
• High Availability and Disaster recovery

1. Apply critical thinking, design thinking and problem solving skills to solve technical problems related to the management and presentation of large datasets.
2. Provide efficient and effective support of SQL, PowerBi applications including continued development of the application and security, software patches, reliability, disaster recovery and ensure the application meets the business needs
3. Schedule and oversee planned maintenance tasks, such as backups and performance tuning, for production IT services to prevent and to minimize issues
4. Maintain correct and current application documentation and making it available to application users
5. Oversee application implementation and configuration, patches, upgrades and maintenance, and ensure that application performance meets agreed SLAs and OLAs
6. Ensure minimal business operations impact due to upgrades and maintenance activities
7. Coordinate and execute unplanned maintenance tasks, such as disaster recovery procedures, for production IT services to prevent and to minimize issues
8. Manage applications throughout their lifecycle and assist in the application-related aspects of designing, testing, operating and improving technology products & services services
9. Coordinate & communicate across Tribes & Squads (all businesses) to successfully complete application upgrades
10. Coordinate with infrastructure & architecture teams to ensure that the impact of system / platform migrations on applications is minimised
11. Develop and maintain knowledge in application functionality, user workflow, and business processes
12. Develop sufficient knowledge of application infrastructure (server, network, security) & broader organization architecture to assist with application upgrades and troubleshoot issues
13. Compile and maintain inventory of applications and related details
14. Manage and provide support aligned to all SLA’s
15. Develop the skills required to operate and maintain the technical products & services (applications)
16. Ensure that a backup system for applications and files associated with business operations is in place
17. Advise on software installation and upgrades, troubleshoot problems and provide resolutions.
18. Work with Information Security teams to define and implement access permissions for applications
19. Develop and maintain expertise in application functionality, user workflow, and business processes.
20. Receive and screen user programming requests for new applications or modifications, and determine appropriate priority and response.
21. Develop and communicate training and documentation for end users.
22. Act as a liaison between business stakeholders and customers, external solution providers, and IT stakeholders for application support specific requirements
23. Develop and / or assist with the development and / or execution of project plans for application upgrades
24. Provide input to current and future application requirements to meet the organization's needs
25. Prepare assessments for proposed applications, projects, and define appropriate integration and access requirements
26. Maintain awareness of application risks and opportunities for improvement
27. Identify and recommend application improvement to enhance capability and performance, and minimize costs.
28. Ensure that application users are aware of the application capabilities for enabling their effective use
29. Assess vendor proposals for appropriateness and compliance with organization and industry standards.
30. Participate in development of Requests for Proposals (RFP) and vendor evaluation and contract management for IT applications services.
31. Supervise and maintain the organization's repository of applications
32. Help diagnose problems and resolve incidents / issues related to applications.
33. Validate the known error database for application-related entries
34. Work with Tech Centres of Enablement to define the operational activities related to the applications
35. Application Monitoring & Performance Management
36. Monitor application modification requests and ensure best practices are being utilised
37. Conduct diagnostic investigations of program errors, and implement or recommend solutions or methodologies for resolution.
38. Maintain metrics of operational performance and evaluate trends
39. Analyse business systems to determine effectiveness, identify inadequacies, inefficiencies and problems and recommend solutions
40. Governance, Risk & Control
41. Enhance methods and procedures for collecting, analysing, and documenting application issues, and completing user change requests.
42. Enhance IT processes for transitioning completed configurations from development to production.
43. Plan and coordinate the processes for the provision of user applications and systems necessary for business operations.
44. Define and maintain application assessment, development, and support standards, and work with other IT and business stakeholders to establish configuration and use guidelines.
45. Provide inputs to availability and capacity management process for effective planning.

Education

• Bachelor's Degree: Information Technology

Deadline: 22nd, February 2022