SUSTAINING TECHNICAL AND ANALYTIC RESOURCES
INTERN TITLE: Data Analyst Intern
HOST ORGANIZATION: Supply Chain for Health Division, Office of HIV/AIDS, Bureau of Global Health, United States Agency for International Development
LOCATION: Arlington, VA
POSITION LEVEL: Masters level
SALARY: $1,826 bi-weekly (exempt, salaried position)
ANTICIPATED TIMEFRAME: 6 Months
STAR PROGRAM DESCRIPTION
Sustaining Technical and Analytic Resources (STAR) is a project of the Public Health Institute (PHI) supported by the US Agency for International Development (USAID) Global Health (GH) Bureau. Its purpose is twofold: (1) Through individual fellowships, STAR will help strengthen the capacity of diverse American and low-and-middle-income country (LMIC) health professionals at all levels to make innovative contributions to global health (GH); and (2) STAR will create ground-breaking opportunities for both US and LMIC GH academic institutions and other groups, including professional associations, to create systems for open-access knowledge sharing, resulting in effective partnerships. STAR’s individual and institutional participants are contributing to the development of self-sustaining systems and tools that will produce global citizens with the full spectrum of relevant health competencies. STAR is managed by the Public Health Institute and implemented in partnership with Johns Hopkins University (JHU), the University of California, San Francisco (UCSF), and the Consortium of Universities for Global Health (CUGH).
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.
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 Supply Chain Health Division and receive technical guidance from Senior MIS Advisor who will serve as his/her onsite manager.
Analyze supply chain datasets for data quality and identifying root causes of error through data analysis, business process review and stakeholder interviews.
Recommend solutions to improve overall data quality (changes in processes, input automation, input masks, etc.).
Support key personnel across the division to design dashboards and reports that will provide decision-support and enable more efficient, effective and strategic management.
Utilize 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.
Create at least two Supply Chain oriented data visualizations and/or dashboards to help monitor, manage and report on the supply chain program.
Collaborate with one country to help provide greater visibility for country stock availability.
Anticipated learning outcomes: *required 10% time
Identify and describe the core attributes of the STAR global health competencies; defined as development practice, cross cultural awareness, communication, capacity strengthening, ethics of public health, health equity, gender equality and global burden of disease.
Gain 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.
Apply effective communication skills across a broad network of peers and advisors within global health to support learning and professional development.
Develop a global health focused career plan with a mentor.
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.
Experience in designing and building dashboards and/or analytical reports.
Strong analytical skills and experience with Microsoft Excel.
Detail-oriented enough to mine hundreds of thousands of records for problems and insights.
Strategic thinking abilities to translate detailed data into actionable recommendations to management.
Ability to participate in a field experience, which may involve domestic and/or international travel and overnight stays for up to 2 weeks.
US citizenship or US permanent residency required.
Additional skills (preferred):
Demonstrated experience and understanding of supply chain management, procurement, and/or logistics for a large organization.
Experience with AWS Quicksight and/or Tableau software preferred.
Familiarity with data model design preferred.
Experience with ArcGis preferred.
Basic understanding of relational databases and query experience (SQL, etc.) preferred.
SALARY AND BENEFITS
The Public Health Institute offers a comprehensive benefits package including learning programs.
All applicants are required to apply for this position through STAR’s online recruitment system at recruitment.ghstar.org, which allows you to create a profile and upload a CV/resume and cover letter. All online applications must be submitted by July 8th, 2019 by 5:00 pm Eastern time.
Public Health Institute is proud to be an EEO/AA employer.