Terms of Reference (ToR) Hiring Consultant for SUN UNOPs Database Development

Background

The new 2018-2024 National Strategy to Accelerate Stunting Prevention (StraNas Stunting) has been formulated with the objective to reduce these high stunting rates across Indonesia through better coordination and aligning incentives across national, sub-national, and non-state actors. Led by Indonesia’s President Joko Widodo and Vice President Jusuf Kalla, the strategy aims to ensure all key related stakeholders works together with a Holistic, Integrative, Thematic, and Spatial (HITS) approach to achieve the same goal and objectives in stunting prevention and reduction. BAPPENAS as Scaling Up Nutrition (SUN) focal point organizes six networks i.e.  Governments (ministries and other related state institutions); Donor and UN System Country Network for Nutrition (DUNCNN); Business Network, Civil Society Alliance, Academia and Professional Organization, and Media. 

In 2018 Nutrition International (NI) Indonesia has been appointed as Indonesia SUN CSA coordinator and in 2019 NI received SUN UNOPs Pooled Grant Fund to promote sustainable improvement in nutritional status of the people of Indonesia by creating a strong, coordinated and vibrant civil society constituency. In order to have strong governance and working systems of SUN CSA with inclusive and diversified membership covering nutrition and multiple sectors there is a need to develop SUN CSA database.

Objective

The objective is this assignment is to develop, update and maintain SUN CSA membership database, including documentations lesson learned from SUN CSA successful model.

Scope of Work

The scope of this assignment are as follows:

1.       Provide a conceptual data model that reflects the structure of the information to be held in the SUN CSA database.

2.       Translate the conceptual data model into database

3.       Developing database to record SUN CSA membership data at National, Central Java and East Java Province for at least the following items

·         ID Auto Number

·         Full Name

·         Job Title

·         Company

·         Addresses

·         E-mails

·         Telephone Numbers

·         Intervention/Working/Geographical area

·         Type of Intervention (Specific or Sensitive)

·         Additional information on intervention

4.    Pre-test the database for data analysis and produce reports for their immediate use.

5.    Roll out of the database

6.    Introduce and train NI staff on database use and maintenance activities.

7.    Regularly maintain and update the SUN CSA database

8.    Develop Excel/Access or other database standard report generation

9.    Compile and document lesson learned from successful model of SUN CSA and integrate it in database

Deliverables

The consultant(s) are expected to produce the following deliverables.

1.    Presentation of conceptual model Design

2.    Physical database design

3.    Report on pre-test run of database

4.    Report on SUN CSA Database

Duty Station/Location

Jakarta

Term of appointment

The duration of this assignment is starting from April to July 2020

The qualification of consultant

The consultant(s) will be selected following a competitive recruitment process. The consultant should have the following expertise:

1.       A minimum of 5 years of experience in database design and roll out for health development projects

2.       Proven experience to lead in the structural design of a database according to various system requirements.

3.       Education in Computer Science especially SQL server database development and Microsoft certification in database Administration/Development (Desirable)

4.       Analytical and Documentation skills, presentation of reports

5.       Excellent command of English

Interested candidates should send their application letter together along with curriculum vitae (CVs) and financial proposal (please refer to Annex 1. Financial Proposal Template ) by email to proposalsindonesia@nutritionintl.org before 21 February 2020, 05.00 pm WIB (Jakarta, Indonesia). Only complete applications will be reviewed.

Kindly mention ‘SUN UNOPS- Hiring Consultant for SUN UNOPs Database Development ‘in the subject line of the email.

Nutrition International is committed to gender equality. All eligible applicants are invited to apply. Only shortlisted applicants will be contacted.

Regards,

NUTRITION INTERNATIONAL

2nd Fl. Gedung Wirausaha

Jl. H.R. Rasuna Said Kav C-5

Jakarta, 12940

Tel:  +62 21 5277644

Fax:  +62 21 5277645

www.nutritionintl.org<http://www.nutritionintl.org>

ANNEXURE I. Financial Proposal Template

No		Items	Unit		Frequency		Cost per unit	Amount in IDR
I	Personnel Cost
	1	Professional fees	1	Person		Mandays
II	Expense
	1	Stationery, communication, printing	3	Package	4	Months
	2	Transportation	3	Package	4	Months
	T o t a l   C o s t