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 – Senior SQL Server Developer, HQ Gaza (Local)
BACKGROUND
UNRWA Information Management and Technology Department (IMTD) is seeking a Senior SQL Server Developer to work with a team responsible for automating data transformation using SQL server, while the primary responsibility of this role will be to design the data acquisition, data staging, loading, and transformation of data through ETL processes, This is an opportunity to make a big impact and get lots of ownership. We are looking for someone who thrives in the very early stages of a project and is self-driven.
Description of Duties and Responsibilities
● Put the database optimal data model in SQL Server;
● Analyze data requirements, complex source data, and the data model, and determine the best methods in extracting, transforming and loading the data into the data staging, warehouse and other system integration project;
● Create SSIS ETL packages including all available transformation components;
● Write complex SQL queries that load and make all needed transformations;
● Create web applications using ASP.Net and MS SQL Server; using .Net framework & VB.Net/C#;
● Performance tuning for slow running packages / stored procedures;
● Document all ETL and data warehouse processes and flows;
● Create or update technical documentation for transition to support teams;
● Develop automated data audit and validation processes;
● Develop and deploy ETL job workflow with reliable error/exception handling and rollback;
● Manage automation of file processing as well as all ETL processes within a job workflow;
● Develop, Contribute and adhere to the development of standards and sound procedural practices.
minimum Qualifications and Experience
● A university degree from an accredited educational institution in Computer Science, Information Technology, or related discipline.
● Minimum 4 years of proven technical expertise in MS SQL.
● 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.
● Strong complex SQL knowledge; able to write and read as well as diagnose nonperforming complex SQL.
● Knowledge of indexing and explain plans.
● Good command of spoken and written English.
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. **
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);
● Proven understanding of SQL optimization (indexing and ability to interpret and act on execution plans).
CONDITIONS OF SERVICE
· The duration of the consultancy is around 6 months, extendable according to performance and availability of funds.
· Remuneration for this consultancy will be on grade 14 (1,490.30 USD) and will depend on the qualifications and experience of the candidate.
· The incumbent will be based in Gaza.
APPLICATION PROCESS
Applicants should submit a cover letter and CV or UN Personal History Form demonstrating clearly the knowledge and experience required to meet the consultancy requirements via consultancy@unrwa.org indicating the title of this consultancy “**Senior SQL Server Developer**” in the subject line of the message. The deadline for the submission of applications is 05 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
How to apply
APPLICATION PROCESS
Applicants should submit a cover letter and CV or UN Personal History Form demonstrating clearly the knowledge and experience required to meet the consultancy requirements via consultancy@unrwa.org indicating the title of this consultancy “**Senior SQL Server Developer**” in the subject line of the message. The deadline for the submission of applications is 05 July 2021**.**