By continuing to browse this site, you agree to our use of cookies. Read our privacy policy

Senior Data Engineer

Rome

  • Organization: WFP - World Food Programme
  • Location: Rome
  • Grade: Level not specified - Level not specified
  • Occupational Groups:
    • Engineering
    • Statistics
    • Information Technology and Computer Science
  • Closing Date: Closed

WFP seeks candidates of the highest integrity and professionalism who share our humanitarian principles.

Selection of staff is made on a competitive basis, and we are committed to promoting diversity and gender balance.

 

 

Job Title: Senior Data Engineer

Division: PPF - Private Partnerships and Fundraising Division

Administrative Duty Station: Rome, HQ – Remote working can be arranged

Type of Contract: full-time regular Consultant

Duration: 11 months

Deadline for applications: 30.01.2023

 

 

ORGANIZATIONAL CONTEXT

 

The United Nations World Food Programme (WFP) is the world’s largest humanitarian agency working to create a world with zero hunger. WFP and its partners believe that no child should go to bed hungry and that individual and collective wellbeing can only be achieved if all children, women and men get the nutritious food they need to lead healthy, dignified lives. Each year, WFP assists 90 million people in 83 countries. Every day, some 5,600 WFP-chartered trucks are on the road, 92 planes are in the air and 20 ships are at sea. These numbers speak to WFP’s unparalleled reputation as an emergency responder, one that is often the first on the scene in the most difficult environments. WFP also works with partners to strengthen the resilience of communities most vulnerable to hunger and malnutrition through long-term development programmes aimed at boosting food security, local economies, education, employment and gender equality. While hunger and malnutrition are the world’s largest solvable issues, the needs are still immense and growing. 821 million people in the world suffer from chronic hunger.

        The Private Partnerships & Fundraising Division (PPF) is responsible for working with the private sector to achieve greater impact in WFP’s work. PPF has embarked on an exceptionally ambitious new strategy to raise an additional one billion dollars for hungry or malnourished people in the next five years and to expand the contribution to WFP from the business sector through effective and sustainable long-term partnerships as well as from private individual supporters around the world. This includes securing new high impact technical partnerships, signing significant new corporate deals and growing existing relationships as well as building a base of one million individual supporters. WFP is committed to growing private sector fundraising with a focus on individual giving and have developed two products - WFP.org and ShareTheMeal (STM). Individual giving is recognized as a fundraising channel that has been successfully used by other UN agencies generating the bulk of their private sector income. The aim for WFP is to engage with supporters in their preferred channels and maximize long-term support. To help support these aims, WFP have decided to develop a Business Intelligence Hub. The mission of the Hub is to deliver data, analysis and insights to facilitate better decision making, appropriate fundraising and the best possible supporter experience.

In addition to analysis, the hub will also comprise a planning and research element to better understand supporter motivations, external market trends and to help turn data insights into actionable insights.

 

PURPOSE OF THE ASSIGNMENT

 

The purpose of this assignment is to ensure the smooth flow of data from our fundraising platforms such as Meta, Google Search, Salesforce and others into our analytics warehouse. Once in the warehouse, data needs to be transformed and made reliably available for analytical, reporting and further marketing purposes and automations. The Senior Data Engineer plays a critical role in ensuring data-led decision making is the norm as we deliver the best supporter experience possible.

 

ACCOUNTABILITIES / RESPONSIBILITIES

 

  1. Continued development of our analytics warehouse, used by Individual Fundraising teams (Share The Meal and Individual Giving) for tactical and strategic decision making.
  2. Consolidate current and new data pipelines for the Extraction, Load and Transformation of data from a variety of in-house and third-party data sources.
  3. Ensure that the data pipelines have quality assurance checks to increase data reliability and improved latency.
  4. Assemble large, complex data sets that meet business requirements. Work with data analytics experts to strive for greater functionality in our data objects.
  5. Convert algorithms, models and features into production solutions within AWS and other components of the fundraising technical stack. Ensure these data models are available in marketing platforms such as Marketing Cloud, Braze or exported where required to third party platforms.
  6. Work with analysts and optimization specialists to automate key processes of routine tasks.
  7. Build and maintain a repository of scripts and codes, ensuring best practice version control using AzureOps.
  8. Set the standards for software engineering practices within the team. Help mentor existing data analysts on efficient coding, quality assurance and software control.
  9. Work with tech teams to expand and enhance the datasets in the BI warehouse.
  10. Management of data engineer direct reports.

