1
Terms of Reference─Senior BI Developer
Title: |
Senior Data Analyst- BI Developer |
||||
Category: |
Contract Staff |
|
|
||
1. 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 Power BI software.
|
|
|||
2. 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-to-large 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 ADB’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 ITD 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
|
|
|||
3. CORE COMPETENCIES: |
|||||
Technical Knowledge and Skills - Able to help and advise 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 systems
Client Orientation - Works to meet the needs of clients according to ADB policy - Communicates often with clients and seeks to understand and anticipate their needs - Works with clients to find ways to meet changing needs
Achieving Results - 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
Working Together - Works with other members of the team as needed to complete assigned work
Learning and Knowledge Sharing - Learns new skills and knowledge and applies them - Continuously finds new solutions to problems - Shares knowledge and expertise with the team
|
|||||
4. Education Requirements: |
|||||
|
Bachelor's degree in Computer/Software Engineering, MIS, Computer Science, or related areas.
|
|
5. 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.
|
|
INTERNAL. This information is accessible to ADB Management and staff. It may be shared outside ADB with appropriate permission.