Консультант/-ка з розробки управління інформацією та базою даних (оцінка аналізу та звітності) / Database and Information Management Developer (Consultant) до Міжнародної організації з міграції (МОМ)

Annex 2 – TERMS OF REFERENCE

FOR THE CONSULTANCY CONTRACT OF: Database and Information Management Developer (Consultant)

1. Duty Station of the Consultancy: Kyiv, Ukraine
2. Duration of Consultancy: 6 months, with possibility of extension subject to availability of funds and satisfactory job performance.
3. Nature of the consultancy: Category A Consultancy

Under the overall supervision the Chief of Mission and the Programme Manager (DTM), withthe direct supervision of the Database and Web Development Officer, the Consultant will support the Information Management team with data cleaning processes, quality control, and database development.

1. Project Context and Scope:

Over nine years after the onset of the crisis in eastern Ukraine and following the Russian invasion in February 2022, the country has been embroiled in a full-scale war. The consequences of violence have spread across the entire territory of Ukraine, and over 5 million people are estimated to have been internally displaced. This situation is likely to become protracted as fighting continues and new waves of displacement are expected. In support of the ongoing and future humanitarian response, IOM implements large-scale assessments across the country and reporting of displacement and mobility trends, urgent needs, as well as needs related to recovery and durable solutions to displacement.

1. Organizational Department / Unit to which the Consultant is contributing:

Response, Resilience and Recovery, Data and Analytics Unit.

1. Category A Consultants: Tasks to be performed under this contract
2. Assist in data cleaning and normalization processes to ensure accuracy and reliability of data.
3. Develop, test and upload Kobo forms in line with Data and Analytics Unit
4. Manage data storage and implement data management systems to ensure data integrity.
5. Perform SQL queries for data extraction, analysis, and reporting.
6. Utilize knowledge of databases and dashboards, such as PowerBI, to create visual representations of data and facilitate understanding.
7. Assist in the development and implementation of website development.
8. Support the team in data analysis, cross-checking datasets, translation automation and report reviews.
9. Work closely with the Information Management team to ensure adherence to data privacy policies and procedures.
10. Verify that all data collection is in line with IOM’s Data Protection Principles.
11. Perform such other duties as they might be assigned.
12. Performance indicators for the evaluation of results
    1. Kobo forms: Successful deployment of Kobo forms to the main IOM Kobo service and ensure that data collection is happening smoothly as well as collecting feedback from users and fix any errors or labels on monthly basis.
    2. Excel support: Successful maintenance and creation of Excel templates as well as data cleaning and data formatting inline with DTM and IM guidelines for analysis and public datasets.
    3. Database support: Successful migration of tables from excel and/or kobo api to database inline with IM guidelines and instructions for each round of assessment on monthly basis.
    4. Dashboards maintenance: Successful deployment and maintenance of dashboards as well as automatic refresh and updating datasets and usage of Kobo API.
13. Education, Experience and/or skills required

Education:

• University degree in Computer or Data Sciences, Statistics, Information and Technology, Geography/Geographic Information System, Communications, or a related field from an accredited academic institution with two years of relevant professional experience.

Experience:

• Experience in using the following programming languages and frameworks: SQL, C#, Asp.net MVC, Python,and GIT.
• Experience writing python scripts or R scripts to produce charts or data insights.
• Experience working with HTML, CSS, and building web apps and websites.
• Experience with using PowerBI.
• Experience in managing data entry and maintenance.

Technical skills:

• Knowledge of database development, Python and user interface web applications.
• Knowledge of API, and understanding of web requests and the ability to work with GET and POST methods.
• Excellent verbal and written communication skills.

1. Travel required

Yes,  travel is required to support the project activities.

1. Competencies

Values

• Inclusion and respect for diversity: respects and promotes individual and cultural differences; encourages diversity and inclusion wherever possible.
• Integrity and transparency: maintains high ethical standards and acts in a manner consistent with organizational principles/rules and standards of conduct.
• Professionalism: demonstrates ability to work in a composed, competent and committed manner and exercises careful judgment in meeting day-to-day challenges.

Core Competencies – behavioural indicators

• Teamwork: develops and promotes effective collaboration within and across units to achieve shared goals and optimize results.
• Delivering results: produces and delivers quality results in a service-oriented and timely manner; is action-oriented and committed to achieving agreed outcomes.
• Managing and sharing knowledge: continuously seeks to learn, share knowledge and innovate.
• Accountability: takes ownership for achieving the Organization’s priorities and assumes responsibility for own action and delegated work.
• Communication: encourages and contributes to clear and open communication; explains complex matters in an informative, inspiring and motivational way.

1. How to apply: 

Interested candidates are invited to submit their Personal History Form and cover letters or CVs with names and contacts of three referees by 22 April, 2024 at the latest. 

Only shortlisted candidates will be contacted.

!!! Private entrepreneurs (PE) cannot be considered as applicable for providing services under this consultancy.

 Posting period:

From 08.04.2024 to 22.04.2024

2024-04-08T17:00:58.000 2024-04-22T23:59:59.000 Full time / Повна зайнятість TELECOMMUTE Ukraine Міжнародна організація з міграції / МОМ