UNICEF works in some of the world’s toughest places, to reach the world’s most disadvantaged children. To save their lives. To defend their rights. To help them fulfill their potential. 

Across 190 countries and territories, we work for every child, everywhere, every day, to build a better world for everyone. 

And we never give up. 

For every child, a future

Purpose of Activity/Assignment:

In recent years, UNICEF has been the leading UN agency in procurement and delivery of supplies, much of them related to enabling comprehensive primary healthcare for children and their communities. UNICEF operates a global supply chain from demand forecasting to the last-mile delivery, including in conflict and disaster zones. In 2020, UNICEF's Supply Division started a digital supply chain initiative with goals to streamline information processing, create an adaptable organization, and use predictive modelling for decision-making. However, we are faced with challenges, including low data quality and slow adoption of digital tools by staff. Addressing these issues is crucial for improving data quality and providing reliable Supply Intelligence and digital empowerment of staff, as well as enabling the publication of key aspects of our information for the benefit of local and global partners.

The purpose of these consultancies is focused on ensuring quality data feeds and maintaining our systems. The consultants will contribute to the robust development of our cloud-based data warehouse and the Supply Data Quality workstream under the Info Hub project. Under the supervision of the Supply Chain Specialist (Monitoring) in MSDEC, the consultants will gather supply chain intelligence, help organize it in the existing monitoring tools and further develop the implemented visibility tools for decision making, for communication and to demonstrate results. Concretely, the consultants will support MSDEC with supply chain analysis, take active part in the development of the Data Warehouse, the establishment of data models within the data warehouse, the design and maintenance of supply related dashboards and to ensure reliable supply master data quality. In addition, it is expected that the consultants will provide support to digitally empower staff and training in supply chain monitoring.

Scope of Work:

• Support the optimization of UNICEF’s Data Warehouse
  The consultant will support UNICEF’s digitalization strategy by actively participating in the Data Warehouse core project group, with the overall aim of improving the supply data infrastructure. The consultant will serve as the bridge between business centers and IT centre with the task to collect, design, improve, test the supply data in the newly created Data Warehouse. The outcome is to guarantee that the business logic is in place in the Data Warehouse and that the supply data points are ready for dashboard consumption. In addition, the consultant will help business centers migrate their tools to the Data Warehouse and educate SMEs in the use of Power BI models from the Data Warehouse.
• Support decision making and communication
  The consultant will participate in the conceptualization, development, analysis and implementation of business process improvements and solutions that can result in improved monitoring and reporting for UNICEF supply chains. This will entail working in close coordination with colleagues in MSDEC, with the IT center and with colleagues in the business centers and country offices, understanding everyone's needs and facilitating the identification of suitable solutions. Visualization solutions are likely to be based on MS Power Bi and drawing from the existing data warehouse. Planning and prioritizing robust and frequent communication with the MSDEC team will be required, and the consultant will follow the team’s guidance when performing these tasks. Furthermore, the consultant needs to support the maintenance of already existing Power BI dashboards.

• Reliable supply master data quality
  As part of UNICEF’s supply chain reporting and the Supply Data Quality workstream, it is essential that the supply master data is reliable and up to date. Therefore, it is important that the consultant both helps educate staff and takes an active role in monitoring several aspects of the supply dashboards by ensuring preventive and/or corrective actions and, if needed, reaching out to relevant stakeholders in UNICEF SD.

• Support the integration of forecast and demand planning data
  As the flow of information concerning UNICEF country’s forecasts and demand plans is digitalized and turned into a rolling flow, there will be a need to organize this information in the Data Warehouse and logically link and relate it to existing information flows and master data. The consultant will support the design, establishment, testing and implementation of the business logic and its visualization along the actual procurement and delivery information. 

• Generate supply relevant business intelligence
  The consultant will be responsible for analyzing specific supply-related requests. This will include identifying, given the request, the best way forward and methodology in collaboration with colleagues in MSDEC, regional offices and country-level colleagues as relevant, collecting the information from identified sources, which may include SAP, existing dashboards and external sources, organizing the information, performing the analysis, and presenting it in the most suitable format and platform. Such a request is expected to be cross-cutting and cover different supply commodities and services, and the consultant will work on these with the guidance provided by the MSDEC team. As it is expected that the consultant will work on several requests at a time and in parallel, the maintenance of an implementation and analysis plan discussed regularly with the area manager will also be required. 

• Documentation and Training
  The consultant shall provide all needed documentation related to reports/dashboards and design development as needed such as: data model diagrams, main query logic, etc. The consultant is expected to provide colleagues with initial training and documentation on the maintenance of the BI analytics dashboard, including data sources and data models if requested. Additionally, the consultant is expected to provide training to UNICEF colleagues on best practices in supply monitoring.

How can you make a difference? 

1. Support the optimization of UNICEF’s Data Warehouse
   The consultant will actively engage both in the Data Warehouse core project group meetings and the Supply Data Quality workstream meetings under the Info Hub project. This involvement includes providing insights, recommendations, and expertise to enhance the design and functionality of the Data Warehouse and extraction of raw master data for the Supply Data Quality workstream.
2. Bridging Business Centers and IT Center: The consultant will act as a liaison between the business centres and the IT centre, facilitating the collection, design, improvement, and testing of supply data within the newly established Data Warehouse. This deliverable involves collaborating with stakeholders to ensure that the business logic is accurately represented in the Data Warehouse and that the supply data points are effectively prepared for dashboard consumption.
3. Support decision making, communication and support the integration of forecast and demand planning data. Development and maintenance of Supply dashboards among others,
   -Supply Chain Dashboard based on the Supply Chain data model.
   - Link and upgrade forecast and demand dashboards to Info Hub.
   -Procurement Dashboard.
   -Help establishing a new UNICEF WHO health dashboard and BHA dashboard.
