DEADLINE FOR APPLICATIONS

25 December 2024-23:59-GMT+02:00 Eastern European Time (Beirut)

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.

ABOUT WFP

The World Food Programme is the world’s largest humanitarian organization saving lives in emergencies and using food assistance to build a pathway to peace, stability and prosperity, for people recovering from conflict, disasters and the impact of climate change.

At WFP, people are at the heart of everything we do and the vision of the future WFP workforce is one of diverse, committed, skilled, and high performing teams, selected on merit, operating in a healthy and inclusive work environment, living WFP’s values (Integrity, Collaboration, Commitment, Humanity, and Inclusion) and working with partners to save and change the lives of those WFP serves.

To learn more about WFP, visit our website: https://www.wfp.org and follow us on social media to keep up with our latest news: YouTube, LinkedIn, Instagram, Facebook, Twitter, TikTok.

WHY JOIN WFP?

• WFP is a 2020 Nobel Peace Prize Laureate.
• WFP offers a highly inclusive, diverse, and multicultural working environment.
• WFP invests in the personal & professional development of its employees through a range of training, accreditation, coaching, mentorship, and other programs as well as through internal mobility opportunities.
• A career path in WFP provides an exciting opportunity to work across the various country, regional and global offices around the world, and with passionate colleagues who work tirelessly to ensure that effective humanitarian assistance reaches millions of people across the globe.
• We offer an attractive compensation package (please refer to the Terms and Conditions section of this vacancy announcement).

WFP Lebanon encourages female candidates and people with disabilities to apply.

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. WFP does not charge a fee or request bank details at any stage of the recruitment process.

WFP is dedicated to fostering diversity, equity, and inclusion. Our recruitment process is inclusively crafted to welcome candidates of all backgrounds, celebrating diversity and ensuring a respectful environment for all. We aim for an accessible and fair recruitment journey. Should you need any reasonable accommodations or have accessibility concerns, please reach out to us confidentially at lebanon.recruitment@wfp.org (and copying in global.inclusion@wfp.org). Our DEI team is here to ensure your full participation in our recruitment process.

Organizational Background:

Assisting more than 115.5 million people in 120 + countries each year, the World Food Program (WFP) is the leading humanitarian organization saving lives and changing lives, delivering food assistance in emergencies, and helping individuals and communities find life-changing solutions to the multiple challenges they face in building better futures.

In conflict situations, we bring relief to exhausted populations and use food assistance to build pathways to peace and stability – work for which WFP was awarded the Nobel Peace Prize in 2020.

WFP Lebanon provides cash assistance to Syrian refugees and in-kind assistance to vulnerable Lebanese, while supporting the Government in strengthening social safety nets. WFP supports resilience-building activities, and its school meals programme improves nutrition and school attendance. Since October 2023, WFP has provided food and cash assistance to people affected by the conflict and has scaled up its food assistance including the distribution of daily meals following the recent escalation.

To know more about WFP’s mission, please check the below video:
https://www.facebook.com/WorldFoodProgramme/videos/10154930622760178/

Contract Duration: 12 Months, (Renewable based on availability of funds, business needs and performance)

Job Purpose:

Within delegated authority and under the direct supervision of the Data Engineer, the Database Associate will be responsible 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, they 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. The incumbent will be responsible for contributing to the plan and delivering continuous improvement to data integration solutions, through the application of data management best practices in combination with data technology and developing and improving ETLs.

Key Responsibilities (not all-inclusive, nor exhaustive):

• Write data scripts in order to support the development and implementation of efficient and effective Databases components and build robots data models and logic.
• Keep up-to-date technical systems documentation for developed Data solutions in order to support systems maintenance.
• Resolve users queries independently, escalating if required, to ensure that standard IT questions are answered, and accurate information is provided.
• Maintaining and optimizing databases and testing and debugging databases
• Assist in the preparation of materials and the delivery of trainings on automated business processes to ensure efficient and effective use of Data systems.
• Collect and collate data, conduct basic analysis to support the development of accurate reports.
• Perform other related duties, as required.

Required Experiences for entry into the role:

• Proficiency with major DBMS platforms, such as Oracle, SQL Server, MySQL, PostgreSQL, and MongoDB, is required; we use Microsoft SQL Server.
• Experience in programming language such as C# and python is required
• Strong SQL (Structured Query Language) knowledge for creating and managing database structures, querying data, and optimizing performance is required.
• The ability to design and optimize database schemas, including tables, indexes, keys, and relationships between tables, is required.
• Familiarity with Entity-Relationship Diagrams (ERDs) and normalization principles is required.
• Strong analytical and problem-solving skills to identify and address database issues effectively.
• Good communication skills to collaborate with business stakeholders.
• Attention to detail to manage data integrity and accuracy.

