Overview
Develop a working Evaluation Portal as a single Power Apps canvas app over the DIP Azure SQL database. The portal will be viewable by all UN-Habitat staff and will include a tracking side for accountability and a learning side for lessons learned.
Key Responsibilities
- Develop a single canvas app holding both the tracking side (evaluations, recommendations, workplan) and the learning side (report and lessons library).
- Reads from enriched SQL views; writes to base tables through stored procedures called via Power Automate.
- Edit-lock so recommendations and workplan are editable only by an evaluation's linked people, and by IEU and Admin.
- Open viewing for all staff, with a default “My Evaluations” filter to improve the experience.
- Develop Library with fast filtering on meta data (region, country, cluster, year, type, timing, language) and author-only editing.
- Create scheduled six-month reminder flow on recommendations after MR endorsement, until implemented or closed as non-compliant.
- Advise on other workflows that support efficient knowledge management
- Advise on library and access or link to actual reports
- Develop Read-only Power BI dashboards for recommendation status and ongoing evaluations.
Required Experience
At least two (2) years experience in use of Power Apps canvas app development. Azure SQL: tables, views, stored procedures and indexing. Power Automate for scheduled flows and procedure calls. Power BI dashboards is required. The consultant should have built at least one similar App and Dashboard in the UN Secretariat or similar organization is required.
Qualifications
An advanced university degree (master's degree or equivalent) in Information Technology, software engineering, computer studies, similar relevant fields is required. A first-level university degree (bachelor's degree or equivalent) in combination with an additional two (2) years of qualifying experience may be accepted in lieu of the advanced university degree.
