Consultancy – Database Consultant, Data and Analytics (D&A), DAPM NYHQ (remote-based)

Consultancy Title: Database Guide

Part/Division/Obligation Station: Well being and HIV Unit, Knowledge & Analytics (D&A) Part, DAPM, UNICEF NYHQ

Length: 1 Could 2024 – 30 April 2025

About UNICEF

If you’re a dedicated, inventive skilled and are captivated with making an enduring distinction for youngsters, the world’s main kids’s rights group wish to hear from you. For 70 years, UNICEF has been engaged on the bottom in 190 nations and territories to advertise kids’s survival, safety, and improvement. The world’s largest supplier of vaccines for creating nations, UNICEF helps baby well being and vitamin, good water and sanitation, high quality primary schooling for all girls and boys, and the safety of youngsters from violence, exploitation, and AIDS. UNICEF is funded solely by the voluntary contributions of people, companies, foundations, and governments. UNICEF has over 12,000 workers in additional than 145 nations.

BACKGROUND

Goal of Exercise/Task:

The Maternal, New child, Baby, and Adolescent Well being (MNCAH) portfolio of the Well being and HIV Unit, Knowledge and Analytics Part of UNICEF New York Headquarters maintains and updates a worldwide MNCAH database which is a key supply for country- and regional-level MNCAH knowledge. This repository is utilized by a variety of stakeholders for actions associated to monitoring, planning and advocacy. There are plans to increase the MNCAH database to align with rising international well being priorities (non-communicable ailments (NCDs), local weather change, resilience, and psychological well being) to incorporate administrative knowledge, modelled knowledge, and subnational knowledge, and to enhance timeliness of the information availability which can necessitate strategic enhancements to the worldwide database workflow.

To materialise this imaginative and prescient, there’s a want for an intensive assessment and optimization of the present international database workflow which would require refactoring present codes and writing new code to include further knowledge sources and indicators and to enhance the information circulate for steady, real-time reporting. Along with sustaining the worldwide database, the marketing consultant will help upkeep and improvement of knowledge merchandise and knowledge reporting processes. The marketing consultant will present technical experience wanted to navigate this course of efficiently underneath the steering and supervision of the Statistics and Monitoring Adviser (MNCAH). The marketing consultant may also prolong help to databases associated to HIV and Immunization and guarantee constant coding practices to harmonize knowledge administration processes, with a give attention to overlapping areas to boost synergy throughout all three databases.

Scope of Work:

The marketing consultant will actively contribute to the MNCAH portfolio, specializing in advancing the upkeep, growth, and performance of the worldwide MNCAH database.

Beneath direct supervision of the Statistics and Monitoring Adviser (MNCAH) of the Knowledge and Analytics Part, DAPM, the marketing consultant is to strengthen the MNCAH international database with further help for databases associated to HIV and Immunization by refining present processes, increasing its protection to deal with rising priorities, and seamlessly integrating administrative and modelled knowledge with reported knowledge. The overarching aim is to fortify the database as a dependable and dynamic useful resource for complete close to real-time international well being reporting.

Phrases of Reference / Deliverables

In shut collaboration and dealing with the Statistics and Monitoring Advisor, the incumbent is liable for the next deliverables:

Deliverable 1: Assessment, enhance and increase MNCAH and HIV databases.

• Complete assessment of the prevailing Well being and HIV databases, together with recognized strengths, weaknesses, and enchancment suggestions

Deliverables/Outputs: Report on the assessment of the prevailing Well being and HIV databases

Supply deadline: 31 Could 2024

• Assist refactoring of R code for sustaining the Well being and HIV international database.

Deliverables/Outputs: Assessment refactored R codes to make sure they align with DAPM code requirements.

Supply deadline: 30 June 2024

• Assist compilation of knowledge for MNCAH international database and updating of world database.

Deliverables/Outputs: Excel spreadsheet with newly extracted knowledge and up to date MNCAH international database spreadsheet

Supply deadline: 31 July 2024