Desired Experiences for entry into the role:

• Experience with T-SQL (Transact-SQL), PL/SQL (Procedural Language), or equivalents for stored procedures and functions
• Scripting skills in Python, Shell scripting, or PowerShell for database automation tasks
• Experience with Microsoft Azure DevOps, including Azure Pipelines and release management,
• Skills in query optimization, indexing strategies, and troubleshooting slow queries
• Experience using performance monitoring tools for databases like SQL Server Profiler
• Knowledge of ETL (Extract, Transform, Load) tools such as SSIS (SQL Server Integration Services)
• Understanding of database security best practices such as role-based access control, encryption, and auditing
• Knowledge of data masking, encryption standards, and user authentication mechanisms

STANDARD MINIMUM ACADEMIC QUALIFICATIONS:

Education: Completion of secondary school education. University degree in computer science, computer engineering, information technology, or any related field.

Experience: At least six (6) years of experience in one of the topics: Data analysis, Database development, Database administration, data engineering, and or worked as a software developer with some experience in bulk data processing.

Language: Fluency in both oral and written communication in English and Arabic. Knowledge of French language is an added advantage.

WFP Leadership Framework: Common Standards of Behaviour

• Leads by Example with Integrity
  • Upholds WFP values, principles, and standards
  • Respects others and values diversity
  • Stays focused and calm under pressure
  • Demonstrates humility and a willingness to learn
• Drives Results and Delivers on Commitments
  • Delivers results for maximum impact
  • Delegates appropriately
  • Adapts readily to change
• Fosters Inclusive and Collaborative
  • Is inclusive and collaborative
  • Gives timely and constructive feedback
  • Builds and shares new perspective
• Applies Strategic Thinking
  • Communicates and fulfils WFP’s vision
  • Embraces curiosity and new ways of doing things
  • Analyses and evaluates data
  • Considers the impact of decisions
• Builds and Maintains Sustainable Partnerships
  • Collaborates to deliver common objectives

Terms and Conditions:

• WFP offers a competitive benefits package including salary, various types of leaves including maternity and paternity, medical and life insurances, provision of breastfeeding rooms for new parents, and various wellness platforms.
• WFP Lebanon offers flexible working hours schedule upon prior approval.
• Our premises are accessible, and we are committed to accommodate to any required reasonable accessible needs to remove barriers in the workplace.
• Only shortlisted applicants will be contacted.

WFP LEADERSHIP FRAMEWORK

WFP Leadership Framework guides to the common standards of behavior that guide HOW we work together to accomplish our mission.

Click here to access WFP Leadership Framework

REASONABLE ACCOMMODATION

WFP is dedicated to fostering diversity, equity, and inclusion. Our recruitment process is inclusively crafted to welcome candidates of all backgrounds, celebrating diversity and ensuring a respectful environment for all. We aim for an accessible and fair recruitment journey. Should you need any reasonable accommodations or have accessibility concerns, please reach out to us confidentially at global.inclusion@wfp.org. Our DEI team is here to ensure your full participation in our recruitment process.

NO FEE DISCLAIMER

The United Nations does not charge any application, processing, training, interviewing, testing or other fee in connection with the application or recruitment process. Should you receive a solicitation for the payment of a fee, please disregard it. Furthermore, please note that emblems, logos, names and addresses are easily copied and reproduced. Therefore, you are advised to apply particular care when submitting personal information on the web.

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 global.hrerecruitment@wfp.org in case you face any challenges with submitting your application
• Only shortlisted candidates will be notified

All employment decisions are made on the basis of organizational needs, job requirements, merit, and individual qualifications. WFP is committed to providing an inclusive work environment free of sexual exploitation and abuse, all forms of discrimination, any kind of harassment, sexual harassment, and abuse of authority. Therefore, all selected candidates will undergo rigorous reference and background checks.

No appointment under any kind of contract will be offered to members of the UN Advisory Committee on Administrative and Budgetary Questions (ACABQ), International Civil Service Commission (ICSC), FAO Finance Committee, WFP External Auditor, WFP Audit Committee, Joint Inspection Unit (JIU) and other similar bodies within the United Nations system with oversight responsibilities over WFP, both during their service and within three years of ceasing that service.

Level of Education: Bachelor Degree

Work Hours: 8

Experience in Months: No requirements