Beirut- Database Associate G6
.
WFP celebrates and embraces diversity. It is committed to the principle of equal employment opportunity for all its employees and encourages qualified candidates to apply irrespective of race, colour, national origin, ethnic or social background, genetic information, gender, gender identity and/or expression, sexual orientation, religion or belief, HIV status or disability.
JOB DETAILS
| JOB TITLE: | BEIRUT-DATABASE ASSOCIATE |
| TYPE OF CONTRACT: | FIXED TERM |
| JOB GRADE: | GS6 |
| UNIT/ DIVISION: | IT |
| DUTY STATION: | BEIRUT, LEBANON |
| CONTRACT DURATION: | ONE YEAR WITH POSSIBILITY OF EXTENSION |
| TYPE OF VA | INTERNAL AND EXTERNAL |
| NO. OF POST/S: | ONE (1) |
ABOUT WFP
Assisting more than 130 million people in 123 countries and territories each year, the World Food Program (WFP) is the leading humanitarian organization saving lives and changing lives, delivering food assistance in emergencies partnering with governments, and providing common services that allow the entire humanitarian community to save lives in emergencies and build the resilience of food insecure people and communities.
As the international community has committed to end hunger, achieve food security and improved nutrition by 2030, one in nine people worldwide still do not have enough to eat. Food and food-related assistance lie at the heart of the struggle to break the cycle of hunger and poverty.
WFP Lebanon provides humanitarian assistance to nearly 1.1 million vulnerable persons, in the form of unrestricted assistance in-kind and cash-based transfers. WFP Lebanon also provides food assistance in the form of snack and fresh food to school aged students and their families. This support is designed to improve the students’ health and make them and their families more motivated to pursue the children’s right to education.
To know more about WFP’s mission, please check the below video:
https://www.facebook.com/WorldFoodProgramme/videos/10154930622760178
The United Nations World Food Programme is the world's largest humanitarian agency fighting hunger worldwide. The mission of WFP is to help the world achieve Zero Hunger in our lifetimes. Every day, WFP works worldwide to ensure that no child goes to bed hungry and that the poorest and most vulnerable, particularly women and children, can access the nutritious food they need.
ORGANIZATIONAL CONTEXT
The job holder reports to the lead data engineer or the designate. At this level, the job holder is expected to take responsibility for maintaining high-quality standards in the data system. This includes providing guidance to support staff, assisting with analysis and queries, transferring data between the current database and the corporate systems, and verifying data integrity through sanity checks and deduplication. Additionally, it will support the development of data systems that follow best practices and standards and might be required to document current and future database systems and contribute to developing new database systems.
JOB PURPOSE
To provide technical support on the development, maintenance, testing and implementation of a portion of IT solutions in line with business requirements.
KEY ACCOUNTABILITIES (not all-inclusive)
Within the assigned unit and delegated authority, the database associate will be responsible for the following duties:
- Designing and creating databases: This may include determining the data types and attributes for each field and the relationships between different tables.
- Implementing and populating databases: This may include writing scripts to import data from external sources and writing queries and procedures to manipulate and extract data from the database.
- Maintaining and optimising databases: This may include troubleshooting and fixing issues with the database and optimising performance and scalability.
- Providing support and training to users: This may include providing technical support to users who have questions or issues with the database and training users on how to use the database.
- Testing and debugging databases: This may include writing test cases and scripts to ensure the database functions correctly and debugging and fixing issues identified during testing.
- Documenting database design and processes: This may include creating documentation and diagrams to explain the design and structure of the database, as well as the processes and procedures used to maintain it.
- Follow data gathering and monitoring systems ensuring that rigorous quality standards are maintained.
- Contribute to the plan and deliver continuous improvement to data integration solutions, through the application of data management best practices in combination with data technology.
- Develop and improve ETLs
- Apply data sanity checks and deduplication on the database to ensure data quality
STANDARD MINIMUM QUALIFICATIONS
Education: First University degree in information technology with additional years of related work experience or trainings /courses.
Experience: At least 6 years experience in information technology.
Language: Fluency in both oral and written communication in the UN language in use at the duty station and in the duty station’s language, if different.
Knowledge and Skills: An understanding of UN systems, experience with database development using SQL Server, and familiarity with data manipulation using SQL are desired. Experience writing data manipulation scripts in Python is a plus. The ability to contribute to data design as part of a team and experience with git-flow is preferred.
FUNCTIONAL CAPABILITIES
| Capability Name | Description of the behaviour expected for the proficiency level |
| Governance, Strategy and Architecture | Demonstrates awareness of overall IT governance structure and system architecture development to support the process and assist in design of interaction between systems. |
| Change Implementation, Project Management, Planning and Optimization | Has basic understanding of project management principles to provide basic estimates on timing, resource utilisation and costs to facilitate the project planning process. |
| Technical Expertise | Continuously updates one’s own knowledge about new technologies and product modifications; Is sought out for advice/expertise and recognized internally as an important technical reference. |
| Requirement Definition & Management | Asks meaningful and appropriate questions to understand and translate business requirements into desired technical functionality. |
| System Design | Able to analyze broad product/service functionality to coordinate design of new technology or assist in technology integration/enhancements. |
| Solution Development | Designs, codes, tests, corrects, and documents programs from supplied specifications, using agreed standards and tools. |
WFP LEADERSHIP FRAMEWORK
These are the common standards of behaviour that guide HOW we work together to accomplish our mission.
| Leads by Example with Integrity | Drives Results and Delivers on Commitments | Fosters Inclusive and Collaborative Teamwork | Applies Strategic Thinking | Builds and Maintains Sustainable Partnerships |
|
Lives the WFP values and shows humanity and integrity by role modelling care for others |
Delivers on commitments and adapts readily to change |
Is inclusive and collaborative, and contributes to a culture of learning and personal growth |
Demonstrates commitment to gather perspectives, analyse options and risks, and propose new ways of doing things |
Builds and nurtures external partnerships and collaborates with partners to deliver common objectives |
Different expectations of behaviour are defined depending on your grade and role/responsibilities within WFP.
TERMS AND CONDITIONS
This position is open to qualified Lebanese candidates only.
– Women and persons with disabilities are encouraged to apply
REMINDERS BEFORE YOU SUBMIT YOUR APPLICATION
- We strongly recommend that your profile is accurate, complete and includes your employment records, academic qualifications, language skills and UN Grade (if applicable)
- Once your profile is completed, please apply, and submit your application
- Please make sure you upload your professional CV in the English language
- Kindly note the only documents you will need to submit at this time are your CV and Cover Letter
- Additional documents such as passport, recommendation letters, academic certificates, etc. may potentially be requested at a future time
- Please contact us at [email protected] in case you face any challenges with submitting your application
- Only shortlisted candidates will be notified
DEADLINE FOR APPLICATIONS
The deadline for applications is on 10 February 2023, Friday at 11:59 pm (Rome Time). Qualified candidates are required to complete an online candidate profile on UN WFP Careers Website (https://www.wfp.org/careers). Only applications received on this website are considered valid and will be processed and only shortlisted candidates will be contacted.
.
WFP has a zero-tolerance approach to conduct such as fraud, sexual exploitation and abuse, sexual harassment, abuse of authority and discrimination. All selected candidates will be expected to adhere to WFP’s standards of conduct and will therefore undergo rigorous background verification internally or through third parties. Selected candidates will also be required to provide additional information as part of the verification exercise. Misrepresentation of information provided during the recruitment process may lead to disqualification or termination of employment
WFP will not request payment at any stage of the recruitment process including at the offer stage. Any requests for payment should be refused and reported to local law enforcement authorities for appropriate action.
