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
Qualifications
Required Knowledge, Skills and Abilities:
Preferably at least 3 years’ of professional experience in data management for research projects
A Bachelor’s degree in appropriate research related field
Proficiency in working with statistical and qualitative databases such as NVIVO, STATA, SPSS etc. Advanced knowledge of MS Excel, and professional use of MS Word
Demonstrated experience in successfully communicating with users to create systems that meet individual and organizational needs.
Highly motivated, willing to learn, good team work, service-oriented and able to work under high pressure and within limited time frames
Knowledge of USAID projects and terminology is desirable
Candidates must be self-motivated and quick learners
Excellent communication skills
Excellent English (written and spoken)
Minimum Requirements:
Experience:
Preferably at least 3 years’ of professional experience in data management for research projects
Proficiency in working with statistical and qualitative databases such as NVIVO, STATA, SPSS etc. Advanced knowledge of MS Excel, and professional use of MS Word
Excellent English (written and spoken)
Education:
Bachelor’s Degree required in appropriate research related field
Working Environment: Work is performed in a corporate office environment and under field conditions in all parts of Somalia.
Physical Requirements: Ability to lift up to 12.5 kilograms
Working Conditions: Work is performed in a typical corporate office environment.
Physical Requirements: Ability to lift up to twenty five pounds.
