Senior Analyst MI and BI in Johannesburg

Market related
18 Sep 2018
18 Oct 2018

Senior Analyst MI and BI

(Job Number: 90203477)


Overall Job Purpose

To provide core support to the business through the development and maintenance of accurate business intelligence and management information through analysis of available information and information sourcing (structure and/or unstructured). To provide valuable insights for strategic business decision making through accurate information as well day-today operational reporting within the BU.

Key Accountabilities:

Accountability: Current Reporting (MI)

  • Convert data extracts from SQL server, EDW, and disparate data sources into relevant information with relevant reporting tools
  • Deliver relevant Management Information (MI) reports and Business Dashboards across Absa COO to enable decision making
  • Use the standard reporting framework as prescribed by Absa COO to fulfil requests, and to ensure proper change control
  • Identify new sources of data via requirements gathering and investigation
  • Maintain all existing reports by ensuring relevance for decision making and sound data governance practice
  • Engage with teams members both daily and through standard team meetings
  • Assist team managers through formal and informal meetings to be fully involved in the development process and delivery of MI reporting solutions
  • Take part in pre-defined forums and committees within the Absa information environment in order to stay abreast with latest developments
  • Lead internal meetings and forums where information is to be presented to stakeholders
  • Adhere to the core Data Governance disciplines as defined by the DGO (Absa Data Governance Organisation) when performing business intelligence activities
  • Conduct integrity checks regularly both when developing new reports and executing existing scripts
  • Escalate issues identified to the MI Manager and Data Steward and work with them to improve data quality and definitions
  • Manage workload according to created plans 

Accountability: Provide value-add insight (BI)

  • Develop a thorough understanding of the key business challenges through engagement with all stakeholders in the business
  • Identify opportunities through which BI can assist in addressing these challenges, present these to relevant stakeholders and implement
  • Identify business opportunities in support of analysis of the business management information and management information that may reside outside the business
  • Analyse trends within the business data to optimise performance of the business
  • Self-study of BI products and suggestions to team leads on better presentation of data
  • Deeper understanding of reports available to enable storyline telling of reports and data
  • Develop a better business understanding and insight to enable feedback and recommendation to business

Accountability: Governance and control

  • Conduct integrity checks on all extracted data to ensure correct data is incorporated into reports
  • Ensure the accuracy of data within the business and ensure consistent use of data
  • Escalate data integrity issues to relevant Manager and ensure that these receive priority to maintain a high level of data integrity
  • Check all existing and new reports for accuracy and data integrity
  • Ensure that all processes are accurately and continuously documented for business continuity purposes

Accountability: Business partnering

  • Check all existing and new reports for accuracy and data integrity
  • Manage the management information service  and business intelligence offering within the business through communicating clearly on this role
  • Engage with the business teams on an on-going basis to understand management information and business intelligence needs and sensitise them to any relevant existing reports or management information outputs that will result in value add opportunities in their respective areas
  • Conduct impact analysis of any proposed changes that will impact on management information reporting
  • Actively engage and participate in new initiatives within the business to ensure that the management information component is addressed
  • Engage with internal customers to manage their expectations and deliverables
  • Engage with other management information key stakeholders within the Group to ensure that the business leverages off what is available and are aware of initiatives in the group that may impact on the business

Accountability: Continuous self-development and growth

  • Stay abreast of knowledge and skills relevant to the level and area of work, as well as actively seeking to attain those required for the next level of work with particular focus on best practices
  • Continuously enhance the business expertise by analysing its drivers, key indicators, relationships and trends
  • Consider all influencing events, quantify the impact on the business and pro-actively find solutions
  • Develop knowledge of various systems and related reporting throughout

Education and Experience Required:

  • NQF Level 6: (Bachelor degree - BSc Information Technology) or similar
  • Three (3) years’ experience in the use of database reporting tools and techniques
  • Three (3) years’ experience with the use of tools such as but not limited to SAS, SQL, VBA, SAP Business Explorer, HTML, Macros and ASP (Active Server Pages / Web Portal Development)
  • Three (3) years’ experience in requirements gathering and documentation
  • Knowledge and exposure to data warehouse design and business intelligence applications and information products
  • An understanding of change management and its importance in business process transformation
  • Proficient in MS Office (Word, Excel, PowerPoint and Outlook) and the Internet
  • Experience in BI and MI toolsets
  • Preference will be given to South African Citizens and Permanent residents of South Africa in possession of proof of permanent resident status

Knowledge & Skills:

  • Communication skills
  • Ability to work under pressure
  • Attention to detail
  • Knowledge of data manipulation
  • Statistical skills
  • Presentation skills
  • Report writing
  • Analytical skills and problem solving
  • Planning and organising
  • SQL scripting Knowledge 
  • SAP Business Explorer knowledge
  • SQL Server Reporting Services knowledge (SSRS)
  • SQL Server Analysis knowledge (SSAS)
  • SAS (Base and E-Guide) knowledge
  • QlikView 10.0 and later knowledge
  • VBA knowledge
  • Microsoft office Knowledge (Excel, PowerPoint, word)


  • Deciding and initiating action
  • Relating and Networking
  • Writing and Reporting
  • Presenting and communicating information
  • Applying expertise and technology Analysing
  • Working with people
  • Relating and networking
  • Presenting and communicating information

  • Applying expertise and technology Analysing

  • Delivering results and meeting customer expectations

  • Adapting and responding to change  


The appointment will be made in line with the Divisional Employment Equity strategy