Consultant - Information Technology Services
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
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 inMore 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.