Data Analyst in Tanzania

REQUEST FOR PROPOSALS # 1142318

Data Analyst in Tanzania

in support of

ELIZABETH GLASER PEDIATRIC AIDS FOUNDATION (EGPAF)

Dar es Salaam, Tanzania

Firm Deadline: Friday, September 30, 2016

5:00pm Eastern Africa Time (UTC+3)

The Elizabeth Glaser Pediatric AIDS Foundation, a non-profit organization, is the world leader in the fight to eliminate pediatric AIDS. Our mission is to prevent pediatric HIV infection and to eliminate pediatric AIDS through research, advocacy, and prevention and treatment programs. For more information, please visithttp://www.pedaids.org.

BACKGROUND

CDC Tanzania and PEPFAR have been providing technical and financial support to the Tanzania Ministry of Health, Community Development, Gender, Elderly and Children (MOHCDGEC) and National AIDS Control Program (NACP) to establish and continuously improve monitoring and evaluation (M&E) data systems, health information systems and business processes related to use of health information. CDC Tanzania has been supporting short-term and embedded technical experts to work closely with MOHCDGEC and NACP to strengthen national data systems and processes that are required to deliver quality HIV services and collect and manage information for evidence-based decisions.

In close collaboration with the MOHCDGEC, EGPAF will conduct an analysis of various Human Resources for Health (HRH) systems to inform planning and decision making. EGPAF will also conduct a spatial analysis of HRH data and its correlation with other key indicators to contribute to optimal coverage and quality of health care services. EGPAF is seeking a short-term consultant to serve as a Data Analyst who will be primarily responsible for completion of the processes and deliverables for this data analysis of HRH systems in-country, as outlined in the scope of work below.

PURPOSE/SCOPE OF WORK

Reporting to Jane Macha, EGPAF’s Technical Advisor for Health Systems Strengthening, and in close partnership with EGPAF Headquarters (HQ) and CDC Tanzania, the Data Analyst will be primarily responsible for completion of the processes and deliverables in‐country that are outlined below. The Data Analyst will also serve as a communication backstop for all in-country activities related to this activity, liaising between EGPAF HQ, MOHCDGEC, CDC Tanzania and other stakeholders.

Consultant Activities:

The Data Analyst consultant will work closely with EGPAF HQ and the EGPAF Tanzania Technical Advisor for Health Systems Strengthening to conduct the following activities:

1. Organize, participate in, and take minutes for planning meetings with MOHCDGEC and CDC Tanzania to review current HRH data management systems and to determine the necessary steps to proceed with analysis.
2. Organize and lead biweekly progress conference calls with EGPAF HQ and EGPAF Tanzania.
3. Provide monthly written progress reports to EGPAF HQ and EGPAF Tanzania to inform project quarterly reports.
4. Working closely with HRH staff from MOHCDGEC, CDC Tanzania and other US and Tanzania government agencies as needed, determine the necessary data elements needed in order to conduct a meaningful analysis for presentation to MOHCDGEC and CDC.
5. Conduct data cleaning, analysis, and prepare findings in MS Excel and Word.
6. Review any existing MOHCDGEC HRH data analysis plans and/or data use plans and advise on operationalizing them. Work with MOHCDGEC to develop plan to align/integrate various HRH data systems for future analysis and use.
7. Build capacity of MOHCDGEC on data analysis and use and how to follow analysis/use plans. This may involve designing and facilitating onsite training/mentorship to ensure continued HRH data use.
8. Act in an advisory role to MOHCDGEC in preparation for the 2016 HRH country profile, a document that is produced annually to provide a comprehensive picture of the health workforce and trends. Consultant will provide technical guidance to MOHCDGEC staff in data analysis and use.
9. Other activities as determined by EGPAF HQ and EGPAF Tanzania.

Consultant Deliverables:

The consultant will complete the following deliverables:

1. Agendas and meeting summaries from planning meetings with MOHCDGEC
2. Agendas and meeting summaries as appropriate from EGPAF HQ/Tanzania conference calls
3. Monthly written progress reports submitted to EGPAF HQ and EGPAF Tanzania Technical Advisor for Health Systems Strengthening no later than the 5th of each month
4. A written descriptive analysis and presentation containing the results of the HRH data cleaning and analysis exercise. The presentation must include a schematic of all HRH systems in Tanzania that MOHCDGEC or implementing partners are using, the nature of their use, and feasible recommendations for integrating these systems to reduce duplication and align the systems.
5. Produce one mentorship report (to be replicated by MOHCDGEC)
6. Final assignment report (template and table of contents to be provided by EGPAF HQ)

