Data Analyst

Job Description

The Democratic Republic of Congo Country Office (DRC CO) is scaling up SCOPE based delivery systems for both Cash Based Transfers (CBT) and In Kind (IK) assistance. As the use of SCOPE expands, the CO faces several challenges: Large volumes of open CBT distribution cycles requiring reconciliation. Launch of IK in SCOPE, necessitating dashboards aligned to CO operational realities. Significant duplication of beneficiary identities, both historical and newly introduced through ongoing registrations. A Payment Instrument Tracking (PIT) tool deployed in the CO, but currently producing inconsistent or inaccurate data outputs. The 2025 internal audit highlighted significant gaps in the areas above and immediate corrective action is required. Donor engagements have reinforced the need for swift and decisive measures to address these concerns. To address these concerns, the CO requires an experienced Data Analyst to strengthen reconciliation processes, improve data assurance, and build dashboards that support timely decision making. Under the supervision of the TEC BTO and in collaboration with Programme, RAM, Supply Chain, Finance and Area Office teams, the consultant will perform the following duties:

Responsibilities

• I. CBT Reconciliation in SCOPE
• 1. Conduct a full inventory of all open CBT distribution cycles, categorizing status, data completeness, and required inputs.
• 2. Identify missing, inconsistent, or incomplete datasets needed to close cycles; coordinate with Programme to obtain validated data.
• 3. Clean, transform, and validate datasets following CO standard reconciliation logic.
• 4. Develop a CBT Reconciliation Dashboard (Power BI/Tableau) presenting:
  • - Open cycles
  • - Status and blockers
  • - Beneficiary transfer Status
  • - Reconciliation completeness by cycle
• 5. Build a routine operational dashboard enabling monthly reconciliation monitoring.
• 6. Document reconciliation methodology and train Programme teams in its use.
• II. In-Kind Reconciliation Support in SCOPE
• 1. Review the HQ developed IK reconciliation dashboard and identify gaps relative to DRC CO operational needs.
• 2. Adapt and localize IK dashboards to include:
  • - Commodity accounting information
  • - Dispatch vs distribution variances
  • - Missing data, losses, and anomaly detection
  • - Ensure dashboards meet both CO managerial reporting needs and IK operational requirements.
• 3. Strengthen routine IK reconciliation processes through data pipelines and automated reporting.
• III. Duplication Monitoring & DAC Support
• 1. Develop an Operational Duplication Dashboard showing, at any time:
  • - Volume of duplicates
  • - Historical vs new duplicates
  • - Severity/typology
  • - Resolution trends
• 2. Create a dashboard for the Deduplication & Adjudication Committee (DAC) showing:
  • - Workload
  • - Aging
  • - Resolution rate
  • - Quality indicators
• 3. Coordinate with Registration and SCOPE/IDM teams to ensure dashboards reflect real time dataflows.
• 4. Document business rules and contribute to CO efforts to reduce introduction of new duplicates.
• IV. Payment Instrument Tracking (PIT) Tool Enhancement
• 1. Analyse the existing PIT tool, identify sources of inaccurate payment instrument status data, and correct reporting logic.
• 2. Work with the relevant HQ team to ensure PIT dashboard with accurate reporting on:
  • - Cards issued vs distributed
  • - Failed/returned/expired instruments
  • - Items requiring field follow up
• 3. Deliver clear technical documentation and a handover package for PIT maintenance.

Deliverables

• 1. CBT Reconciliation Package
  • - Full inventory of open cycles
  • - Cleaned and validated datasets
  • - CO ready CBT reconciliation dashboard
  • - Operational dashboard for continuous monitoring
• 2. Customized IK Reconciliation Dashboard
  • - CO-aligned IK dashboard
  • - Methodology documentation
• 3. Duplication Monitoring Suite
  • - Beneficiary duplication dashboard
  • - DAC dashboard
  • - Data quality and business rules guide
• 4. Improved PIT Tool & Dashboard
  • - Corrected PIT logic
  • - Comprehensive dashboard
• 5. Capacity Strengthening Outputs
  • - Training for Programme/TEC/DAC teams
  • - Handover pack for dashboards, queries, and data models to the National Data Analyst (To be recruited)

How to Apply

All applications must be submitted exclusively through our online recruiting system. We do not consider CVs or applications sent by email, LinkedIn, or any other channel. We strongly recommend that your Workday profile is accurate and complete, and that all sections are filled in, including your employment history, academic qualifications, language skills, and UN grade (if applicable). Once your profile is completed, please apply, and submit your application. If you experience technical issues while submitting your application, you may contact us at careers@wfp.org. Please note that this email is only for technical issues with an application - unsolicited applications or documents sent to this inbox will not receive a reply. At the application stage, the only required documents are your CV and Cover Letter. Additional documents (passport, certificates, recommendation letters, etc.) may be requested later in the process. Only shortlisted candidates will be contacted and invited to proceed to the next stage of the recruitment process.