This will be a Nairobi-based, locally-hired specialist to carry out data management tasks under the Monitoring, Verification and Reporting Activities being carried out by Somalia Program Support Services (SPSS). International Business and Technical Consultants (IBTCI) is the contractor.
S/he will 1) develop and maintain the IP indicator Excel sheets, and 2) manage the Mobile System for Field Data Collection being implemented by SPSS, maintain the system by planning, monitoring, and improving its performance, and facilitate data analysis.
Essential Duties/Tasks and Responsibilities:
1. Management of IP Indicator Data
- In consultation with USAID and IP staff identify particular indicator and other informational needs
- Develop & maintain Excel sheet to report IP data against indicators
- Produce instructions for users
- Train IPs & USAID in consolidated indicator tracking process and tool
- Update indicator data
- Establish data quality control and protection protocols
- Analyze data & report to USAID and IPs
- Manage user access
- Receive USAID requests & clarify requirements
- Respond to report queries
2. MV&R Data Collection
- Liaise with the data collection automation contractor
- Participate in the preparation of field data collection tools and equipment
- Monitor verification data flowing into system
- Monitor compliance with the data collection protocols for each M&V tool
- Contribute towards improvement of the existing data collection protocols for the M&V tools
- Contribute to training SPSS Field Staff on Mobile System for Field Data Collection (MSFDC) tools and equipment
3. MV&R Data Quality Control
- Conduct daily QC checks of verification data, and produce output tables for data analysis / reporting
- Implement a set of data quality control protocols to ensure data quality, as well as real-time backend data check and verification of collected field data
- Be responsible for daily quality control procedures (including , but not limited to, random phone calls to check visits, and also checking data entry quality) and provide daily feedback to TPMs on error rates, specific data correction requirements
- Produce data quality reports for the MVR Manager
4. MV&R Data Management
- Develop and implement data management plans
- Ensure the MSFDC is functional on a day-to-day basis
- Troubleshoot data submission errors and data error issues
- Perform and document procedures for data preparation including data cleaning, standardization and analysis
- Regularly back up data collected using approved protocols for data storage
5. MV&R Data Reporting and Analysis
- Run daily data status reports against set targets and update the MV&R Manager
- Alert MV&R Manager within 24 hours of any data attracting initial Yellow or Red flag status
- Perform data analysis and reporting (including descriptive narratives or self-explanatory charts, graphs etc.)
- Produce weekly, monthly, annual data reports
- Develop ad-hoc reports as necessary
- Assist in defining and/or creating data listings, summary table validation, data specifications and/or process data transfers in preparation for statistical review and/or data management audit
- Participate in the preparation and presentation of data, when applicable
- Develop an internal report tracking and archiving system for SPSS
6. Other Duties
- Other related assignments that arise to implement the SPSS contract