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 – AWS Data Engineer, (Local)
BACKGROUND
UNRWA has signed a Memorandum of Understanding (MoU) with United Nations International Computing Center (UNICC) that aims to enhance livelihood and human development opportunities to Palestine refugees. By this new collaboration, UNRWA becomes a provider of Information Management, Technology services and capacity augmentation to UNICC technical team, on a cost recovery basis through IMTD/IT Service Center (ITSC) in HQ-Gaza.
United Nations International Computing Center (UNICC) is a UN agency that provides IT services to other UN agencies on a cost recovery basis.
UNRWA Information Management and Technology Department (IMTD) is seeking an AWS Data Engineer who is well versed in AWS cloud technologies for ETL modeling, data warehouse and data lake design/building and data movement to join our expanding Data & Analytics team. This individual will be responsible for supporting existing data warehouse customers, as well as performing a senior lead role for new projects to implement various data solutions in AWS.
The consultant will report administratively to Head Information Technology Service Centre at Headquarter Gaza and technically to United Nations International Computing Center (UNICC).
Description of Duties and Responsibilities
● Participate in the project specification and software design phases.
● Design and Implement AWS architecture, AWS Solutions services and tools.
● Design Native Cloud Application Architectures or optimize applications for AWS.
● (S3, SQS, Lambda Comprehend, Transcribe, Faregate, Aurora, API GW, CFT, SAM to build a data flow pipeline).
● Collaborate within a project team to solve complex problems.
● Ensure the delivered solution meets the technical specifications and design requirements.
● Be responsible for meeting development deadlines.
● Perform other duties as required.
Minimum Qualifications and Experience
● A university degree from an accredited educational institution in Computer Science, Computer Engineering, or Information Technology or related discipline.
o For Cluster A: At least five years of relevant IT experience in Data warehousing methodologies and modelling techniques.
o For Cluster B: At least seven years of relevant IT experience in Data warehousing methodologies and modelling techniques.
● The candidate’s experience should include sufficient experience covering the following domains:
o Experience working in Massively Parallel Processing (MPP) Analytical Datastores such as Teradata
o Experience in handling semi-structured data (JSON, XML) using the VARIANT attribute in Snowflake
o Experience in creating master data datasets.
o Experience in Migration, methods to cloud data solutions
o Experience in working with Batch and Stream data
o Experience with SQL
o Hands-on experience in Cloud technologies such as
§ AWS – S3, Glacier, EC2, Lambda, SQS, Redshift, Athena, EMR, AWS Glue, AWS Lake Formation, Kinesis, AWS Batch
§ Azure – Blob Storage, Cool Blob Storage, Virtual Machine, Functions, SQL Datawarehouse, DataFactory, Databricks, CosmosDB
o Experience with ELT concepts
o Experience with ETL tools such as Informatica
o RDBMS experience
● Experience working with DevOps tools such as GitLabs, Jenkins, CodeBuild, CoePipeline CodeDeploy, etc.
● Strong Python programming skills
● Strong scripting skills: Bash Shell and PowerShell
COMPETENCIES
● Applying technical expertise.
● Strong ability to drive for results, to coordinate 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.
● Ability to learn new concepts and technologies quickly.
● Flexibility and adaptability. **
dESIRABLE QUALIFICATIONS
● Certified AWS Developer – Associate or
● AWS Certified Cloud Practitioner (Preferred, not required)
● Certified AWS DevOps – Professional (Nice to have) or
● Certified AWS Big Data Specialty (Nice to have)
● General understanding of the Snowflake architecture
● Experience with MDM tool is plus
● Experience with containers (docker)
● Experience in Hadoop, Hive, HBASE, Spark is a plus
● General understanding and hands-on experience with terraform
● Data visualization skills in Tableau or AWS QuickSight are a plus, but not required.
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 depend on the qualifications and relevant experience as follows:
o Cluster A: $1,600.
o Cluster B: $1,800.
● The incumbent can be in any of UNRWA fields of operations (Gaza, Jordan, Lebanon, Syria, or West Bank).
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 [email protected] indicating the title of this consultancy “AWS Data Engineer” and field (area)/country of the candidate in the subject line of the message. The deadline for the submission of applications is 31 March 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.
21 March 2021
How to apply
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 [email protected] indicating the title of this consultancy “AWS Data Engineer” and field (area)/country of the candidate in the subject line of the message. The deadline for the submission of applications is 31 March 2021.
