BI Systems Developer (Warehouse & Cognos)




06 Feb 2018

Reference Number



Market Related Basic Salary



A leading supplier of speciality chemicals and gas seeks the expertise of a highly skilled BI Systems Developer (Warehouse & Cognos) to join its team. You core role involves ensuring the effective operation and production of accurate and reliable data by supporting and maintaining the group's BI Framework which consists of: a data warehouse in SQL, Cognos Analytics and Cognos TM1. You will also train users to use the system and answer user support questions. The ideal candidate must possess a relevant tertiary qualification, work experience in a similar role and Must-Have skillset including: T-SQL, Report Writing, Data Warehousing while desired skills include: SSIS, Cognos Analytics Development, Cognos Framework Manager, ERP Systems.


Reporting to the Group BI Manager you will be responsible for:

Maintain the Data Warehouse -

  • Monitor SQL ETL Jobs for efficiency and failures.
  • Respond to failures immediately.
  • Regularly test data integrity.

Maintain the Cognos Analytics site -

  • Amend or correct Cognos reports based on own review and user requests.
  • Monitor report delivery jobs and correct errors as soon as possible.

Develop the Data Warehouse (ETL) -

  • Add new data marts when required.
  • Update existing data marts and ETL jobs based on Group requirements.
  • Maintain metadata / data mappings in Cognos Framework Manager.

Develop Reports in Cognos Analytics -

  • Create new reports bas

Contract Type:

Permanent, Permanent/Contract


Cape Town
Western Cape
South Africa