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.
Submit your Resume
JOIN OUR REFERRAL PROGRAM
Subscribe to our referral program and get as much as Php 20,000 in referral fees! Once you subscribe to the e-mail list, we will be sending you news and updates on job offers and more.
