PSP Data Management, Reporting and Insights Consultant
Organizational Context
The UNRWA Private Sector Partnerships Division (PSP) in Headquarters Amman seeks a consultant to manage and ensure the quality of fundraising data. This role is crucial for effective income management, performance monitoring, and informed decision-making. The consultant will work closely with the Business Intelligence and Systems Specialist, handling data from various donation platforms and financial records.
Job Purpose
The primary purpose of this consultancy is to ensure the integrity and accuracy of UNRWA's Private Sector Partnerships (PSP) fundraising data, primarily within Salesforce. The role involves meticulous data management, including preparation, cleaning, validation, and import of donor and donation records. A key responsibility is reconciling this data with external sources like payment gateways and finance records to identify and resolve discrepancies. The consultant will also be responsible for generating consolidated reports and dashboards, analyzing key trends, and supporting forecasting activities. This ensures that PSP has reliable, actionable insights to optimize fundraising efforts and strategic planning, contributing directly to the division's operational efficiency and effectiveness.
Responsibilities
Key responsibilities include comprehensive Salesforce data management, encompassing the preparation, cleaning, validation, and import of donor, donation, and campaign records. This involves identifying and rectifying missing, duplicate, or incorrectly classified data, and collaborating with developers on system issues. The role requires rigorous income reconciliation by comparing Salesforce data against payment gateways, platforms, bank transfers, and finance records, investigating and documenting any discrepancies. Furthermore, the consultant will produce and validate consolidated income and donor reports and dashboards, explaining trends, variances, and performance against targets. Support for forecasting and reforecasting with validated data, maintaining clear data definitions and procedures, and flagging data risks are also essential duties. Deliverables include monthly data quality updates, reporting packages, and planning/continuity outputs.
Work Experience
A minimum of 5 years of relevant experience in data management, reporting, reconciliation, or analytics is required. Practical Salesforce experience is essential. Experience with fundraising or donor data, payment gateways, forecasting, Power BI, Power Query, or SQL, and within a UN or nonprofit setting is desirable.
Skills
Salesforce data management, data cleaning, data validation, data import, income reconciliation, reporting, data analysis, forecasting, Excel proficiency, attention to detail, ability to reconcile data across systems, clear communication of findings.