Relevant Experience and Other Requirements :
At least 5 years' experience in modeling data, ETL analysis and design, including comprehensive experience in SQL programming.
Proficiency in SQL programming, Oracle RDBMS, creating data models using Cognos Framework Manager, creating ETL scripts and jobs using Cognos Data Manager or similar BI tool;
creating reports and analytics using Cognos Report / Analysis / Query / Metric Studios or similar BI tool.
Proficiency in SQL performance analysis and tuning.
Excellent oral and written communications skills.
Excellent ability in systems analysis and design, and in the preparation of functional and detailed specifications documents.
Extensive knowledge in analysis, design, development and implementation of BI systems using standards- and best practices-
based methodologies and frameworks and in the use of associated productivity tools.
Good interpersonal, communication and writing skills, and ability to promote team work.
Job purpose :
To identify business intelligence, reporting and data analysis needs of the client. To design, develop, implement and ensure proper maintenance of medium-
to-large scale Business Intelligence (BI) applications built using Cognos Business Intelligence software.
Expected outcomes :
Ensures that the assigned data models and / or components (data mart and data stores / warehouse and Bi application) are designed to meet customer needs.
Provides data that is accurate, reliable, and ensures that the information is easily available to the client for direct consumption, or integration with other systems.
Ensures that the system is accurately coded and tested in accordance with requirements and design documents; and fully documented in accordance with ADBâ
153;s standards and methods. Provides documentation that is clear and easy to understand.
Trains clients in using the corporate reports. And educates them on how to use the data available to display information in different forms for the purposes of their own analysis.
Works with staff, consultants and outsourcing contractors who may be involved in the development / maintenance of assigned application systems.
Works with OIST technical support staff to ensure assigned systems are properly operated and maintained.
Regularly submits reports on progress status including problems encountered and resource requirements of assigned application systems