Result of Service

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 an interview will be contacted. UNRWA is a non-smoking environment.

Work Location

Gaza

Expected duration

6 to 11 months

Duties and Responsibilities

¿ Design and development of the Data warehouse dimensional model according to the provided business requirements
¿ Design and development for the OLAP Database using SSAS database objects.
¿ Develop tabular and multidimensional models that are compatible with warehouse standards.
¿ Develop ETL packages.
¿ Design and develop reports, dashboards, and KPI scorecards using MS Power BI.
¿ Understand the business requirements and develop data models accordingly.
¿ Provide support for existing dashboards and ETLs and apply changes if needed.
¿ Create technical documentation, training materials, and conduct training sessions when needed.
¿ Performs other related duties as required.

Qualifications/special skills

Academic Qualifications:

A university degree or master’s degree from an accredited educational institution in information technology, information management, Information systems, computer science, computer engineering, Software engineering, or other related disciplines;

Experience:

¿ A minimum of 3 years of proven technical experience for a bachelor's degree or a minimum of 1 year for a master's degree in MS SQL.
¿ Bachelor’s Degree in Computer Science is highly desirable
¿ Previous experience as an ETL developer with strong data architecture knowledge around data warehousing concepts, SQL development and optimization, and operational support models.
¿ Experience with SQL Server databases as developer.


DESIRABLE QUALIFICATIONS

¿ A clear and familiar understanding of the concepts and best practices of data warehouse ETL design
¿ Demonstrated expertise around the Microsoft SQL Server technologies (primarily SSIS).

COMPETENCIES

¿ Applying technical expertise.
¿ Strong ability to drive for results, to manage and deliver against multiple priorities on time.
¿ Strong analytical and problem-solving skills.
¿ Strong interpersonal and communication skills; verbal and written.
¿ Excellent planning and organizing skills.
¿ Flexibility and adaptability.


Language:

Fluency in written and spoken English.


Contract Conditions

¿ 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,410.70 USD and depend on fund availability, qualifications, and relevant experience.
¿ The incumbent will be based in Gaza.

Additional Information

UNRWA Information Management and Technology Department (IMTD) is seeking a BI Developer to be responsible for automating data transformation using SQL server, design the data acquisition, data staging, loading, and transformation of data through ETL. This is an opportunity to make a big impact and get lots of ownership. We are looking for someone who thrives in the ownership of the product and is self-driven.

The consultant will report administratively and technically to Head Information Technology Service Centre at Headquarter Gaza.

• Please indicate if you are a Palestinian Refugee and provide your registration card number if applicable.

No Fee

THE UNITED NATIONS DOES NOT CHARGE A FEE AT ANY STAGE OF THE RECRUITMENT PROCESS (APPLICATION, INTERVIEW MEETING, PROCESSING, OR TRAINING). THE UNITED NATIONS DOES NOT CONCERN ITSELF WITH INFORMATION ON APPLICANTS’ BANK ACCOUNTS.