BUSINESS INTELLIGENCE (BI) DEVELOPER

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

Works as an individual or as part of a team in identifying business intelligence, reporting and data analysis (advanced analytics/statistical analysis) needs of the client. Designs data models for medium-tolarge applications in full or in part as assigned. Takes charge in the preparation of the data model and ETL requirements and design. Develops corporate and adhoc reports.

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 the company'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 purpose 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.

CORE COMPETENCIES

Technical Knowledge and Skills

• Able to help and advice others based on their specialist area of knowledge and skill
• Uses technical knowledge and skills to complete complex work
• Uses technical knowledge and skills to improve work system
• Works to meet the needs of clients according to company’s policy
• Communicates often with clients and seeks to understand and anticipate their needs
• Works with clients to find ways to meet changing needs
• Finds ways to reduce time and cost of completing work
• Works with others to overcome problems and find alternative ways to complete work when necessary
• Works with other members of the team as needed to complete assigned work
• Learns new skills and knowledge and applies them
• Continuously finds new solutions to problems
• Shares knowledge and expertise with the team
• Shares knowledge and expertise with the team

EDUCATION REQUIREMENTS

Bachelor's degree in Computer/Software Engineering, MIS, Computer Science, or related areas.

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.