Business Intelligence Specialist (Power BI) at Absa

Job Summary

Absa Corporate and Investment Bank (CIB), is a leading South African Investment Bank with global reach, offering clients financing, risk management and advisory solutions in a wide range of currencies and structures.

• Our distinctive business model is fit for purpose and allows the firm to provide clients with solutions to match their financing and risk management needs. This ability is supported by a dedicated infrastructure unit, including (but not limited to) Legal, Compliance, Human Resources, Marketing and Corporate Communications, IT, Risk, etc. which in turn supports the firm’s vision of becoming the leading Investment Bank across Africa.

Job Description

Overall job purpose:

• To perform the role as Business Intelligence (BI) Specialist for Absa Corporate and Investment Bank (CIB). The role will be responsible for participating and contributing to defining and/or enhancing existing and new business intelligence requirements and overseeing Business Intelligence implementations in Absa Capital.

Key accountabilities:

• Consultation
• Provide BI consultation to both Business and IT in CIB (including Run the Bank)
• Provide input on various BI methodologies to satisfy BI requirements
• Drafting of BI requirements
• Support and enhancement to existing BI developed solutions
• Requirements gathering
• Use a structured approach to gather and understand BI requirements
• Validation of BI requirements to ensure understanding between IT and business
• Clear and structured documentation to aid BI solution development and evaluation

Data Analysis

• Analysis of existing systems data stores and data feeds
• Identification of missing data and validations
• Provide input to standardised data models and data dictionary to reflect current and future data requirements

Documentation

• Clear, standardised documents that describes the BI requirement
• Clear, standardised documents that describes the BI solution
• Concise input to standardised data models and data dictionary
• Concise contributions to the central BI knowledge base

BI Solution Development

• Create dashboards and interactive visual reports using Power BI
• Identify key performance indicators (KPIs) with clear objectives and consistently monitor those
• Analyzing data and present data through reports that aid decision-making
• Convert business requirements into technical specifications and decide timeline to accomplish
• Create relationships between data and develop tabular and other multidimensional data models
• Chart creation and data documentation explaining algorithms, parameters, models, and relations
• Design, develop, test, and deploy Power BI scripts and perform detailed analytics
• Perform DAX queries and functions in Power BI
• Responsible for handling the entire BI system and focuses on leveraging Power BI for smart, real-time decisions.

People

• Ability to build relationships across multiple levels and user groups
• Ability to manage conflict to reach objectives of business
• Experienced in acting as a bridge between technical and non-technical people to ensure common understanding and buy-in.

Knowledge and skills

• Ability to identify, solicit and accurately document relevant Business Intelligence requirements
• Good technical Business Intelligence skills (reporting and ETL)
• Sound and diligence approach to BI development and testing
• Good communication skills (verbal and written)
• Able to facilitate conversations and resolve differences between stakeholders (Problem Solving).

Data analysis skills

• QlikView and QlikSense skills
• Education and experience required
• University degree or equivalent
• University or post graduate degree in analytical subjects (mathematics, physics, engineering or IT), e.g.  B.Sc Mathematics, Act.Sci, Statistics / FRM or PRMIA qualification
• Proven technical skills
• Min 5+ years relevant experience in Power BI
• Min 5+ years’ experience as a Business Intelligence Analyst

Advantageous

• Working experience and knowledge of Business Intelligence toolsets
• Working understanding of Business Intelligence methodologies
• Working knowledge of Power BI Understanding of technical aspects of BI software implementations
• Working knowledge of SQL
• Business knowledge in the Risk and Finance domain

Education

• Bachelor's Degree: Information Technology

Absa Bank Limited is an equal opportunity, affirmative action employer. In compliance with the Employment Equity Act 55 of 1998, preference will be given to suitable candidates from designated groups whose appointments will contribute towards achievement of equitable demographic representation of our workforce profile and add to the diversity of the Bank.

Absa Bank Limited reserves the right not to make an appointment to the post as advertised