Database Management and Statistics

Grade: F

Job ID: 13-7201

Location: HT-Port-au-Prince

# of Positions: 1

Center/Office: CPM - General

Project/Program: SCMS

Application Due Date: 2014-02-17

Overall Responsibilities

The Monitoring and Evaluation Associate will be responsible for data management, control of data quality, training and technical support to the M&E Associates assisting staff of the institutions supported by the SCMS project. It is primarily responsible for providing technical assistance to institutions supported by the project for the use of the Logistics Management Electronic Dispensation tool.

The Monitoring and Evaluation Associate will also be responsible for organizing and importing SCMS Haiti’s Excel data files composed of commodities distribution, reception, and consumption indicators into STATA. The database will constitute the proper statistical platform to performance based evaluations and assessments of the supply chain operations to improve the leadership team decision making with evidence based facts. The STATA database will allow thorough analyses to identify specific Interventions and other factors impacting SCMS-Haiti PMP and PWS measures and take proper actions. 

The Monitoring and Evaluation Associate will specifically focus his/her work on organizing the SCMS-Haiti’s Excel data files according to STATA basic database architecture to ensure consistency. Moreover, once available in STATA, he/she will structure the database by yearly waves. The database will  be organized by year, quarter, month, site, network, geographic area; and distribution, reception, consumption, work plan interventions status and processes statistics.

Specific Responsibilities

Database Management (30%)

Routine LMIS update and maintenance

• Manages the SCMS-Haiti Excel’s database on site reception, distribution and consumption in coordination with the M & E Advisor to facilitate the processing and archiving system.

Data organization and management in STATA

• With the site as the unit of observation he/she will organize the database by year, quarter, month, site, network, geographic area; and distribution, reception, consumption, work plan interventions status and processes statistics.
• Under the guidance of the M&E Advisor, creates from the project’s work plan a list of process measures and indicators that will be used.
• Create appropriate variables created from :
• Work plan process measures
• PMP and PWS measures
• Label each variable, adding notes where further information is required to convey appropriate meaning.
• Aggregate if possible the variables labeled differently over time but collected from the same data source and defined the same way.
• Ensure that the type and format of each variable is consistent with the data source.
• Define the units of measurement of each variable.
• Other duties as assigned

Statistical Analysis (30%)

• Provides technical support on health commodity supply chain logistics database and the analytic capabilities of these data.
• Collaborates with officials within and outside of the agency.
• Represents the organization on data collection and analysis matters at meetings or at other agencies.
• Develops and implements sample and instrument designs for surveys collecting data related to commodity supply chain logistics.
• Develops statistical analyses to produce unbiased estimates and estimates of variances from complex sample designs.
• Plans, designs, implements and manages the statistical analysis program of that involves routine impact studies of SCMS-Haiti Operations defined in the work plan and PMP and PWS measures.   

Coordination of LMIS Technical Assistance to networks and sites (40%)

• Discusses with site managers and network logistics advisors to propose solutions to the problems observed in the LMIS data processing and data collection forms to coordinate proper follow up with the M&E coordinators to improve the source, the quality of data.
• Designs and ensures implementation of an information distribution system guaranteeing a feedback return to sites.
• Designs procedures for quality control of data collected by site staff 
• Coordinates with the M&E coordinators regular field visits based on the validation plan defined by the M & E Advisor.
• Coordinates the technical assistance provided by the M&E coordinators to networks and sites for interpreting, handling and use of the tool Dispensation Electronics
• Ensures with the M&E coordinators proper interpretation, manipulation and use of Electronic Dispensation tools by the sites.
• Drafts recommendations to the M & E Advisor for site performance monitoring.
• Attends data validation and results analysis workshops.

Qualifications

• University degree in statistics, public health, economics, or equivalent;
• Minimum two years of experience in the field of monitoring and evaluation of projects;
• Proven experience in sampling, collecting,computing,and analyzing statistical data; and applying statistical techniques such as measurement of central tendency,dispersion,skewness,sampling error,simple and multiple correlation, analysis of variance, and tests of significance.
• Minimum three years of experience in the field of processing and analyzing data;
• Excellent computer skills: Word, Excel, PowerPoint, Access. Also knowledge of SPSS, STATA or SAS required but Excel and STATA preferred.
• Strong ability to plan,organize,supervise, monitor, analyze and communicate;
• Demonstrated skills in technical assistance and capacity building ;
• Excellent oral and written knowledge of French, English. Haitian Creole would be a plus;
• Autonomy, team spirit, strong sense of responsibility, performance and ethics;
• Ability to work under pressure and cope with the demands of deadlines.

Background Information

The Partnership for Supply Chain Management (PFSCM) is implementing the Supply Chain Management System (SCMS) contract for USAID as part of the President’s Emergency Plan for AIDS Relief. SCMS strengthens or establishes secure, reliable, cost-effective, and sustainable supply chains capable of meeting the care and treatment needs of people living with and affected by HIV and AIDS. In coordination with in-country and international partners, we assist programs to enhance their supply-chain capacity; ensure that accurate supply-chain information is collected, shared, and used; and provide quality, affordable, health care products to those who need them. The project presently has field offices in sixteen countries that provide significant technical assistance to supply chain organizations in strengthening their capacity to manage national supply chains for medicines and laboratory equipment and consumables essential to strengthening public health systems. Effective management of medical and pharmaceutical wastes is a key priority within the SCMS project and is likewise central to successful public health systems.

Notes

Only pre selected candidates will be contacted.

Apply now