LiftmyCVLiftmyCV
PA

Consultant - Information Technology Services

Pan American Sanitary BureauOn-siteOff Site, US$66,540–$82,356 per year
AI job summary

The PAHO seeks an experienced Business Intelligence Consultant for a consultancy aimed at enhancing financial reporting and analytics within the agency. The consultant will design and implement reports and dashboards, utilizing Power BI in an ERP data environment. Responsibilities include data preparation, report development, user acceptance testing, and continuous improvement of business intelligence capabilities. The ideal candidate will have at least 7 years of experience in IT project management, a Bachelor's degree in Computer Science, and strong skills in systems analysis and data visualization.

Job description

Objective of the Office/Department

This is a requisition for employment at the Pan American Health Organization (PAHO)/Regional Office of the World Health Organization (WHO).

Contractual Agreement

Non-Staff - International PAHO Consultant

Job Posting

July 14, 2026

Closing Date

August 2, 2026, 11:59 PM Eastern Time

Primary Location

Off Site

Organization

ITS Information Technology Services

Schedule

Full time

Purpose of Consultancy

This requisition is for a consultancy at the Pan American Health Organization (PAHO)/Regional Office of the World Health Organization (WHO). PAHO aims to design, implement, and document reports and dashboards to complement and exploit the data captured in the Member State Portal to facilitate the analysis and tracking the Member State’s demand, procurement and financial activities and create an integrated reporting framework that automates the production of core financial statements from the Trial Balance and ensures consistency between financial statements, notes, and underlying accounting data. To support these objectives, PAHO intends to engage a Business Intelligence Consultant with strong expertise in financial reporting, Power BI, and ERP-based data environments.

Description of Duties

Position Type

International PAHO Consultant Band B

Duration

Estimated 5 months (from 1-Aug-2026 to 31-Dec-2026)

Pay Range

Daily rate between $258-$314

Scope of Work

Regional Revolving Funds

  • Deliverable RRF-1. Cold Chain Power BI Report: Develop Cold Chain analytics reporting to support the Cold Chain catalog/module: prepare reporting‑ready datasets and deliver a Power BI dashboard that supports the module’s decision logic (including specification capture, structured product details, and workflow concepts discussed in design sessions).

Scope

  • Data preparation in SQL / Data Warehouse
  • Structure Cold Chain catalog data so it can be stored and rendered consistently.
  • Prepare curated reporting tables/views for Cold Chain items, categories, and key attributes needed for analytics and downstream visuals.
  • Report development in Power BI
  • Build Cold Chain dashboard pages to reflect catalog/module priorities.
  • Ensure report design aligns with broader program direction and examples.
  • UAT
  • Conduct UAT with stakeholders involved in Cold Chain design and module evolution.
  • Capture issues, refine visuals/logic, and validate that the report supports the intended workflow concepts.

Claims Power BI Report

  • Deliverable RRF-2: Prepare the analytics foundation and reporting deliverable for Claims, aligned to the digitalization roadmap.

Scope

  • Data preparation in SQL / Data Warehouse
  • Translate agreed Claims process definitions and key fields into a reporting‑ready structure.
  • Prepare integration points for end‑to‑end tracking as the Claims workflow is standardized across funds (RF/SF) and teams.
  • Report development in Power BI
  • Build Claims report pages (status, volumes, root causes/categories, processing timelines, others).
  • Ensure visuals are “management‑ready” and compatible with the broader portal reporting ecosystem.
  • UAT
  • Create UAT checklist and execute UAT with cross‑functional representatives.
  • Iterate based on UAT feedback and process clarifications.

Business Intelligence Platform Enhancements

Covers recurring technical enhancements and operational support activities across the Business Intelligence platform.

Scope

  • Workday Reporting
  • Develop new Workday custom reports.
  • Modify and enhance existing Workday reports.
  • SQL & Data Warehouse Development
  • Design and develop SQL tables, views, stored procedures, and SQL Agent jobs.
  • Enhance Data Warehouse models supporting analytics and operational reporting.
  • Power BI & Reporting Support
  • Develop and enhance Power BI reports and dashboards.
  • Implement new business calculations, KPIs, and analytical features.
  • Member State Portal & Supplier Collaboration Portal Support
  • Develop backend SQL components supporting new portal functionality.
  • Support data preparation for new portal modules and reporting features.
  • Technical Operations & Production Support
  • Investigate and resolve production issues, data discrepancies, and reporting defects.
  • Technical Advisory & Continuous Improvement
  • Participate in technical workshops, design sessions, and stakeholder meetings.

Consolidation of RRF Dashboards & Reports

Addresses the consolidation and rationalization of existing RRF dashboards and reports.

Scope

  • Inventory existing RRF dashboards and reports across platforms.
  • Analyze overlaps, redundancies, and functional duplication among reports.
  • Develop recommendations for a streamlined reporting structure.

FRM

Integration of Notes to the Financial Statements

The consultant shall design and implement a structured approach to integrate the notes to the financial statements with the underlying accounting data and financial statements.

Power BI Dashboard Fine-Tuning and Visualization & Training

The consultant shall review and enhance existing monthly Power BI reports.

Qualifications and Requirements

  • 7 years of experience managing IT projects
  • Bachelor´s degree in Computer Science or related field
  • Strong background in business processes and applications
  • Strong technical skills in systems analysis and documentation
  • Proven knowledge of Business Intelligence practices
  • Fluency in English
  • Desirable: working knowledge of Spanish

Technical Skills

  • Knowledge of Azure tools and services centred around data and analytics
  • Experience as Power BI developer with Power Query, DAX, and SQL skills

Additional Information

This vacancy notice may be used to identify candidates for other similar consultancies at the same level.

Salary

  • Salary range: $258-$314 per day

Job details

Published
July 27, 2026
Job source
myworkdayjobs
Workplace
On-site · Off Site, US
First seen
July 28, 2026
AI match explained

See how well you match this job

Log in or sign up and Eva will compare your profile with this role, explain your strengths and show what to improve.

Sign up to see your matchAlready have an account? Log in

More at Pan American Sanitary Bureau

Similar jobs from this company

None listed.

Across the market

Similar jobs from other companies

Third-party content disclaimer

Full job descriptions are sourced directly from third-party applicant tracking systems (ATS), job boards, recruitment platforms, and employer career pages.

LiftmyCV does not claim ownership of this content or guarantee its accuracy or current availability. All original content is the intellectual property of the respective employers or other rights holders.

LiftmyCV hiring intelligence, availability checks, and related-job recommendations are generated from LiftmyCV data and public sources.

If you prefer, you may apply directly via the original listing for transparency.