Database and Web Development Officer

Position Title: Database and Web Development Officer

Duty Station: Kyiv, Ukraine

Classification: Professional Staff, Grade P2

Type of Appointment: Special short-term graded, SIx months with possibility of extension

Estimated Start Date: As soon as possible

Closing Date: 12 September 2024

Established in 1951, IOM is a Related Organization of the United Nations, and as the leading UN agency in the field of migration, works closely with governmental, intergovernmental and non-governmental partners. IOM is dedicated to promoting humane and orderly migration for the benefit of all. It does so by providing services and advice to governments and migrants.

Context:

Under the overall supervision of the Chief of Mission (CoM), and the direct supervision of the Programme Manager (Data and Analytics), the Database and Web Development Officer will be responsible for contributing to the design, maintenance and optimisation of all database activities, web development and dashboards. This will support improved management, analysis and reporting of information collected through assessments across Ukraine.

Core Functions / Responsibilities:

1. Contribute to the design and maintain a flexible, secure database structure for all data collected by the programme, in accordance with Displacement Tracking Matrix (DTM) global database standards and data dictionary.
2. Supervise and guide extraction, transformation and loading from multiple data sources using Microsoft Azure, MS Fabrics and other data tools.
3. Support and coordinate the development of data analysis scripts (using R and/or Python) to produce end-to-end analysis, visualisation and reporting solutions.
4. Design, produce and update high-quality data visualisations and dashboard products that meet the requirements and information needs of IOM programme teams and partners.
5. Develop tables, views, functions, SQL queries and stored procedures to retrieve and manipulate information for reporting and analysis purposes.
6. Design and integrate web charts and visualizations using JavaScript (js) libraries, such asHighcharts/Highmaps and D3.js (Data-Driven Documents JavaScript).
7. Help ensure data security and consistency of dynamic or online products and applications.
8. Assist in developing and maintain comprehensive documentation on data and files classification, as well as data quality control mechanisms, in line with DTM global standards.
9. Undertake duty travel to support information management (IM) trainings of D&A staff and implementing partners, as well as field level data quality standards, as required.
10. Perform such other duties as may be assigned.

Required Qualifications and Experience:

Education

• Master’s degree in Information Management, Computer Science, Media or Social Sciences or a related field from an accredited academic institution with two years of relevant professional experience; or,
• University degree in the above fields with four years of relevant professional experience.

Experience

• Experience in humanitarian emergencies.
• Working experience with the following tools: Power Platform, MS Access, ASP.NET, HTML, CSS, JavaScript, MS SQL or Oracle (MCP certification in any of these products is an advantage).
• Experience with using PowerBI and Highcharts. (Certification in Power BI is an advantage).
• Experience in the development and implementation of the Displacement Tracking Matrix(DTM) or similar assessment and information management activities.
• Experience in the development, troubleshooting, administration and management of information databases and information management systems is required.
• Experience in the development and implementation of population database systems (e.g., migrant registration, censuses, household surveys) is highly desirable.
• Experience in the development and implementation of Open Data Kit (ODK) or any other mobile data collection tools. Proven experience in reproducible statistical analysis with R and/or Python – ideally the candidate shall provide an online portfolio of his projects on GitHub. A written test may be organized to assess those skills.

Skills

• Up-to-date knowledge of cloud computing and use of various tools and environment for application development and hosting.
• Thorough understanding in cloud environments and tools for data systems.
• Pro-active team player who can work with web developers, web designers and production colleagues under pressure to tight deadlines.
• Ability to multi-task, can work independently and think strategically.
• Good organizational skills with the ability to prioritize and an eye for detail.
• Knowledge of principles and practices of graphic design.
• Ability to communicate effectively, both orally and in writing.
• Ability to supervise and train assigned staff.

Languages

IOM’s official languages are English, French, and Spanish. All staff members are required to be fluent in one of the three languages.

For this position, fluency in English is required (oral and written). Working knowledge of Ukrainian and/or another official UN language (Arabic, Chinese, French, Russian, and Spanish) is an advantage.

Proficiency of language(s) required will be specifically evaluated during the selection process, which may include written and/or oral assessments.

Notes

Accredited Universities are the ones listed in the UNESCO World Higher Education Database (https://whed.net/home.php).

Required Competencies:

Values – all IOM staff members must abide by and demonstrate these five values:

• Inclusion and respect for diversity: Respects and promotes individual and cultural differences. Encourages diversity and inclusion.
• 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.
• Courage: Demonstrates willingness to take a stand on issues of importance.
• Empathy: Shows compassion for others, makes people feel safe, respected and fairly treated.

Core Competencies – behavioural indicators level 2

• 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 actions and delegated work.
• Communication: Encourages and contributes to clear and open communication. Explains complex matters in an informative, inspiring and motivational way.

Managerial Competencies – behavioural indicators level 2

• Leadership: Provides a clear sense of direction, leads by example and demonstrates the ability to carry out the Organization’s vision. Assists others to realize and develop their leadership and professional potential.
• Empowering others: Creates an enabling environment where staff can contribute their best and develop their potential.
• Building Trust: Promotes shared values and creates an atmosphere of trust and honesty.
• Strategic thinking and vision: Works strategically to realize the Organization’s goals and communicates a clear strategic direction.
• Humility: Leads with humility and shows openness to acknowledging own shortcomings.

IOM’s competency framework can be found at this link.

https://www.iom.int/sites/default/files/about-iom/iom_revised_competency_framework_external.pdf

Competencies will be assessed during a competency-based interview.

Other:

Internationally recruited professional staff are required to be mobile.

Any offer made to the candidate in relation to this vacancy notice is subject to funding confirmation.

This selection process may be used to staff similar positions in various duty stations. Recommended candidates will remain eligible to be appointed in a similar position for a period of 24 months.

The list of NMS countries above includes all IOM Member States which are non-represented in the Professional Category of staff members. For this staff category, candidates who are nationals of the duty station’s country cannot be considered eligible.

Appointment will be subject to certification that the candidate is medically fit for appointment, accreditation, any residency or visa requirements, and background verification and security clearances. Subject to certain exemptions, vaccination against COVID-19 will in principle be required for individuals hired on or after 15 November 2021. This will be verified as part of the medical clearance process.

Vacancies close at 23:59 local time Geneva, Switzerland on the respective closing date. No late applications will be accepted.