Hardship Level (not applicable for home-based)H (no hardship)
Family Type (not applicable for home-based)
Family
Staff Member / Affiliate TypeCONTR Local Entry and Mid-Level Support
Target Start Date2024-03-01
Job Posting End DateFebruary 13, 2024
Terms of ReferenceTitle: PSP Associate (Data Analyst)
Location: Home-based - Preferably the following time zones: Europe, Africa, Middle East and Asia (from GMT +0 up to GMT +7). Kindly disregard the location (Copenhagen) in the WD platform.
Section/Unit: PSP/Global Operations
ICA Level: UNOPS LICA-6
Duration: 01 March 2024 – 31 December 2024
1. General Background:
The Global Operations team within PSP is responsible for coordinating fundraising activities and sets targets and reports on performance for the fundraising network. The incumbent is a member of the global Operations team and will support the team in further maintaining and improving the planning and reporting tools currently in place.
2. Purpose and Scope of Assignment:
Under the overall supervision of ICT Officer and Assistant PSP Officer, the incumbent will assist in the following:
• Prepare quarterly reports templates and monitor the completeness and accuracy of quarterly reports submitted using the established reporting tools.
• Consolidate quarterly reports.
• Ensure that the reports in SharePoint are up to date.
• Develop reports and visualizations based on business needs.
• Assist in establishing and maintain local databases with the complete information.
• Develop SQL queries, create tables, and stored procedure, views based on project requirements.
• Knowledge of PowerBI and DAX or Oracle Analytics Cloud
• Basic knowledge of Data Warehouse
• Prepare templates and monitor the completeness and accuracy reports submitted.
• Support the fundraising network end-users for established reporting queries.
• Perform data analysis with large amounts of data: facts, figures to find conclusions.
• Perform other related duties as required.
3. Qualifications and Experience:
a. Education:
• High School Degree required
• Preferred Bachelor’s degree in fields like math, statistics, computer science, business administration and other relevant fields.
b. Work Experience
• Minimum 3 years of relevant working experience with a High School Diploma and 2 years of relevant working experience with a Bachelors, Master or Doctorate degree.
• Previous working experience with the UN and/or exposure to work in similar contexts is considered an advantage.
• Experienced in using Business Intelligence solutions (reports, dashboards, scorecards) using Power BI, SQL and Excel or Oracle technologies.
c. Key Competencies
• Fluent in English
• Good communication and writing skills.
• Strong analytical skills.
• Attention to detail.
• Determination to meet deadlines.
• Ability to work with others and to be a team player.
• Strong ability to produce and analyse reports rapidly.
• Excellent computer skills and knowledge of Advanced Microsoft Office Skills (Excel, Word, Access).
• Office 365, SharePoint Information Delivery Skills or equivalent technology.
4. Location and conditions:
This is a home-based position. Candidates located in the following time zones (GMT +0 up to GMT +7) are encouraged to apply due to time overlaps with teams based in Europe and Asia.
Kindly disregard the location (Copenhagen) in the WD platform.
This position is initially up to the end of the year with possibility of extension subject to budget availability and overall performance of the incumbent. It is a full-time role from Monday to Friday (40 hours per week).
The remuneration level and the applicable entitlements and benefits may be different based on the residence of the most suitable selected candidate.
,
,
,
,
Skills
Education
Certifications
Work Experience
Other informationLICA 6 - Global Ops positionThis position doesn't require a functional clearance
Home-BasedNo