Standard Bank is the largest bank in Africa and our highly visible brand, award-winning service, and strong global presence helps us maintain our market-
leading position. We place huge value on the talent of our people to drive our continued success, and to support our plans for growth.
We now need a talented and resourceful Analyst, MIS to help us fulfil our business objectives and build customer loyalty.
To provide mono-functional area scripting, extracted from single source systems, with multiple output dimensions (single product / segment with variable changes for example number of customers).
Key Responsibilities / Accountabilities
Data extraction :
Receives the measurement and MIS functional area specific requirements from the Manager, Measurement and MIS.
Understands the functional area data requirements and system infrastructure.
Pulls the data from the relevant data source / s (e.g., enterprise information warehouse (EIW)) using Qlikview / Teradata / MS SQL or any of the existing extraction tools
Liaisons with the Manager, Systems and Processes to :
advise if any problems are incurred during the extraction of data from the source systems.
Translates data in a way that meets functional area specifications.
Data validation :
Performs data validation to ensure that data is correct and meets functional area data specifications.
Provides trend analytics pro-actively, and on stakeholder request.
Creates structured reporting (as per governance standards) and transforms the reports onto an efficient business intelligence (BI) tool.
Builds reports according to specification using tools, such as Qlikview.
Migrates functional area MIS to an optimal end-state reporting function.
Populates performance scorecards per functional area.
Produces daily, weekly, monthly and ad-hoc reporting.
Creates formal specifications and documentation for the end-user products and acts as the user Interfaces with the Data Warehouse, for enterprise-wide reports and dashboards
Participates in the meta-data maintenance for the data warehouse and dimensional model especially from the end-users’ perspective.
Participates in the design, development and implementation of the data warehouse.
Provides continuous improvement opportunities.
Provides recommendations on functional system specifications.
Preferred Qualification and Experience
3 year Degree in information management, statistics and / or mathematics disciplines.
3 years’ experience in data gathering, storage, extraction and manipulation.
1 years’ experience in the banking / financial industry.
Experience in business operations or management.
Experience and understanding of data systems used within the bank.
Knowledge / Technical Skills / Expertise
Computer literacy (i.e. Qlikview / Teradata / MS SQL).
Statistical and data report scripting and writing skills.