Consultancy – Integration work between Quantum and the existing Data Warehouse, BMS/OHR/UNDP


Location : Home based, UNITED STATES OF AMERICA
Application Deadline :18-May-22 (Midnight New York, USA)
Additional Category :Management
Type of Contract :Individual Contract
Post Level :International Consultant
Languages Required :
English  
Starting Date :
(date when the selected candidate is expected to start)
01-Jun-2022
Duration of Initial Contract :7 months
Expected Duration of Assignment :7 months

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.


Background

UNDP is the knowledge frontier organization for sustainable development in the UN Development System and serves as the integrator for collective action to realize the Sustainable Development Goals (SDGs).  With presence in 170 countries and territories, UNDP endeavors to help countries develop strong policies, skills, partnerships and institutions so they can sustain their progress. UNDP staff are united by a common purpose: to help countries and communities across the world pursue peaceful, prosperous lives, lived in harmony with the planet. 

Drawing on the diversity of UNDP’s client needs and partnerships, the Office of Human Resources (OHR) is the hub for the global HR function for UNDP, providing strategy, policy setting, guidance, and oversight. In addition, OHR provides a broad range of HR advisory and talent management services enabling UNDP to deliver fully integrated development solutions at corporate level.  In this context, OHR is focused on the implementation of an ambitious and forward-looking three-year strategy, People for 2030, which will progressively transform UNDP’s culture and enable its workforce capacity to deliver more and better results.  

Project Description:

The Quantum is a new Enterprise Resource Management system that will replace Atlas to facilitate new and simplified ways of working and collaborating. Quantum will leverage technology to make UNDP processes more efficient, transparent and data driven.


Duties and Responsibilities

SCOPE OF WORK, RESPONSIBILITIES AND DESCRIPTION OF THE PROPOSED ANALYTICAL WORK

The individual consultant for the Integration of Quantum with Data warehouse is needed for a period for a period of 7 months and will be responsible for following: 

  • Review of all existing reports data sources, tables, field names that need to be changed prior to their incorporation into the new Quantum System;
  • Build queries for data imports from Quantum to DW;
  • Build documentation with details of mapping, Data Import Frequencies;
  • Review the current DW and create mappings from the existing DW tables to the new Quantum tables. ETL's, Queries, Stored Procedures, API's to UN Monthly report, etc.;
  • Creation of new reports in Power BI,  Ad-Hoc Queries, operational work like granting security to reports, help desk  on using new reports, documentation, data mining, etc; Ensure Source to all the Reports are Changes to the new Quantum Data Structures.
  • Ensure Business Continuity by making sure that the current Power BI Framework goes through minimum interruption after Quantum Go-Live
  •  Recommend best practices in Building new Reports in power BI for minimal maintenance in the future.

Expected outputs and deliverables:

The Incumbent will be requested to deliver:

  • A list of all existing reports data sources, tables, field names that need to be changed
  • Queries for data imports from Quantum to DW;
  • Documentation with details of mapping, Data Import Frequencies;
  • Mappings from the existing DW tables to the new Quantum tables. ETL's, Queries, Stored Procedures, API's to UN Monthly report, etc.;
  • New reports in Power BI, Ad-Hoc Queries, operational work like granting security to reports, help desk on using new reports, documentation, data mining, etc..

Deliverables/ Outputs

Estimated Duration to Complete (No. of working days)

Target Due Dates

Person who will review output and confirm acceptance)

 % of payment

A list of all existing reports data sources, tables, field names that need to be changed prior to the integration to Quantum

20 days

20th June 2022

Siddharth Pawar

10%

Developed Queries for data imports from Quantum to DW

80 days

15th October 2022

Siddharth Pawar

30%

Developed documentation with details of mapping, Data Import Frequencies

20 days

15th November 2022

Siddharth Pawar

10%

An end of consultancy report with detailed Technical Documentation of all the work done in the Integration work between Quantum and the existing Data Warehouse.

20 days

31st December 2022

 Siddharth Pawar

50 %

Total

140 days

 

 

100%


Competencies

  • Ability to make new and useful ideas work
  • Ability to persuade others to follow
  • Ability to improve performance and satisfaction
  • Ability to listen, adapt, persuade and transform
  • Ability to get things done while exercising good judgement
  • Knowledge of HR business strategies and managerial issues and principles and the ability to provide strategic advice and innovative solutions
  • Ability to set goals and indicators and to interpret and synthesize results into usable information to inform policy, strategy, and/or action
  • Ability to develop, maintain, and strengthen partnerships with OHR client Bx though people analytics tools and resources contributing to the overall positioning of UNDP.
  • Ability to align Strategic Workforce Planning with People for 2030 strategy, vision, and mission
  • Knowledge of talent management concepts, tools and systems, issues and principles and the ability to apply them to strategic and/or practical situations
  • Ability to use objective problem analysis and judgement to understand how interrelated elements coexist within an overall process or system, and to consider how altering one element can impact on other parts of the system
  • Ability to work effectively with diverse groups of professionals towards common goals
  • Ability to coach/mentor technical staff to enhance sustain capacity development on People Analytics Tools and methodologies


