Advanced Excel User (to create AL / SL tracking document)

Details

Mission and objectives

UNICEF is mandated by the United Nations General Assembly to advocate for the protection of children's rights, to help meet their basic needs and to expand their opportunities to reach their full potential.UNICEF is guided by the Convention on the Rights of the Child and strives to establish children's rights as enduring ethical principles and international standards of behaviour towards children.UNICEF insists that the survival, protection and development of children are universal development imperatives that are integral to human progress.UNICEF mobilizes political will and material resources to help countries, particularly developing countries, ensure a "first call for children" and to build their capacity to form appropriate policies and deliver services for children and their families.UNICEF is committed to ensuring special protection for the most disadvantaged children - victims of war, disasters, extreme poverty, all forms of violence and exploitation and those with disabilities.UNICEF responds in emergencies to protect the rights of children. In coordination with United Nations partners and humanitarian agencies, UNICEF makes its unique facilities for rapid response available to its partners to relieve the suffering of children and those who provide their care.UNICEF is non-partisan and its cooperation is free of discrimination. In everything it does, the most disadvantaged children and the countries in greatest need have priority.UNICEF aims, through its country programmes, to promote the equal rights of women and girls and to support their full participation in the political, social, and economic development of their communities.UNICEF works with all its partners towards the attainment of the sustainable human development goals adopted by the world community and the realization of the vision of peace and social progress enshrined in the Cha

Context

The selected Advanced Excel User will work closely with the Human Resources Associate of UNICEF Serbia to define and create the desired document.

Task description

UNICEF Serbia country office employs 30+ staff members, and engages 20+ individual contractors on full-time basis. These individual contractors are entitled to paid Annual Leave (AL) and paid Sick Leave (SL). Given that these are not staff members, their absences are not tracked via the SAP system which is in use for the staff, hence the office is in need to track these data in a different way. The task of the Online Volunteer providing support as Advanced Excel User would be to create an Excel document for tracking the AL and SL for 20-30 people, with some automatized functions/notifications (e.g. showing the balance for each person on today's date, showing warning signs for cases where some AL days will be lost after the annual cut-off date, etc.).