Consultant - Supply chain data specialist

Purpose of consultancy

Provide technical expertise to the Supply chain transformation project, subproject B2 : Demand, inventory and operation planning.

Background

The mission of the WHO’s Health Emergencies (WHE) Programme is to build the capacity of Member States to manage health emergency risks and, when national capacities are overwhelmed, to lead and coordinate the international health response to contain outbreaks and to provide effective relief and recovery to affected populations. The objective of the Operation Supports and Logistic team (OSL) is to provide support to the response to emergency but also to develop tool and guidance to strengthen our supply chain and increase efficiency of our field team.

Within the WHO supply chain transformation project, the OSL unit is chairing the subproject, related to Demand, inventory and operation planning. The objective of this project is to improve the supply chain performance by strengthening the planning component of the supply chain, to better anticipate and the countries and region’s needs and improve grants implementation. The incumbent will work as part of a global, cross-functional team, collaborating with members located in different countries.

Deliverables

• Provide recommendations to optimize organizational databases for improved performance and reliability, including data integrity, backups, and updates.
  • Deliverable: Database optimization, including technical troubleshooting report detailing identified issues and solutions applied.
    Expected by: 30-Mar-2025.
• Collaborate with stakeholders to analyze business needs and translate them into technical specifications and provide guidance on aligning technical solutions with business objectives.
  • Deliverable: Comprehensive documentation outlining business requirements and their translation into technical specifications.
    Expected by: 30-Jun-2025.
• Design and implement SharePoint sites to enhance collaboration and data sharing, including expert inputs on SharePoint functionality and capacity-building sessions for users.
  • Deliverable: Operational and user-friendly SharePoint sites, supported by user guides and training sessions for relevant teams.
    Expected by: 30-Sep-2025.
• Design and deliver interactive dashboards tailored to stakeholders’ needs for effective visualization techniques and actionable data insights.
  • Deliverable: Fully functional and customized dashboards delivered with accompanying user documentation. Kits dashboard WHO Hubs Dashboard.
    Expected by: 15-Dec 2025.
• Contribute to project planning, monitoring, and coordination activities to align with global team objectives.
  Expected by: Monthly report and monthly project management meeting.

Qualifications, experience, skills and languages

Educational Qualifications

Essential:

• A university degree in supply chain, administration, computer sciences, programming engineering, science, economics, or related area.

Desirable:

• Additional professional training/specialization in data management.

Experience

Essential:

• At least five years' practical experience in data visualization and database management in supply chain management.

Desirable:

• Proven successful experience with supply chain of health commodities.
• Experience in humanitarian or United Nations area.

Skills/Knowledge

Essential:

• Power BI: Proficiency in Power BI for dashboard design, data visualization, and Power Query for data transformation
• Excellent control of SQL through Microsoft Query and integrating data with Excel and SQL skills for managing and querying relational databases

Desirable:

• Good control of SharePoint Framework (SPFx) and PHP

Languages and level required

Essential:

• Expert knowledge of English

Desirable:

• Intermediate knowledge of French

Location

Offsite: Home-based

Travel

The consultant is expected to travel.

Remuneration and budget (travel costs are excluded)

Remuneration

Band level B: USD 7,000 - 9,980 per month

Living expenses (A living expense is payable to on-site consultants who are internationally recruited)

N/A

Expected duration of contract

11 months. Additional contracts may be offered based on programme needs and availability of funds.

Additional Information:

• This vacancy notice may be used to identify candidates for other similar consultancies at the same level.
• Only candidates under serious consideration will be contacted.
• A written test may be used as a form of screening.
• If your candidature is retained for interview, you will be required to provide, in advance, a scanned copy of the degree(s)/diploma(s)/certificate(s) required for this position. WHO only considers higher educational qualifications obtained from an institution accredited/recognized in the World Higher Education Database (WHED), a list updated by the International Association of Universities (IAU)/United Nations Educational, Scientific and Cultural Organization (UNESCO). The list can be accessed through the link: http://www.whed.net/. Some professional certificates may not appear in the WHED and will require individual review.
• For information on WHO's operations please visit: http://www.who.int.
• The WHO is committed to creating a diverse and inclusive environment of mutual respect. The WHO recruits workforce regardless of disability status, sex, gender identity, sexual orientation, language, race, marital status, religious, cultural, ethnic and socio-economic backgrounds, or any other personal characteristics.
  The WHO is committed to achieving gender parity and geographical diversity in its workforce. Women, persons with disabilities, and nationals of unrepresented and underrepresented Member States (https://www.who.int/careers/diversity-equity-and-inclusion) are strongly encouraged to apply for WHO jobs.
  Persons with disabilities can request reasonable accommodations to enable participation in the recruitment process. Requests for reasonable accommodation should be sent through an email to reasonableaccommodation@who.int
• An impeccable record for integrity and professional ethical standards is essential. WHO prides itself on a workforce that adheres to the highest ethical and professional standards and that is committed to put the WHO Values Charter (https://www.who.int/about/who-we-are/our-values) into practice.
• WHO has zero tolerance towards sexual exploitation and abuse (SEA), sexual harassment and other types of abusive conduct (i.e., discrimination, abuse of authority and harassment). All members of the WHO workforce have a role to play in promoting a safe and respectful workplace and should report to WHO any actual or suspected cases of SEA, sexual harassment and other types of abusive conduct. To ensure that individuals with a substantiated history of SEA, sexual harassment or other types of abusive conduct are not hired by the Organization, WHO will conduct a background verification of short-listed candidates.
• WHO has a smoke-free environment and does not recruit smokers or users of any form of tobacco.
• Consultants shall perform the work as independent contractors in a personal capacity, and not as a representative of any entity or authority.
• WHO shall have no responsibility for any taxes, duties, social security contributions or other contributions payable by the Consultant. The Consultant shall be solely responsible for withholding and paying any taxes, duties, social security contributions and any other contributions which are applicable to the Consultant in each location/jurisdiction in which the work hereunder is performed, and the Consultant shall not be entitled to any reimbursement thereof by WHO.
• Please note that WHO’s contracts are conditional on members of the workforce confirming that they are vaccinated as required by WHO before undertaking a WHO assignment, except where a medical condition does not allow such vaccination, as certified by the WHO Staff Health and Wellbeing Services (SHW). The successful candidate will be asked to provide relevant evidence related to this condition. A copy of the updated vaccination card must be shared with WHO medical service in the medical clearance process. Please note that certain countries require proof of specific vaccinations for entry or exit. For example, official proof /certification of yellow fever vaccination is required to enter many countries. Country-specific vaccine recommendations can be found on the WHO international travel and Staff Health and Wellbeing website. For vaccination-related queries please directly contact SHW directly at shws@who.int.
• In case the recruitment website does not display properly, please retry by: (i) checking that you have the latest version of the browser installed (Chrome, Edge or Firefox); (ii) clearing your browser history and opening the site in a new browser (not a new tab within the same browser); or (iii) retry accessing the website using Mozilla Firefox browser or using another device. Click the link for detailed guidance on completing job applications: Instructions for candidates .
• Consultants working in Switzerland must register with the applicable Swiss cantonal tax authorities and social security authorities, within the prescribed timeframes (Guidelines issued by the Swiss Mission are available at: https://www.eda.admin.ch/missions/mission-onu-geneve/en/home/manual-regime-privileges-and-immunities/introduction/Manuel-personnes-sans-privileges-et-immunites-carte-H/Non fonctionnaires et stagiaires.html