• Assist growth of MNCAH international databases to rising areas of curiosity (baby and adolescent psychological well being, resilience and emergencies, local weather change, NCDs).

Deliverables/Outputs: Integration of MNCAH database with new rising areas (baby and adolescent psychological well being, resilience and emergencies, local weather change, NCDs)

Supply deadline: 31 October 2024

Deliverable 2: Integration of modelled knowledge and administrative knowledge into international MNCAH database

• Roadmap for the incorporation of modelled estimates and administrative knowledge into international database.

Deliverables/Outputs: Roadmap

Supply deadline: 31 August 2024

• Code wanted to include modelled estimates and administrative knowledge into international database.

Deliverables/Outputs: R Codes aligned with DAPM code requirements.

Supply deadline: 30 September 2024

• Compilation of administrative knowledge and modelled estimates and integrating this into the MNCAH international database.

Deliverables/Outputs: Integration of MNCAH database with administrative knowledge and modelled estimates

Supply deadline: 31 October 2024

Deliverable 3: Assist knowledge advocacy and communication merchandise together with dashboards and webpage updates.

• Up to date MNCAH datasets and high quality assurance (QA) help for visualization merchandise, together with Adolescent Well being Profiles, Countdown to 2030 Profiles, Youngsters’s Environmental Well being Profiles, and Baby Well being and Properly-being Dashboard.

Deliverables/Outputs: Up to date datasets and QA help for adolescent well being profiles

Supply deadline: 31 December 2024

•  Compiled and restructured knowledge for and QA help for Countdown to 2030 profiles

Supply deadline: 30 September 2024

Deliverables/Outputs: Up to date datasets and QA for Youngsters’s Environmental Well being Profiles

Supply deadline: 31 Could 2025

Deliverables/Outputs: Up to date datasets and QA for Baby Well being and Wellbeing Dashboard

Supply deadline: 31 Could 2025

• Replace MNCAH webpage narratives, and charts to align with international database.

Deliverables/Outputs: Up to date webpages and infograms

Supply deadline: 30 June 2024

Deliverable 4: Assist knowledge reporting, session, and proof well being desk

• Assist for knowledge reporting on SDGs, SOWC, and SP.

Deliverables/Outputs: Knowledge tables within the applicable codecs which were high quality assured.

Supply deadline: 28 February 2025

• Assist nation session processes associated to updating of world database and SDG reporting.

Deliverables/Outputs: Accomplished assessment of nation inputs.

Supply deadline: 31 January 2025

• Assist nation consultations to assemble data on administrative knowledge and knowledge wants.

Deliverables/Outputs: Report summarizing findings from administrative knowledge session classes.

Supply deadline: 31 March 2025

• Proof assist desk help.

Deliverables/Outputs: Transient weekly summaries of help offered.

Supply deadline: 30 April 2025

{Qualifications}

Training

• Grasp’s diploma in knowledge science, Laptop science, demography, public well being, social sciences, epidemiology, statistics, or associated discipline.   
• Experience in communication, buyer orientation, and preferable glorious understanding of efficiency administration techniques, coaching supplies, and competency framework.
• The person ought to be extremely proficient in a variety of PC/internet purposes, together with however not restricted to: MS Phrase, MS Excel, MS PowerPoint, MS Outlook, and Lotus Notes.

Work expertise

• Minimal two years of labor expertise on the nationwide or worldwide ranges in statistical knowledge processing, knowledge evaluation, and improvement/upkeep of statistical databases.
• Confirmed expertise in analysing, compiling, and presenting knowledge, with a give attention to MNCAH associated areas ideally.
• Demonstrated experience working with R (most popular), python or STATA.  
• Expertise with enterprise databases and ETL instruments (e.g., Databricks)
• Expertise with knowledge visualization software program (e.g., Tableau, Energy BI) is an asset.
• Demonstrated information of world well being knowledge techniques
• Glorious communication and interpersonal expertise.
• Confirmed skill to work collaboratively in a multidisciplinary and multicultural atmosphere.
• Proficient in English; information of different UN languages is an asset.

