Consultant – Microsoft Power BI and Reporting Specialist, HQ Gaza (Local) At UN Relief and Works Agency for Palestine Refugees in the Near East

CONSULTANCY – TERMS OF REFERENCE

UNRWA is a United Nations agency established by the General Assembly in 1949 and is mandated to provide assistance and protection to a population of some 5 million registered Palestine refugees. Its mission is to help Palestine refugees in Jordan, Lebanon, Syria, West Bank and the Gaza Strip to achieve their full potential in human development, pending a just solution to their plight. UNRWA’s services encompass education, health care, relief and social services, camp infrastructure and improvement, microfinance and emergency assistance. UNRWA is the largest UN operation in the Middle East with more than 30,000 staff. UNRWA is funded almost entirely by voluntary contributions

Consultant – Microsoft Power BI and Reporting Specialist, HQ Gaza (Local)**

BACKGROUND

UNRWA Information Management and Technology Department (IMTD) is seeking a Microsoft Power BI and Reporting Specialist who will be responsible for supporting the existing portfolio of deployed BI assets. Dealing with BI infrastructure issues as they arise and handling BI user requests. This will include undertaking Ad-hoc development to business user requirements and enhancements and bug fixes of existing systems. Designing and developing new Power BI reports and dashboards.

The consultant will report administratively to Field Information and Technology Officer.

Description of Duties and Responsibilities

· Work closely with the business to understand and analyse the data requirements, and translate it into user stories in the assigned sprint(s)

· Provide analytics on layering datasets in a visually compelling manner, and design prototypes

· Build new Power BI reports, dashboards, and KPI scorecards using Power BI desktop

· Review, improve, and manage the existing BI reporting solutions

· Proactively integrate new technologies for more advanced analytics including and not limited to PowerFlow, and PowerApps.

· Design and implement statistical data quality procedures around new data sources

· Perform sanity checks and unit testing of reports; participate in end-user testing for bug fixing and issues resolution.

· Liaise with other operation teams to provide recommendations on performance, security, and user interface.

· Develop documentation, training materials and conduct training sessions when needed.

· Communicate plans, status, and issues with project management.

· Perform other IMT related duties as required.

minimum Qualifications and Experience

· A university degree from an accredited educational institution in Computer Science, Information Technology, or related discipline.

· At least three years’ work experience in software applications development and implementation.

· Experience in building Reports and Dashboards using Microsoft Power BI

· Proficient with SQL, and Experienced with DAX

· Experienced in Power BI service on Microsoft Azure.

· Good Experienced in SSIS, SQL Server on Premise.

· Knowledge of the full Microsoft Analytics and Reporting stack, including SSRS, PowerPivot, PowerBuilder, PowerApps

COMPETENCIES

· Excellent in analytical thinking for translating data into informative visuals and reports

· Self-driven individual with a bias for action and a passion for analytics

· Strong client-facing written and oral communications skills

· High degree of initiative, dependability, and ability to work with little supervision.

· High level of personal integrity, as well as the ability to professionally handle confidential matters, and show an appropriate level of judgment and maturity.

· Eager to Learn & Adapt to Newer Technologies.

DESIRABLE QUALIFICATIONS

· Microsoft certifications with SSIS or other ETL tools.

CONDITIONS OF SERVICE

· The duration of the consultancy is 6 to 11 months, extendable according to performance and availability of funds.

• Remuneration for this consultancy will be 1,400 USD monthly, and it will depend on the qualifications and experience of the consultant.

· The incumbent will be based in Gaza.

APPLICATION PROCESS

Applicants should submit a cover letter and CV or UN Personal History Form clearly demonstrating the knowledge and experience required to meet the consultancy requirements via consultancy@unrwa.org indicating the title of this consultancy “**Microsoft** Power BI and Reporting Specialist, HQ Gaza (Local)” and field (area)/country of the candidate in the subject line of the message. The deadline for the submission of applications is 6 July 2021**.**

UNRWA is an equal opportunity employer and welcomes applications from both women and men. UNRWA encourages applications from qualified women. Only those applicants shortlisted for interview will be contacted. UNRWA is a non-smoking environment.

28/6/2021