BI Systems Developer (Warehouse & Cognos)

Company

Datafin

Date

06 Feb 2018

Reference Number

2187349

Salary

Market Related Basic Salary

Description

ENVIRONMENT:

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.

DUTIES:

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

Region:

Cape Town
Western Cape
South Africa