Competencies

• Glorious communication and interpersonal expertise.
• Confirmed skill to work collaboratively in a multidisciplinary and multicultural atmosphere.
• Proficient in English; information of different UN languages is an asset.

Necessities: 

• Accomplished profile in UNICEF’s e-Recruitment system.
• Add copy of educational credentials
• Monetary proposal that may embody:
• the prices per every deliverable and the overall all-inclusive (lump-sum) charges for the entire project (in US$) to undertake the phrases of reference.
  • journey prices and day by day subsistence allowance, if internationally recruited or journey is required as per TOR.
  • Every other estimated prices: visa, medical insurance, as relevant.
  • Point out your availability.
• Any emergent / unexpected responsibility journey and associated bills might be lined by UNICEF.
• On the time the contract is awarded, the chosen candidate should have in place present medical insurance protection.
• Fee {of professional} charges might be primarily based on submission of agreed passable deliverables. UNICEF reserves the best to withhold fee in case the deliverables submitted are less than the required customary or in case of delays in submitting the deliverables on the a part of the marketing consultant.

Well being Insurance coverage:

The Guide is absolutely liable for arranging at their very own expense, akin to life, well being, and different types of insurance coverage protecting the time period of the Contract as she or he considers applicable.  The Guide will not be eligible to take part within the life or medical insurance schemes accessible to UNICEF and United Nations workers members.

For each Baby, you reveal… 

UNICEF’s values of Care, Respect, Integrity, Belief, Accountability, and Sustainability (CRITAS). 

To view our competency framework, please go to  here. 

UNICEF is right here to serve the world’s most deprived kids and our international workforce should mirror the variety of these kids. The UNICEF family is committed to include everyone, no matter their race/ethnicity, age, incapacity, gender id, sexual orientation, faith, nationality, socio-economic background, or every other private attribute.

UNICEF gives reasonable accommodation for consultants/particular person contractors with disabilities. This may increasingly embody, for instance, accessible software program, journey help for missions or private attendants. We encourage you to reveal your incapacity throughout your utility in case you want affordable lodging through the choice course of and afterwards in your project. 

UNICEF has a zero-tolerance coverage on conduct that’s incompatible with the goals and targets of the United Nations and UNICEF, together with sexual exploitation and abuse, sexual harassment, abuse of authority and discrimination. UNICEF additionally adheres to strict baby safeguarding ideas. All chosen candidates might be anticipated to stick to those requirements and ideas and can subsequently bear rigorous reference and background checks. Background checks will embody the verification of educational credential(s) and employment historical past. Chosen candidates could also be required to offer further data to conduct a background examine. 

Remarks:  

Solely shortlisted candidates might be contacted and advance to the subsequent stage of the choice course of. 

People engaged underneath a consultancy or particular person contract won’t be thought-about “workers members” underneath the Employees Laws and Guidelines of the United Nations and UNICEF’s insurance policies and procedures, and won’t be entitled to advantages offered therein (akin to go away entitlements and medical insurance coverage protection). Their circumstances of service might be ruled by their contract and the Normal Circumstances of Contracts for the Companies of Consultants and Particular person Contractors. Consultants and particular person contractors are liable for figuring out their tax liabilities and for the fee of any taxes and/or duties, in accordance with native or different relevant legal guidelines. 

The chosen candidate is solely accountable to make sure that the visa (relevant) and medical insurance required to carry out the duties of the contract are legitimate for the complete interval of the contract. Chosen candidates are topic to affirmation of fully-vaccinated standing in opposition to SARS-CoV-2 (Covid-19) with a World Well being Group (WHO)-endorsed vaccine, which have to be met previous to taking on the project. It doesn’t apply to consultants who will work remotely and aren’t anticipated to work on or go to UNICEF premises, programme supply places or immediately work together with communities UNICEF works with, nor to journey to carry out capabilities for UNICEF at some point of their consultancy contracts.