development
Position grade: Consultant
Duty station: Kigali, Rwanda with field visits
Duration of Assignment: 15 Working days
Seniority band: III
Job family: Emergency and Post-Crisis
Organizational unit: Programme
Position number: 2013/017
Reporting directly to: Project Officer
Overall supervision by: Chief of Mission
In close collaboration with the Rwanda Ministry of Disaster Management and
Refugee Affairs (MIDIMAR) and other relevant stakeholders, IOM has been
implementing three phases of a comprehensive programme aimed at enhancing
socio-economic reintegration opportunities of up to 8,000 returnee households
and other vulnerable groups in Rwanda. The Project “Enhancing Socio-Economic
Reintegration Opportunities for Rwandan Returnees and Other Vulnerable Groups
through Market-Oriented Skills Training (MOST), including Community Development
Support, 2013” is funded by the Government of Japan.
strengthening government capacity to ensure sustainable reintegration;
assess the market opportunities and provide skills trainings and other income
generating opportunities to sustain decent livelihoods,
assistance and
project will directly benefit up to 5,000 returnee households and other
vulnerable groups across 10 priority districts of Rwanda.
to 10 additional districts. An essential component of the programme is to
conduct a labour market needs assessment aiming at providing key information on
employment opportunities, priorities, alternative potentials, challenges and
constraints for returnees in the target districts, thereby providing a basis
for the socio-economic reintegration programming. Thus, the supply and demand
for labour and skills relevant in the target districts should form the core of
the market survey. In addition, IOM will conduct skills training capacity
assessment which should include the aspect of mapping existing vocational and
skills training institutions and other facilities in each district to qualify
returnees and other community members to meet market demands.
systematically captured by MIDIMAR; IOM will conduct the mapping of communities
with high number of returnees in each district and register all returnees in
order to capture and assess their education, skills and priorities. The mapping
and profiling of returnees should help to provide a descriptive profiles of
returnees in the target districts and help IOM and key government implementing
partners to understand the profile of returnees, identify the intentions and
priorities of returnees as well as provide a baseline for subsequent designing,
monitoring and evaluation activities.
specific database (MS Access) for the project beneficiaries, including all data
collected from the field on labour market. To achieve this, it is paramount to
develop a comprehensive database on Returnees and target beneficiaries and
incorporated into the operational process to facilitate the project
implementation across the target districts and IOM Head Office. The information
stored in the Database will serve as a useful tool for IOM, as well as MIDIMAR
to assess (baseline) and monitor the reintegration programme activities and the
beneficiaries. IOM will ensure that this information will be stored and shared
with full respect to privacy and confidentiality.
consultant will develop a fully functional, user friendly and compatible
database for the reintegration purpose. While it is the responsibility of the
consultant to adopt the most appropriate approach to the work, the following
proposal aims at securing a minimum guidance for a relevant database. It is
expected that the consultant uses an inclusive, comprehensive, and
participatory methodology which includes the state-of-the-art on this matter
(key tools). Information gathering and analysis should be approved by the IOM
project Team. The goal of the consultancy is to develop a customised MS Access
database, as per the specifications.
guide the recruitment of the consultant for the development of the database for
the reintegration of returnees and other target groups.
Working under the overall supervision of the Chief of Mission, and direct
supervision of the Project Officer, the Consultant will carry out the
following assignments:
1. Attend a briefing session with the IOM project Management team and other
role players to obtain a detailed specification of what needs to be developed.
2. Expand on the current draft database specification (see Attachment 1) to
develop a final set of database specifications that is to the satisfaction of
IOM.
3. Develop a front-end database in MS Access (not SQL, Visual Basic or
any other computer language), based on the technical database specifications.
4. Ensure that all aspects of the process are captured so the database can be
used for documents and administrative purposes for all beneficiaries
5. Develop the appropriate reports to report on all indicators on a monthly,
quarterly and annual basis, and that can be used to track any gaps
6. Pilot the database by running a full day demonstration to ascertain whether
the database fulfils all of the requirements of the project team and IOM
Office.
7. Assist project management team to upload all historical data into the
database through importing existing MS Word and Excel data, instead of
re-capturing data.
8. Upload the database onto the designated computers at IOM office.
9. Propose reporting formats to ensure that they fulfill the needs of the
project team.
10. Write an instruction manual that provides detailed technical specifications
and front-end user specifications to enable them to make the necessary changes.
11. Provide training sessions for the data clerk in data capturing the data
from the field and in how to modify standard reports by developing new queries
and new reports.
12. Provide any further technical support assistance to the project team after
the database has been installed on a need-be basis, making the necessary
modifications to the database and uploading a new version of the database onto
all computers.
13. Assess the database of IOM, including the datasheet from IOM’s database on
returnee registration which provide the layout of the required data entry
related to returnees (i.e. personal data, Educational background, training
needs, any other assistance needed, etc.), to develop detailed profiles of
different groups, etc.);
14. Assess IOM capacity for database administration/maintenance, including
regular content uploading functionality and features and come up with a
training package.
15. Carry out a “on- the –job- training” on database maintenance to enable the
concerned staff to update the database both in terms of content and
functionality.
16. Once the database is running satisfactorily, provide the Project Team with
a full set of documentation for easily maintenance and content regularly
update.
17. Provide technical support service and advice for database maintenance, as
required.
be agreed upon with the project Manager):
1. Inception report demonstrating a clear understanding of IOM’s
activities related to reintegration of returnees’ database and how the mission
will be carried out (i.e. outline database design, options; etc.) for the
database development – by 1 week
2. A summary assessment report on the capacity of IOM’s key staff to maintain,
to repair and to up to date the database, including training needs by 2nd week;
3. A progress report on Tasks completed by 4th week from the start of the
contract;
4. Full set of documentation and training package to the IOM project Team in
the use of and up to dating of the database, and its linkage to the website of
MINAFFET;
5. A final report on completion of the deliverables in these Terms of
Reference.
The incumbent is expected to demonstrate the following technical and
behavioural competencies:
Behavioural
– Accepts and gives constructive criticism
– Follows all relevant procedures, processes, and policies
– Meets deadline, cost, and quality requirements for outputs
– Monitors own work to correct errors
– Takes responsibility for meeting commitments and for any shortcomings
Client Orientation
– Identifies the immediate and peripheral clients of own work
– Establishes and maintains effective working relationships with clients
– Identifies and monitors changes in the needs of clients, including
donors, governments, and project beneficiaries
– Keeps clients informed of developments and setbacks
– Contributes to colleagues´ learning
– Demonstrates interest in improving relevant skills
– Demonstrates interest in acquiring skills relevant to other functional
areas
– Keeps abreast of developments in own professional area
– Actively shares relevant information
– Clearly communicates, and listens to feedback on, changing priorities
and procedures
– Writes clearly and effectively, adapting wording and style to the
intended audience
– Listens effectively and communicates clearly, adapting delivery to the
audience
– Actively seeks new ways of improving programmes or services
– Expands responsibilities while maintaining existing ones
– Persuades others to consider new ideas
– Proactively develops new ways to resolve problems
– Convinces others to share resources
– Actively identifies opportunities for and promotes organizational
change
– Presents goals as shared interests
– Articulates vision to motivate colleagues and follows through with
commitments
– Provides constructive feedback to colleagues
– Identifies ways for their staff to develop their abilities and careers
– Provides fair, accurate, timely, and constructive staff evaluations
– Uses staff evaluations appropriately in recruitment and other relevant
HR procedures
– Holds directly reporting managers accountable for providing fair,
accurate, timely, and constructive staff evaluations
– Sets clear and achievable goals consistent with agreed priorities for
self and others
– Identifies priority activities and assignments for self and others
– Organizes and documents work to allow for planned and unplanned
handovers
– Identifies risks and makes contingency plans
– Adjusts priorities and plans to achieve goals
– Allocates appropriate times and resources for own work and that of team
members
– Masters subject matter related to responsibilities
– Identifies issues, opportunities, and risks central to responsibilities
– Incorporates gender-related needs, perspectives, and concerns, and
promotes equal gender participation
– Persistent, calm, and polite in the face of challenges and stress
– Treats all colleagues with respect and dignity
– Works effectively with people from different cultures by adapting to
relevant cultural contexts
– Knowledgeable about and promotes IOM core mandate and migration
solutions
– Actively contributes to an effective, collegial, and agreeable team
environment
– Contributes to, and follows team objectives
– Gives credit where credit is due
– Seeks input and feedback from others
– Delegates tasks and responsibilities as appropriate
– Actively supports and implements final group decisions
– Takes joint responsibility for team´s work
– Learns about developments in available technology
– Proactively identifies and advocates for cost-efficient technology
solutions
– Understands applicability and limitation of technology and seeks to
apply it to appropriate work
– Establishes realistic resource requirements to meet IOM needs
– Relevant experience of IT management, expertise in IT planning;
Excellent skills in web development and open source operating systems,
including open source software and databases.
– Excellent and proven ability to manage databases and create innovative
solutions for database management.
1. University Degree: BSc-Computer Science or related educational background,
with an MSc in Computer Science considered an advantage;
2. Relevant experience of IT management, expertise in IT planning;
3. Excellent skills in web development and open source operating systems,
including open source software and databases.
4. Excellent and proven ability to manage databases and create innovative
solutions for database management.
5. Knowledge of Database Design and Development using MS Access or others.
6. Knowledge of scripting languages: JavaScript, Vbscript, HTML, PHP.
7. Knowledge of Web Design Editors: Dreamweaver MX, Delphi for PHP, FrontPage
and other related editors.
8. Knowledge of Statistical Applications: SPSS.
9. Training experience.
Required
English: Very Fluent
Advantageous: FLUENT IN FRENCH AND KINYARWANDA
Online, sending CV and cover letter to: iomrwanda@iom.int
