Power BI Expert
About the role
THE ORGANIZATIONAL SETTING
The International Civil Aviation Organization (ICAO) sets international Standards and Recommended Practices (SARPs) for aviation safety, air navigation, security, and environmental protection.
The ICAO, a specialized agency of the United Nations (UN), regularly receives voluntary contributions from donors to fund programmatic activities worldwide. To maintain transparency, accountability, and effective management of these funds, there is a growing need for high-quality financial and programmatic reporting tools. The organization seeks to harness the capabilities of Power BI to present complex financial data in clear, interactive, and actionable dashboards and reports for both internal and external reporting.
The objective of this consultancy is to engage a qualified Power BI expert (individual consultant or consultancy firm) to design, develop, and implement a suite of financial and programmatic reports and dashboards. These tools will serve multiple audiences, including external donors (usually national government or governmental agencies in the field of aviation) and internal project managers, finance analysts and senior management, leveraging data from existing Azure and SQL-based data warehouses.
MAJOR DUTIES AND RESPONSIBILITIES
Function1 (incl. Expected results)
Needs Assessment & Planning:
- Conduct meetings with stakeholders (including finance officers, program managers, and donor relations teams) to gather reporting requirements.
- Translate stakeholder needs into technical specifications and report design plans.
Function 2 (incl. Expected results)
Report Design and Development:
- Design Power BI dashboards and reports for three core purposes:
- Donor Reporting – Financial : Visualizations showing how donor contributions have been allocated and spent.
- Donor Reporting – Programmatic : Dashboards that highlight progress in the implementation of programmatic activities tied to specific funding, including detailed narrative input from project managers.
- Internal Project Management : Reports to support project managers in tracking expenditures, timelines, and resource allocation.
- Propose and implement visual elements that clearly convey key insights, trends, and compliance with funding agreements.
Function 3 (incl. Expected results)
Data Integration:
- Connect Power BI to existing Azure and SQL-based data warehouses.
- Ensure data is accurately queried, cleaned, and transformed to support reporting needs.
- Optimize data models for performance and usability, whilst minimizing complexity and maintenance efforts.
Function 4 (incl. Expected results)
Testing and Validation:
- Work with stakeholders to test reports and validate outputs against source systems.
- Iterate based on feedback and ensure alignment with reporting standards and donor requirements.
Function 5 (incl. Expected results)
Documentation and Handover:
- Develop comprehensive documentation, including report user guides and technical design documentation.
- Train relevant ICAO personnel in the use and maintenance of the dashboards and underlying datasets.
QUALIFICATIONS AND EXPERIENCE
Educational background
Essential
- A first-level university degree in computer science, data science, business analytics, information systems or a related field.
Desirable
- Industry certifications in Power BI, SQL, or Azure.
Professional experience and Knowledge
Essential
- Proven expertise in Power BI report and dashboard development, with a portfolio demonstrating experience in financial reporting.
- Strong understanding of Azure and SQL databases, and experience working within data warehouse environments.
- Demonstrated ability to communicate complex financial and programmatic information in visually engaging and intuitive formats.
Desirable
- Familiarity with accounting principles, financial statements, and donor reporting in an international development context.
- Experience working with or for international organizations, preferably the UN or similar governmental entities.
Language Skill
Essential
- Fluent reading, writing and speaking abilities in English.
Desirable
- A working knowledge of any other language of the Organization (Arabic, Chinese, French, Russian, Spanish).
CONDITIONS OF EMPLOYMENT
It should be noted that this post is to be filled for a period of 11 (eleven) months.
Total monthly rate for Band B varies from CAD 5,097 to CAD 8,122.
HOW TO APPLY
Interested candidates must complete an on-line application form. To apply, please visit ICAO's e-Recruitment website at: ICAO Career Website
NOTICE TO CANDIDATES
ICAO does NOT charge any fees or request money from candidates at any stage of the selection process, nor does it concern itself with bank account details of applicants. Requests of this nature allegedly made on behalf of ICAO are fraudulent and should be disregarded.
About United Nations Development Programme
The United Nations Development Programme works in nearly 170 countries and territories, helping to achieve the eradication of poverty, and the reduction of inequalities and exclusion. We help countries to develop policies, leadership skills, partnering abilities, institutional capabilities and build resilience in order to sustain development results.
DISCLAIMER: The United Nations Development Programme (UNDP) does not guarantee the truthfulness, accuracy, or validity of any comments posted to its social media outlets (blogs, social networks, message boards/forums, etc.). Users must not post any content that is obscene, defamatory, profane, libelous, threatening, harassing, abusive, hateful or embarrassing to any person or entity.
UNDP reserves the right to delete or edit any comments that it considers inappropriate or unacceptable, and to delete off-topic comments in order to foster conversations about the topics shared on this page.
Power BI Expert
About the role
THE ORGANIZATIONAL SETTING
The International Civil Aviation Organization (ICAO) sets international Standards and Recommended Practices (SARPs) for aviation safety, air navigation, security, and environmental protection.
The ICAO, a specialized agency of the United Nations (UN), regularly receives voluntary contributions from donors to fund programmatic activities worldwide. To maintain transparency, accountability, and effective management of these funds, there is a growing need for high-quality financial and programmatic reporting tools. The organization seeks to harness the capabilities of Power BI to present complex financial data in clear, interactive, and actionable dashboards and reports for both internal and external reporting.
The objective of this consultancy is to engage a qualified Power BI expert (individual consultant or consultancy firm) to design, develop, and implement a suite of financial and programmatic reports and dashboards. These tools will serve multiple audiences, including external donors (usually national government or governmental agencies in the field of aviation) and internal project managers, finance analysts and senior management, leveraging data from existing Azure and SQL-based data warehouses.
MAJOR DUTIES AND RESPONSIBILITIES
Function1 (incl. Expected results)
Needs Assessment & Planning:
- Conduct meetings with stakeholders (including finance officers, program managers, and donor relations teams) to gather reporting requirements.
- Translate stakeholder needs into technical specifications and report design plans.
Function 2 (incl. Expected results)
Report Design and Development:
- Design Power BI dashboards and reports for three core purposes:
- Donor Reporting – Financial : Visualizations showing how donor contributions have been allocated and spent.
- Donor Reporting – Programmatic : Dashboards that highlight progress in the implementation of programmatic activities tied to specific funding, including detailed narrative input from project managers.
- Internal Project Management : Reports to support project managers in tracking expenditures, timelines, and resource allocation.
- Propose and implement visual elements that clearly convey key insights, trends, and compliance with funding agreements.
Function 3 (incl. Expected results)
Data Integration:
- Connect Power BI to existing Azure and SQL-based data warehouses.
- Ensure data is accurately queried, cleaned, and transformed to support reporting needs.
- Optimize data models for performance and usability, whilst minimizing complexity and maintenance efforts.
Function 4 (incl. Expected results)
Testing and Validation:
- Work with stakeholders to test reports and validate outputs against source systems.
- Iterate based on feedback and ensure alignment with reporting standards and donor requirements.
Function 5 (incl. Expected results)
Documentation and Handover:
- Develop comprehensive documentation, including report user guides and technical design documentation.
- Train relevant ICAO personnel in the use and maintenance of the dashboards and underlying datasets.
QUALIFICATIONS AND EXPERIENCE
Educational background
Essential
- A first-level university degree in computer science, data science, business analytics, information systems or a related field.
Desirable
- Industry certifications in Power BI, SQL, or Azure.
Professional experience and Knowledge
Essential
- Proven expertise in Power BI report and dashboard development, with a portfolio demonstrating experience in financial reporting.
- Strong understanding of Azure and SQL databases, and experience working within data warehouse environments.
- Demonstrated ability to communicate complex financial and programmatic information in visually engaging and intuitive formats.
Desirable
- Familiarity with accounting principles, financial statements, and donor reporting in an international development context.
- Experience working with or for international organizations, preferably the UN or similar governmental entities.
Language Skill
Essential
- Fluent reading, writing and speaking abilities in English.
Desirable
- A working knowledge of any other language of the Organization (Arabic, Chinese, French, Russian, Spanish).
CONDITIONS OF EMPLOYMENT
It should be noted that this post is to be filled for a period of 11 (eleven) months.
Total monthly rate for Band B varies from CAD 5,097 to CAD 8,122.
HOW TO APPLY
Interested candidates must complete an on-line application form. To apply, please visit ICAO's e-Recruitment website at: ICAO Career Website
NOTICE TO CANDIDATES
ICAO does NOT charge any fees or request money from candidates at any stage of the selection process, nor does it concern itself with bank account details of applicants. Requests of this nature allegedly made on behalf of ICAO are fraudulent and should be disregarded.
About United Nations Development Programme
The United Nations Development Programme works in nearly 170 countries and territories, helping to achieve the eradication of poverty, and the reduction of inequalities and exclusion. We help countries to develop policies, leadership skills, partnering abilities, institutional capabilities and build resilience in order to sustain development results.
DISCLAIMER: The United Nations Development Programme (UNDP) does not guarantee the truthfulness, accuracy, or validity of any comments posted to its social media outlets (blogs, social networks, message boards/forums, etc.). Users must not post any content that is obscene, defamatory, profane, libelous, threatening, harassing, abusive, hateful or embarrassing to any person or entity.
UNDP reserves the right to delete or edit any comments that it considers inappropriate or unacceptable, and to delete off-topic comments in order to foster conversations about the topics shared on this page.