DELIVERABLES AT THE END OF THE CONTRACT

  • Development of a delivery roadmap. This will consist of a thorough review of existing data pipelines for efficiency and effectiveness, identification of new data sources and then a plan for prioritization.
  • This plan needs to be managed and maintained as a data engineering workstream in Asana, allowing full visibility of projects, the functionality to add new tasks and to reprioritize to meet business objectives.
  • A robust quality assurance system which can detect and then notify of any discrepancies existing across platform.
  • Comprehensive code control, ensuring that business continuity is maintained and that the warehouse produces reliable and consistent data.
  • Introduction of version control protocols and systems for the BI data analysts across their preferred platforms of Tableau and Python.

 

QUALIFICATIONS AND EXPERIENCE REQUIRED

 

Education

  • Bachelor’s degree in engineering, computer science, physics, mathematics or similar. Master’s degree preferred.

 

 

Work history

  • At least six years’ progressive experience working in a data engineer or software development role. Six years’ experience of using Python (or similar scripting language), building data warehouses and building robust ETL processes. Experience of using AWS is essential and Tableau Server is desirable.

 

Hard skills

  • Up-to-date and thorough understanding of contemporary data engineering principles and practices, including tools, techniques, processes and methods, data modeling best practices and modern data architecture.
  • Experience translating business requirements into iterative solutions and delivery of implementation.
  • Excellent SQL knowledge and strong understanding of relational databases, best practices and optimization with AWS Redshift
  • Excellent Python development skills, preferably in performing transformation and analysis of datasets, implementation of statistical and machine learning models
  • Experience with custom data transformation, data formats and normalization, preferably with dbt, parquet, avro and RESTful APIs
  • Experience of implementation and orchestration of complex data pipelines using tools such as Airbyte, Airflow, Stitchdata or similar platforms
  • Experience applying software engineering best practices to data pipelines and analytics (version control, testing, automating data QA)
  • Familiarity with marketing-based data models and CRM data is a plus (e.g. Meta Ads, Google Ads, BigQuery, Salesforce Marketing Cloud, Adjust, Braze)
  • Familiarity with user behavior data models is a plus (e.g. Google Firebase Analytics / BigQuery, Amplitude, funnel analysis)
  • Familiarity with reverse ETL, making data actionable in CRM, Analytics and marketing automation toolsExperience with privacy and data pseudonymization

 

 

Soft skills

  • People-oriented. Uses tact and courtesy to give and receive information with a variety of individuals
  • Good attention to detail and strong communication skills
  • Ability to work to deadlines and follow clear instructions.
  • Ability to think creatively and deliver on commitments.

 

Language(s)

  • Excellent command of spoken and written English
  • Intermediate knowledge of another official UN language would be a plus (Arabic, Chinese, French, Russian, Spanish).

 

 

Terms and Conditions

 

Short-listed candidates can be subject to written assessment.

WFP offers a competitive compensation package which will be determined by role’s responsibilities and deliverables. This consultancy assignment is renewable upon funding.

Visit the website for detailed information on working with WFP: http://www.wfp.org - Click on: “Our work” and “Countries” to learn more about our operations.

Qualified female applicants and qualified applicants from developing countries are especially encouraged to apply.

WFP is committed to diversity and inclusion within its workforce, and encourages all qualified candidates, irrespective of gender, nationality, religious and ethnic backgrounds, including persons living with disabilities, to apply to become a part of the Organisation. We will ensure that individuals with disabilities are provided reasonable accommodation to participate in the selection & recruitment process, and for work-related needs upon joining the Programme.

WFP has zero tolerance for discrimination and does not discriminate on the basis of HIV/AIDS status. WFP has zero tolerance for sexual exploitation and abuse, any kind of harassment, including sexual harassment, abuse of authority or discrimination. 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.

 

 

We greatly appreciate your interest in WFP and joining our mission to achieve Zero Hunger by 2030

Saving Lives, Changing Lives!

 

This vacancy is now closed.
However, we have found similar vacancies for you: