BI Systems Developer (Warehouse & Cognos)
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