4. Documentation and Training
   Provide comprehensive documentation for report/dashboard design, including data model diagrams and query logic. Additionally, offer training to colleagues on maintaining BI dashboards, covering data sources and models upon request. Additionally, the consultant is expected to provide training to UNICEF colleagues on best practices in supply monitoring.
5. Reliable supply master data quality / Generate supply relevant business intelligence
   A minimum of 8 analysis pieces are based on specific supply related requests connected to Supply Monitoring tools and Supply Chain Data quality issues, and as per plans agreed to with the team.

To qualify as an advocate for every child you will have… 

• Education: A completed Advanced University degree (master's degree) in supply chain, economics, business administration, development studies, information systems management, social sciences, statistics, engineering, or relevant field is required. A relevant first-level university degree in the above areas combined with 5 years of relevant qualifying experience may be accepted instead of the advanced university degree.

• Work Experience: Minimum 2 years' work experience in public and/or private sector with proficiency in use of data processing/Data Warehouse, business data analysis and intelligence, systems, and process analysis, and/or performance monitoring is required, preferably in areas related to the supply chain. Prior knowledge and working experience with SAP and strong skillset of MS Power Bi/SQL are considered a strong asset.

• Competencies:
  • Communication
  • Working with People
  • Drive for Results
  • Planning and Organizing
  • Applying Technical Expertise

• Technical Knowledge:
  • Demonstrated knowledge and experience in supply chain data analysis
  • Good presentation skills and experience with communicating visually and in writing analysis results
  • Proven ability to work independently in a multicultural setting and readiness to challenge your colleagues in the interests of achieving high-quality results
  • Good knowledge of planning and / or project management principles and practices
  • Systems competent, preferable with knowledge of SAP, Data warehousing, SQL and able to use the MS standard computer software
  • Strong skillset in MS Power BI and knowledge of DAX.
  • Ability to develop and maintain an effective network of working relationships 

• Fluency in English is required. Knowledge of another official UN language (Arabic, Chinese, French, Russian or Spanish) or a local language is an asset. 

How to apply:

Qualified candidates are requested to submit:

1. Cover letter/application.
2. Daily rate and all-inclusive lumpsum for this consultancy.
3. At least 3 Reference contacts.
4. A copy of your highest diploma.

For every Child, you demonstrate… 

UNICEF's values of Care, Respect, Integrity, Trust, Accountability, and Sustainability (CRITAS). 

To view our competency framework, please visit  here. 

UNICEF is committed to diversity and inclusion within its workforce, and encourages all candidates, irrespective of gender, nationality, religious or ethnic background, and persons with disabilities, to apply to become a part of the organization. To create a more inclusive workplace, UNICEF offers paid parental leave, breastfeeding breaks, and reasonable accommodation for persons with disabilities. UNICEF strongly encourages the use of flexible working arrangements. Click here to learn more about flexible work arrangements, well-being, and benefits.

According to the UN Convention on the Rights of Persons with Disabilities (UNCRPD), persons with disabilities include those who have long-term physical, mental, intellectual, or sensory impairments which, in interaction with various barriers, may hinder their full and effective participation in society on an equal basis with others. In its Disability Inclusion Policy and Strategy 2022-2030, UNICEF has committed to increase the number of employees with disabilities by 2030. At UNICEF, we provide reasonable accommodation for work-related support requirements of candidates and employees with disabilities. Also, UNICEF has launched a Global Accessibility Helpdesk to strengthen physical and digital accessibility. If you are an applicant with a disability who needs digital accessibility support in completing the online application, please submit your request through the accessibility email button on the UNICEF Careers webpage Accessibility | UNICEF.

UNICEF does not hire candidates who are married to children (persons under 18). UNICEF has a zero-tolerance policy on conduct that is incompatible with the aims and objectives of the United Nations and UNICEF, including sexual exploitation and abuse, sexual harassment, abuse of authority and discrimination based on gender, nationality, age, race, sexual orientation, religious or ethnic background or disabilities. UNICEF is committed to promote the protection and safeguarding of all children. All selected candidates will, therefore, undergo rigorous reference and background checks, and will be expected to adhere to these standards and principles. Background checks will include the verification of academic credential(s) and employment history. Selected candidates may be required to provide additional information to conduct a background check, and selected candidates with disabilities may be requested to submit supporting documentation in relation to their disability confidentially.

Remarks:  

Only shortlisted candidates will be contacted and advance to the next stage of the selection process. 

Individuals engaged under a consultancy or individual contract will not be considered “staff members” under the Staff Regulations and Rules of the United Nations and UNICEF’s policies and procedures, and will not be entitled to benefits provided therein (such as leave entitlements and medical insurance coverage). Their conditions of service will be governed by their contract and the General Conditions of Contracts for the Services of Consultants and Individual Contractors. Consultants and individual contractors are responsible for determining their tax liabilities and for the payment of any taxes and/or duties, in accordance with local or other applicable laws. 

The selected candidate is solely responsible to ensure that the visa (applicable) and health insurance required to perform the duties of the contract are valid for the entire period of the contract. Selected candidates are subject to confirmation of fully-vaccinated status against SARS-CoV-2 (Covid-19) with a World Health Organization (WHO)-endorsed vaccine, which must be met prior to taking up the assignment. It does not apply to consultants who will work remotely and are not expected to work on or visit UNICEF premises, programme delivery locations or directly interact with communities UNICEF works with, nor to travel to perform functions for UNICEF for the duration of their consultancy contracts.