- UNDP around the world
Many of UNDP's relationships with countries and territories on the ground exceed 60 years. Find details on our successes and ongoing work.
- Bosnia and Herzegovina
- Burkina Faso
- Cape Verde
- Central African Republic
- Congo (Dem. Republic of)
- Congo (Republic of)
- Costa Rica
- Côte d'Ivoire
- Democratic People's Republic of Korea
- Denmark (Rep. Office)
- Dominican Republic
- E.U (Rep. Office)
- El Salvador
- Equatorial Guinea
- Fiji (Multi-country Office)
- Finland (Rep. Office)
- Geneva (Rep. Office)
- Iraq (Republic of)
- Kosovo (as per UNSCR 1244)
- Lao PDR
- Mauritius & Seychelles
- Norway (Rep. Office)
- Papua New Guinea
- Programme of Assistance to the Palestinian People
- Russian Federation
- Samoa (Multi-country Office)
- São Tomé and Principe
- Saudi Arabia
- Sierra Leone
- South Africa
- South Sudan
- Sri Lanka
- Sweden (Rep. Office)
- The former Yugoslav Republic of Macedonia
- Tokyo (Rep. Office)
- Trinidad and Tobago
- United Arab Emirates
- About Us
- News Centre
DATA WAREHOUSE ARCHITECT,OFFICE OF FINANCIAL RESOURCES MANAGEMENT,BMS
|Location :||New York, UNITED STATES OF AMERICA|
|Application Deadline :||31-Mar-19 (Midnight New York, USA)|
|Type of Contract :||Individual Contract|
|Post Level :||International Consultant|
|Languages Required :||English|
|Starting Date :|
(date when the selected candidate is expected to start)
|Duration of Initial Contract :||20 weeks|
|Expected Duration of Assignment :||20 weeks|
As part of the “Review of UNDP’s management services and business processes”, UNDP is looking to design and implement an enterprise-wide data warehouse that will provide users across country offices (COs), bureaus (Bx) and corporate to have access to flexible reporting and single source of data. Providing flexible reporting and a single source of information will enable COs, Bx, and corporate to proactively plan, monitor performance and make nimble decisions on effective generation and use of resources to help achieve the goals laid out in its Strategic Plan.
This consultancy will formulate the business design of the high-performing enterprise-wide data warehouse, first focusing on finance data and anticipating the possibility to integrate other data necessary to manage the digitally-enabled organization that UNDP wants to be. This data warehouse is first expected to facilitate analysis of finance data for planning, budgeting, allocation of resources, monitoring utilization and revenue, forecasting, and financial reporting, at all levels of the organization.
The consultant will collaborate with business, corporate finance and IT stakeholders to design solutions that support their reporting, analytics, and data exploration needs. The consultant will document detailed requirements for the design of an efficient data warehouse and supporting data marts in a SQL Server environment, including the data structures (e.g. table definitions incorporating data from diverse sources) and data pipelines that support the creation of advanced analytical solutions using UNDP corporate reporting tools.
The consultant will report to the Office of Finance Resource Management (OFRM) in the Bureau of Management Services (BMS) and collaborate closely with the Office of Information Management and Technology (OIMT)
Duties and Responsibilities
SCOPE OF WORK, RESPONSIBILITIES AND DESCRIPTION OF THE PROPOSED ANALYTICAL WORK
Working closely with business, finance and IT teams to design and document detailed requirements for a corporate finance data warehouse that will be utilized by corporate, regional/central bureaux and country offices for their standardized reporting as well as flexible analytics using UNDP corporate reporting tools.
Expected outputs and deliverables and Timelines :
Required Skills and Experience
The application package containing the following (to be uploaded as one file):
Note: The above documents need to be scanned in one file and uploaded to the online application as one document.
Shortlisted candidates (ONLY) will be requested to submit a Financial Proposal.
The Financial Proposal is to be emailed as per the instruction in the separate email that will be sent to shortlisted candidates.
Applicants are reviewed based on Required Skills and Experience stated above and based on the technical evaluation criteria outlined below. Applicants will be evaluated based on cumulative scoring. When using this weighted scoring method, the award of the contract will be made to the individual consultant whose offer has been evaluated and determined as:
Technical evaluation - Total 70% (70 points):
Having reviewed applications received, UNDP will invite the top four shortlisted candidates for interview. Please note that only shortlisted candidates will be contacted.
Candidates obtaining a minimum of 70% (49 points) of the maximum obtainable points for the technical criteria (70 points) shall be considered for the financial evaluation.
Financial evaluation - Total 30% (30 points)
The following formula will be used to evaluate financial proposal:
p = y (µ/z), where
p = points for the financial proposal being evaluated
y = maximum number of points for the financial proposal
µ = price of the lowest priced proposal
z = price of the proposal being evaluated
Candidate obtaining the highest combined scores in the combined score of Technical and Financial evaluation will be considered technically qualified and will be offered to enter into contract with UNDP.
The consultant will work under the guidance and direct supervision of Specialist, Innovations and Solutions, OFRM, BMS, and will be responsible for the fulfilment of the deliverables as specified above.
The work week will be based on 35 hours, i.e. on a 7-hour working day, with core hours being between 9h00 and 18h00 daily.
Annexes (click on the hyperlink to access the documents):
Annex 1 - UNDP P-11 Form for ICs
Annex 2 - IC Contract Template
Annex 3 – IC General Terms and Conditions
Annex 4 – RLA Template
Any request for clarification must be sent by email to firstname.lastname@example.org
The UNDP Central Procurement Unit will respond by email and will send written copies of the response, including an explanation of the query without identifying the source of inquiry, to all applicants.
|Click here for important information for US Permanent Residents ('Green Card' holders).|
UNDP is committed to achieving workforce diversity in terms of gender, nationality and culture. Individuals from minority groups, indigenous groups and persons with disabilities are equally encouraged to apply. All applications will be treated with the strictest confidence.
UNDP does not tolerate sexual exploitation and abuse, any kind of harassment, including sexual harassment, and discrimination. All selected candidates will, therefore, undergo rigorous reference and background checks.