Required Skills and Experience

Academic qualifications:

  • At least Bachelor's degree from an accredited college/university in the following majors with relevant analytics or data management focused coursework: Management/Information Systems, Business Analytics, Information Science/Management, Data Analytics, Computer Science, Computer Information Systems, or Statistics. Required

Experience:

  • At least 3 years’ experience in creating/maintaining dashboard and report using corporate BI or similar tools; (Required)
  • At least 5 years’ experience in MS SQL development (Required)
  • At least 2 years’ experience in Azure DB (Preferred)
  •  Experience with major enterprise database programs, such as Microsoft SQL Server Integration Services, NoSQL databases,.Net Framework, JavaScript, HTML, PHP, and Oracle  ( Preferred).
  • Experience and Knowledge of Oracle HCM systems is an added advantage.

Language:

  • Fluency in written and spoken English is required;
  • Working knowledge of another UN language would be an asset

Application Procedure

The application package containing the following (to be uploaded as one file):

  • A cover letter with a brief description of why the Offer considers her/himself the most suitable for the assignment;
  • Personal CV or P11, indicating all past experience from similar projects and specifying the relevant assignment period (from/to), as well as the email and telephone contacts of at least three (3) professional references;

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 shall specify a total lump sum amount, and payment terms around the specific and measurable deliverables of the TOR. Payments are based upon output, i.e. upon delivery of the services specified in the TOR, and deliverables accepted and certified by the technical manager. 
  • The financial proposal must be all-inclusive and take into account various expenses that will be incurred during the contract, including: the daily professional fee; (excluding mission travel); living allowances at the duty station; communications, utilities and consumables; life, health and any other insurance; risks and inconveniences related to work under hardship and hazardous conditions (e.g., personal security needs, etc.), when applicable; and any other relevant expenses related to the performance of services under the contract.
  • This consultancy is a home-based assignment, therefore, there is no envisaged travel cost to join duty station/repatriation travel. 
  • In the case of unforeseeable travel requested by UNDP, payment of travel costs including tickets, lodging and terminal expenses should be agreed upon, between UNDP and Individual Consultant, prior to travel and will be reimbursed. In general, UNDP should not accept travel costs exceeding those of an economy class ticket. Should the IC wish to travel on a higher class he/she should do so using their own resources.
  • If the Offeror is employed by an organization/company/institution, and he/she expects his/her employer to charge a management fee in the process of releasing him/her to UNDP under a Reimbursable Loan Agreement (RLA), the Offeror must indicate at this point, and ensure that all such costs are duly incorporated in the financial proposal submitted to UNDP.

The Financial Proposal is to be emailed as per the instruction in the separate email that will be sent to shortlisted candidates.

Evaluation process

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:

  • Being responsive/compliant/acceptable; and
  • Having received the highest score out of a pre-determined set of weighted technical and financial criteria specific to the solicitation where technical criteria weighs 70% and Financial criteria/ Proposal weighs 30%.

Technical evaluation - Total 70% (70 points):

  • Criteria 1: Relevance of the experience in creating/maintaining dashboard and report using corporate BI  or similar tools; Weight=30%; Maximum 30 points;
  • Criteria 2: Relevance of the experience and knowledge of Data Warehouse and SQL Queries Weight=20%; Maximum Points: 20;
  • Criteria 3: Relevance of the experience and knowledge in Oracle HCM systems is an added advantage. Weight=10% Maximum 10 points;
  • Criteria 4: Relevance of the experience in Azure DB  Weight=10%; Maximum 10 Points.

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

Contract Award

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.

Institutional arrangement

The consultant will work under the guidance and direct supervision of HR Specialist, Office of Human Resources and will be responsible for the fulfilment of the deliverables as specified above.

Conditions:

The organization will not provide equipment or office space. The Incumbent will work on their own computer(s)/ other equipment and use their own office resources and materials in the execution of this assignment. The Responsible Partner’s fee shall be inclusive of all office administrative costs and products must be compatible with standard UNDP office equipment.

Payment modality

  • Payments are based upon output, i.e. upon delivery of the services specified above and deliverables accepted and upon certification of satisfactory completion by the manager.
  • 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 cpu.bids@undp.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).

If you are experiencing difficulties with online job applications, please contact the eRecruit Helpdesk.

© 2016 United Nations Development Programme