Background
The United Nations Volunteers (UNV) programme is the UN organization that contributes to peace and development through volunteerism worldwide. Volunteerism is a powerful means of engaging people in tackling development challenges, and it can transform the pace and nature of development. Volunteerism benefits both society at large and the individual volunteer by strengthening trust, solidarity and reciprocity among citizens, and by purposefully creating opportunities for participation. UNV contributes to peace and development by advocating for recognition of volunteers, working with partners to integrate volunteerism into development programming, and mobilizing an increasing number and diversity of volunteers, including experienced UNV volunteers, throughout the world. UNV embraces volunteerism as universal and inclusive, and recognizes volunteerism in its diversity, as well as the values that sustain it: free will, commitment, engagement and solidarity.
UNV Information and Communications Technology Unit (ICTU), located in Bonn, Germany, is responsible for creating and maintaining multiple corporate applications. The unit is actively engaged in delivering on Digital Transformation.
This consultancy would contribute to Digital Transformation project’s Output 1: Unified Volunteer Platform (UVP). The platform will facilitate volunteer mobilization by establishing an intuitive single-entry point for candidates to offer their services (regardless of the volunteer modality); and for organizations to request services of volunteers (for all types of assignments). Establishment of the Unified Volunteer Platform will result in deployment of UN Volunteers worldwide faster and at a reduced cost of operations.
2. MAIN OBJECTIVES, RESPONSABILITIES AND DESCRIPTION OF THE PROPOSED ANALYTICAL WORK.
UNV Information and Communications Technology Unit (ICTU), located in Bonn, Germany, is responsible for developing and maintaining Microsoft-based Business Intelligence (BI) solution. The technologies used are the following:
- SQL Integration Services (SSIS)
- SQL Server
- Power BI Premium and Pro
- Azure Infrastructure
UNV is looking for a Microsoft BI expert to provide on-site strong technical expertise and delivery for all Power BI related tasks. The onsite presence is critical in order to interact with business colleagues, understand the current BI platform, data exchange, existing reports and implement the changes in coordination with UNV BI specialist.
Duties and Responsibilities
Deliverables/ Outputs
Estimated Duration to Complete
Target Due Dates
- Define requirements with Finance and Budget Section (FBS) regarding finance reporting, No of Days 10, Due Date 13-04-2020
- Identify data sources (existing or new ones) and create/update ETL modules. No of Days 20. Due Date 08-05-2020
- Create first set of Power BI data model and reports No of Days 20. Due Date 05-06-2020
- Improve UI/UX of existing and new Reports. No of Days 20. Due date 06-07-2020
- Create second sets of Power BI data model and reports No of Days 40. Due date: 06-09-2020
- Create third sets of Power BI data model and reports. No of Days 40. Due Date 06-11-2020
- Create fourth sets of Power BI data model and reports. No of Days 40. Due Date 06-01-2021
- Create fifth sets of Power BI data model and reports No of Days 40. Due date 15-03-2021
Total days – 230days
UNV will assign project and tasks to the consultant, who will provide time/amount estimates. UNV will review and approve/discuss the estimates. Once approved, the consultant will implement the tasks remotely under the supervision of the BI specialist and overall supervision of the IT Chief.
Competencies
Corporate competencies:
- Demonstrates integrity by modelling the UN’s values and ethical standards;
- Promotes the vision, mission, and strategic goals of UNV;
- Displays cultural, gender, religion, race, nationality and age sensitivity and adaptability
- Treats all people fairly without favoritism;
- Fulfils all obligations to gender sensitivity and zero tolerance for sexual harassment.
Functional competencies:
- Demonstrates professional competence to meet responsibilities and post requirements and is conscientious and efficient in meeting commitments, observing deadlines and achieving results;
- Results-Orientation: Plans and produces quality results to meet established goals, generates innovative, practical solutions to challenging situations;
- Communication: Strong analytical, reporting and writing abilities, including the ability to convey complex concepts and recommendations, both orally and in writing, in a clear and persuasive style tailored to match target audiences;
- Team work: Ability to interact, establish and maintain effective working relations with a culturally diverse team;
- Client orientation: Ability to establish and maintain productive partnerships with national partners and stakeholders and pro-activeness in identifying of beneficiaries and partners’ needs and matching them to appropriate solutions.
Required Skills and Experience
Education:
University degree in information technology, computer science, data analytics, data management or related field, or relevant experience in the field. Following certificates (or similar):
- MCSE: Data Management and Analytics
- MCSA: BI Reporting
- Any other relevant Microsoft BI certificate
Experience:
Relevant experience in Microsoft BI systems, including Power BI, DAX formulas, SSIS, Power Query, M language, data modelling and Datawarehouse
Language requirement:
Excellent writing and oral communication skills in English.
Applicants have to provide a technical and financial proposal.
The technical proposal shall describe the methodology and the approach how to fulfill the required deliverables as well as outline the major components of its implementation.
The financial proposal shall consist of all-inclusive lump sum for the whole duration of the contract period, which shall include the consultancy fee, costs of living, costs for insurance, and cost of travel to and from the duty station. The financial proposal shall contain a breakdown of these costs and indicate the number of off-days the consultant wants to take during the contract period (if any).
The lump sum/contract price is fixed regardless of subsequent changes in the cost components.
Criteria for Selection of the Best offer:
The selection of the best offer will be based on the combined scoring method – where the qualifications and methodology will be weighted – 70% and combined with the price offer which will be weighted 30%.
Key selection criteria are
• Proven experience in updating and creating complex DAX formulas (14 %)
• Proven experience in designing complex Power BI data modelling (14 %)
• Proven experience in designing complex Power Queries in Power BI (14 %)
• Proven experience in designing appealing user interface and user experience reports (14%)
• BI Certifications (14%)
Qualified candidates must apply online via the UNDP Jobshop. Interested candidates are advised to carefully review these terms of reference and ensure that they meet the requirements and qualifications described above.
Applications should contain:
a) Cover Letter, including a summary of your experience and expertise and why you are the most suitable for the job
b) Technical proposal: The technical proposal shall describe the methodology and the approach how to fulfill the required deliverables, ideas you may already have from reviewing our previous Annual Reports online, as well as outline the major components of its implementation. It should be justified by referencing previous experiences.
c). Samples of previous work (where applicable): Indicate type of samples required
d). Financial Proposal using the duly accomplished Letter of Confirmation of Interest and Availability (COI) Link to COI template; https://popp.undp.org/_layouts/15/WopiFrame.aspx?sourcedoc=/UNDP_POPP_DOCUMENT_LIBRARY/Public/PSU_%20Individual%20Contract_Offerors%20Letter%20to%20UNDP%20Confirming%20Interest%20and%20Availability.docx&action=default
Your Financial Proposal must indicate the total contract price, supported by a breakdown of costs, as per template provided. If an 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 UNV under 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 UNV
e) Personal CV or P11, indicating all past experience from similar projects, as well as the contact details (email and telephone number) of the Candidate and at least three (3) professional references;
Please paste the cover letter into the "Resume and Motivation" section of the electronic application and ensure you have provided all requested materials. All supporting documents should be scanned and attached into one PDF format document. Incomplete applications will not be considered.
Queries should be sent to:procurement@unv.org, att Marc Wharton clearly marking – 0093944 Microsoft Business Intelligence Expert
Terms and conditions, as well as contract samples can be found at this link:
http://www.undp.org/content/dam/undp/documents/procurement/documents/IC%20-%20General%20Conditions.pdf
as well as contract samples can be found at this link:http://www.undp.org/content/undp/en/home/procurement/business/how-we-buy.html
Due to the large number of applications we receive, we are only able to inform the successful candidates about the outcome or status of the selection process.
Please make sure you provide all requested materials. Incomplete applications will not be considered. Applications sent by email will not be considered. Applications without the fully completed Confirmation of Interest Form, including financial costs will not be considered.
Note: UNDP/UNV reserves the right to select one or more candidates from this procurement notice. We may also retain applications and consider candidates applying to this post for other similar positions with UNDP/UNV with similar terms of reference, experience and educational requirements.