BI Developer

Posted 6 months ago

Scope of Work

  • Create and maintain the logical design model of data used by the PBB RoA MI team
  • Monitor changes (proposed, actual) to the data elements – or the relationship(s) between those elements – used by the PBB RoA MI team
  • Serve as liaison between PBB RoA Information Management and Customer Insight and other stakeholders in the organisation (including IT Production, IT, Architecture and other system owners)
  • Design, develop and deploy data marts based on MI requirements
  • Review & optimise SQL scripts
  • Extract datasets from data sources such as ODS, GBM, MOD, OGG and other data sources used to extract data from, e.g. peripheral systems
  • Ensure effective use of the MDM and reference data on all MI dashboards
  • From the Bank’s Master Data store (such as OGG, MOD, ODS, CDI and the proposed Africa Data Warehouse), create and maintain a PBB RoA DataMart that meets the needs of the business units in PBB RoA
  • Liaise with IT Data Services on all technical database related issues such as deployment of scripts, tables, views and data processing packages (such as SSIS)

Technologies to be used

  • SQL Suite of Products
  • Qlickview
  • Oracle
  • Cognos
  • SAS

Job Features

Job CategoryBusiness Intelligence

Apply Online

A valid phone number is required.
A valid email address is required.