MINIMUM REQUIREMENTS

• Fluent in both written and spoken English; proficient in spoken Swahili
• At least a Master’s Degree in Public Health, Biostatistics or Computer Science, or a related field
• Able to work legally in Tanzania as a resident or through a valid work visa (must provide documentation of work visa)
• Currently reside in, or be willing to temporarily relocate to, Dar es Salaam, Tanzania for the duration of the contract period

PREFERRED QUALIFICATIONS

• Able to begin work on or before October 24, 2016
• Previous experience working in Tanzania
• Knowledge of relational databases, statistical packages, programming languages, interactive data dashboards, and Windows programs
• Experience working with senior-level representatives from donors, implementing partners, and government agencies
• A minimum of 5 years’ experience in Public Health with at least 2 years’ demonstrated practice in national level data management and analysis
• A strong background in data management systems, capacity building, and project management and implementation

EVALUATION CRITERIA AND SUBMISSION REQUIREMENTS

The Foundation will accept the proposal that presents the best value. All proposals will be evaluated against the following Evaluation Criteria. Any proposal that does not contain all items listed in the table of Submission Requirements below may be considered nonresponsive. Please submit your Submission Requirements in the order that they appear below, and label each with the RFP # 1142318.

All applicants are required to be registered and authorized to perform the scope of work in the place of performance.

Evaluation Criteria and Relative Weight:

1. Past performance of similar work, 30%
2. Consultant’s proposed process and approach to meet project needs efficiently, 35%
3. Total fixed price, 20%
4. Qualifications of proposed Consultant, 15%

**
FOUNDATION RESPONSIBILITIES**

The Data Analyst will provide all deliverables to EGPAF HQ for review and further dissemination. EGPAF HQ assumes ultimate responsibility for all documents and deliverables submitted to CDC. EGPAF HQ will directly liaise with CDC Atlanta and provide direction and support to the Consultant in the implementation of all project-related activities.

LOGISTICS

Equipment and/or Materials Required

The consultant will provide their own laptop and mobile phone for use on project-related activities.

Specific Timeframe

The period of performance for this agreement is three (3) months from the date of a signed consultant contract. Projected start date is October 24, 2016, but is subject to change. Contract may be extended at EGPAF’s option.

Location of Work

Consultant will perform all tasks in Dar es Salaam, Tanzania. Office space with access to internet and printing facilities will be provided at the Ministry of Health offices.

KEY CONTRACT TERMS

Contract Type

The anticipated contract type is fixed price plus approved expenses.

Expenses

· The following expenses will be reimbursed at cost by the Foundation only to a Consultant who is not currently a resident of Tanzania: air travel to Tanzania (one round-trip); housing allowance in Dar es Salaam; and monthly living stipend.

· Local transportation to support work-related activities will be reimbursed to all consultants, notwithstanding Tanzania residency.

· All other projected costs/expenses must be included in the fixed price proposed by the Offeror.

Equipment and Supplies

Unless stated otherwise in this RFP, the Consultant is responsible for providing equipment and/or supplies required to perform the services.

Materials and Deliverables

All deliverables provided to the Foundation must be furnished for the use of the Foundation without royalty or any additional fees.

“Materials” will include everything prepared by Consultant pursuant to this Contract, including without limitation, the Deliverables, reports, creative and other materials, manuals, studies, photographs, negatives and all other documents. All Materials developed under this Contract will be owned exclusively by the Foundation. Consultant will not use or allow the use of the Materials for any purpose other than Consultant’s performance of the Contract without the prior written consent of the Foundation.

Work Permits and Visas

The Consultant will be solely responsible for obtaining all applicable visas and/or work permits.

Supplemental Medical Coverage for Non-Local Consultants

The Foundation will provide supplemental business traveler medical coverage and security and natural disaster evacuation coverage for a non-local Consultant for the duration of the consultancy spent in Tanzania, at no cost to the Consultant, if desired. The medical coverage is supplemental only, and will only cover persons who already have general medical insurance coverage. The Offeror should indicate in the financial proposal if this coverage is requested. Note that the supplemental medical coverage is a standard benefit. The consultant therefore is not required to quote the cost of this supplemental insurance in the financial proposal, and request of this supplemental insurance will have no influence on the evaluation of proposals.

