Global Health Fellows Program II
Business Intelligence/Data Analyst Intern
Supply Chain for Health Division, Office of HIV/AIDS, Bureau for Global Health, United States Agency for International Development
Anticipated timeframe: June 2016 – August 2016: Compensated 12 week internship
Location: Washington, DC/ Arlington, VA
INT-P5-011
The Global Health Fellows Program (GHFP-II) is a five year cooperative agreement implemented and managed by the Public Health Institute in partnership with Global Health Corps, GlobeMed, Management Systems International and PYXERA Global. GHFP-II is supported by the US Agency for International Development (USAID).
GHFP-II’s goal is to improve the effectiveness of USAID health programs by addressing the Agency’s immediate and emerging human capacity needs. The program seeks to accomplish this goal first through the recruitment, placement and support of diverse health professionals at the junior, mid and senior levels. These program participants include fellows, interns, corporate volunteers and Foreign Service National professionals. The program then provides substantial performance management and career development support to participants, including annual working planning assistance, and ensures that professional development opportunities are available.
Looking to the future, GHFP-II also seeks to establish a pool of highly-qualified global health professionals that will ensure the Agency’s ongoing technical leadership and effectiveness. This objective is supported by an extensive outreach program that brings global health opportunities and specialized career advice to a diverse range of interested individuals, with a particular focus on those underrepresented in the field of global health.
BACKGROUND:
USAID procures and distributes over $1 billion in health pharmaceuticals and supplies every year and invests over $200 million annually to strengthen supply chains in developing countries. With over 100 points of origin, over 50 destination countries, more than 4,000 SKUs and hundreds of shipments a year, the amount of data generated from its supply chain operation is significant. In addition, there is data residing in multiple country systems and many other data sources that further support USAID’s supply chain program. USAID is in the process of bringing online a data warehouse and business intelligence tool to house and use these disparate datasets, in the management of its supply chain programs and investments.
INTRODUCTION:
The Supply Chain for Health Division (SCH) within the Office of HIV/AIDS (OHA) in the Bureau for Global Health (GH) is seeking a Business Intelligence/Data Analyst Intern to assist the team with (1) evaluating the quality of critical datasets, (2) designing solutions to address the root causes of missing and erroneous data, (3) designing strategic reports and dashboards to support key management units within GH and (4) identifying business process improvement opportunities centered around the newly developing analytics platform. The Intern will work closely with the Senior Management Information System Advisor who will serve as his/her onsite manager.
LEARNING OBJECTIVES:
- Gaining experience in the field of the Global Health supply chain data, data mapping processes and standards, core supply chain processes, business intelligence tools, dash boarding and analytics.
- Deepening skills in collaboration and coordination within a complex organizational and implementation structure.
ROLES & RESPONSIBILITIES:
- Analyzing more than 20 supply chain datasets for data quality and identifying root causes of error through data analysis, business process review and stakeholder interviews.
- Recommending solutions to improve overall data quality (changes in processes, input automation, input masks, etc.).
- Supporting key personnel across the organization to design dashboards and reports that will provide decision-support and enable more efficient, effective and strategic management.
- Utilizing business process mapping on certain functions within USAID to recommend improvements to the process that could be made through the newly designed dashboards and reports.
- Other tasks or responsibilities may be assigned based on organizational and programming needs and/or the intern’s own interests.
QUALIFICATIONS:
- Currently enrolled master’s or other post-bachelor’s degree candidate in a program related to supply chain management, business, information systems, computer science, or relevant field; or, completion of such within the past 12 months.
- Demonstrated experience and understanding of supply chain management, procurement, and/or logistics for a large organization.
- Experience in designing and building dashboards and/or analytical reports.
- Experience with Tableau and/or MicroStrategy software preferred.
- Familiarity with data model design preferred.
- Experience with ArcGis preferred.
- Basic understanding of relational databases and query experience (SQL, etc.) preferred.
- Detail-oriented enough to mine hundreds of thousands of records for problems and insights; enough strategic thinking abilities to translate detailed data into actionable recommendations to management.
- Strong analytical skills and experience with Microsoft Excel.
- US citizenship or US permanent residency required.
COMPENSATION:
$1,690 bi-weekly (exempt, salaried position).
EmoticonEmoticon