Vaccine Data Analysis Consultant

Responsibilities

Initial Onboarding (August 2025)

• Participate in onboarding and training sessions with the ZIP team.
• Review key program documents, data tools (Excel, PowerPoint), and the program SharePoint site.

PowerBI dashboard (September 2025)

• Develop a PowerBI dashboard for internal monitoring of quarterly data.
• Meet with CORE Group to review, revise, and finalize dashboard.
• Establish a systematic repeatable process to update the dashboard with new quarterly data going forward.

Monthly Responsibilities (To be completed by the 5th of each month).

• Receive, clean, and manage monthly Key Performance Indicator (KPI) data submitted by ZIP
  grantees.
• Update pre-programmed Excel tracking tools.
• Update visuals and content in two PowerPoint slide decks: 1) ZIP Monthly Dashboard and 2)
  KPI Target Tracking Tool.

Quarterly Responsibilities (To be completed by August 30th, November 15th, and February 15th)

• Manage and clean quarterly data submissions from grantees.
• Update Excel-based tools and a PowerBI dashboard.
• Support the ZIP team in running descriptive analyses, as needed.

Additional Activities (As Needed)

• Conduct additional data cleaning and descriptive analysis using Excel.
• Create charts and graphics for internal presentations and reporting.

Skillset

• Bachelor’s degree or equivalent experience in public health, data science, statistics,
  international development, or a related field.
• Strong proficiency in Excel (including formulas, pivot tables, and charting) and PowerPoint.
• Three years of experience cleaning, structuring, and analyzing datasets.
• Previous experience creating PowerBI dashboards.
• Ability to manage recurring tasks independently and deliver on a fixed timeline.
• Excellent attention to detail and organizational skills.
• Strong communication skills and ability to collaborate remotely with a global team.
• Fluency in English.
• Personal computer with access to internet, SharePoint, and Microsoft systems.