PROPOSED TIMELINE

9 September 2016 – Release of RFP

21 September 2016 – Submission of Contractual and Technical Inquiries to: Shauna Eisenberg, Senior Operations Officer, ProjectDELTA@pedaids.org. No phone calls please.

23 September 2016 – Question and Answer Response Document posted on EGPAF website athttp://www.pedaids.org/pages/contracting-opportunities.

30 September 2016 – Completed proposals must be delivered electronically by 5:00pm Eastern Africa Time (UTC+3) to: Shauna Eisenberg, Senior Operations Officer, ProjectDELTA@pedaids.org.

14 October 2016 – Final decision announced and Offerors notified

17 October 2016 – Contract executed and Services begin.

Please note it is our best intent to comply with the above timeline but unavoidable delays may occur.

ADDITIONAL INFORMATION

All proposals and communications must be identified by the unique RFP # reflected on the first page of this document. Failure to comply with this requirement may result in non-consideration of your proposal.

Any proposal not addressing each of the foregoing items may be considered non-responsive. Any exceptions to the requirements or terms of the RFP must be noted in the proposal. The Foundation reserves the right to consider any exceptions to the RFP to be non-responsive.

Late proposals may be rejected without being considered.

This RFP is not an offer to enter into agreement with any party, but rather a request to receive proposals from persons interested in providing the services outlined below. Such proposals shall be considered and treated by the Foundation as offers to enter into an agreement. The Foundation reserves the right to reject all proposals, in whole or in part, enter into negotiations with any party, and/or award multiple contracts.

The Foundation shall not be obligated for the payment of any sums whatsoever to any recipient of this RFP until and unless a written contract between the parties is executed.

Equal Opportunity Notice. The Elizabeth Glaser Pediatric AIDS Foundation is an Equal Employment Opportunity employer and represents that all qualified bidders will receive consideration without regard to race, gender, color, religion, sex, or national origin.

ETHICAL BEHAVIOR

As a core value to help achieve our mission, the Foundation embraces a culture of honesty, integrity, and ethical business practices and expects its business partners to do the same. Specifically, our procurement processes are fair and open and allow all vendors/consultants equal opportunity to win our business. We will not tolerate fraud or corruption, including kickbacks, bribes, undisclosed familial or close personal relationships between vendors and Foundation employees, or other unethical practices. If you experience of suspect unethical behavior by a Foundation employee, please contact the Foundation’s Ethics Hotline at www.reportlineweb.com/PedAids/. Any vendor/consultant who attempts to engage, or engages, in corrupt practices with the Foundation will have their proposal disqualified and will not be solicited for future work.

HOW TO APPLY:

Submission Requirements

Any proposal that does not contain all items listed in the table of Submission Requirements below may be considered nonresponsive. Please submit your Submission Requirements in the order that they appear below, and label each with the RFP # 1142318. For more detail including corresponding evaluation criteria, please see “Evaluation Criteria and Submission Requirements” section below.

1. Cover letter
2. CV/Resume of Offeror
3. Written proposal (maximum 5 pages) explaining Offeror’s specific process for completion of activities and deliverables listed in this RFP
4. Brief financial proposal detailing the Offeror’s total fixed price in U.S. dollars for all activities
5. One or more samples of prior similar work (e.g., project reports, consultancy reports, reports or evidence of prior data cleaning and analysis exercises, evidence of prior experience with data/projects, etc. for which the Offeror has led the process)
6. Current phone and email contact information for three (3) professional references from similar past projects

Submission Requirements:

1. One or more samples of prior similar work (e.g., project reports, GIS assignments, consultancy reports, reports or evidence of prior data cleaning and analysis exercises, evidence of prior experience with HRH data/projects, etc. for which the Offeror has led the process)
2. Three (3) professional references from similar past projects with current phone and email contact information
3. A maximum 5-page written proposal explaining Offeror’s specific process for completion of activities and deliverables listed in this RFP
4. A brief financial proposal detailing the total fixed price in U.S. dollars for all activities, as stated in Key Contract Terms above
5. Cover letter
6. CV/Resume of Offeror