Consultant (12 months, Rome-based preferred): Data Analyst/Engineer, Individual Giving Team, Division of Private Fundraising and Partnerships (PFP)

UNICEF works in some of the world’s toughest places, to reach the world’s most disadvantaged children. To save their lives. To defend their rights. To help them fulfill their potential. 

Across 190 countries and territories, we work for every child, everywhere, every day, to build a better world for everyone. 

And we never give up. 

For every child, hope 

UNICEF is one of the most admired organizations globally, impacting the lives of children in almost every country of the world. Your work with UNICEF will enable this life-saving and critical work in the most direct way: by raising money that lets us help the most difficult to reach.  

UNICEF is at an exciting time as it expands its digital footprint, and we need great professionals to support this challenge. This role is an opportunity to take UNICEF’s fundraising to the next level. Come and help save and nurture children’s lives.  

UNICEF is looking for a Data Analyst/Engineer to work closely with selected National Committees and support UNICEF’s project to grow on a digital transformation journey to increase revenues and make an impact on children’s lives around the world. You will be supporting the Individual Giving (IG) team, Division of Private Fundraising and Partnerships (PFP), based in Geneva: a highly committed and performance-driven team responsible for overseeing a fundraising program that delivers over one billion dollars of income every year.  

How can you make a difference? 

Recently UNICEF ran a discovery process to define a new Digital Revenue Strategy to accelerate digital growth. Our vision: becoming the largest and most successful non-profit digital fundraising program in the world. This role will be crucial for achieving this ambitious goal and sits within the digital fundraising team of the Individual Giving Unit. As a data analyst/engineer you will be collaborating to build and maintain a data platform that scales with Italian National Committee’s ambitions for the fit for future initiative. You will work with blending edge tools and technologies to develop data pipelines that process data in real time and batch focusing on data quality, scalability and business requirements that drive fundraising profitability.  

Key responsibilities and main tasks include the following:  

1. GCP & GMP Ownership: creating and maintaining data tables from various data sources in Google Cloud Platform (by writing SQL) to fulfil different digital analytic use cases-based stitching, querying and visualizing the data (from data sources or endpoints of acquisition to integration to consumption for specific use cases) will be the primary responsibility of the data analyst/engineer.    

1. Drive Automation through effective metadata management: The data analyst/engineer will be responsible for using innovative and modern tools and techniques to partially or completely automate the most-common, repeatable and tedious data preparation and integration tasks for campaign optimization and marketing measurement reporting. The data analyst/engineer will also act as an internal consultant to assist with renovating the data management infrastructure to drive automation in data integration and management.  

1. Collaborate across departments: The newly hired data analyst/engineer will need strong collaboration and influential skills in order to work with varied stakeholders within the organization and also increase the level of data maturity in-house. In particular, the data analyst/engineer will work in close relationship with data science teams and with business (data) analysts in refining their data requirements for various data and analytics initiatives and their data consumption requirements.  

1. Educate and train: The data analyst/engineer should be curious and knowledgeable about new data initiatives and how to address them. This includes applying their data and/or domain understanding in addressing new data requirements. They will also be responsible for proposing appropriate (and innovative) data ingestion, preparation, integration and operationalization techniques in optimally addressing these data requirements. Lastly, the incumbent should be in a position to upskill internal teams on a day-to-day basis in using new products produced via the Google Marketing Hub Platform.  

The data analyst/engineer is expected to:  

• Act as a subject matter expert in data analytics and GCP data technologies for digital channels.  
• Work with client teams to design and implement modern, scalable data solutions using a range of new and emerging technologies from the Google Cloud Platform.  
• Work with Agile and DevOps techniques and implementation approaches in the delivery.  
• Build and deliver Data and reporting solutions using GCP products and offerings.  

Supervisor: Global Digital Manager, Individual Giving Team, based in Geneva.

Work Assignment Overview:

• GCP & GMP Ownership
• Drive Automation through effective metadata management
• Renovating the data management infrastructure
• Collaborate across departments, Educate & Train

Deliverables:

1. Develop and deliver an enterprise data platform based on a modern data stack.  

1. Deliver a reporting and modeling layer for acquisition data (GMP data, Email data, payment data, and CMS data).   

1. Drive requirements for data infrastructure for ETL from a wide variety of digital/web data sources. 

1. Build a digital performance report for all digital channels & provide actionable insights for data-driven decisions. 

1. Build bespoke data tables and models that fulfil Italy NATCOMs use cases.  

1. Educate and train internal users on the new products and resources

Timeline

By March 2023

• 5% Of Deliverables 1 
• 10% Of Deliverables 2 
• 5% Of Deliverables 3 
• 5% Of Deliverables 4 
• 10% Of Deliverables 5

By April 2023

• 5% Of Deliverables 1 
• 10% Of Deliverables 2 
• 5% Of Deliverables 3
• 5% Of Deliverables 4 
• 10% Of Deliverables 5 

 By May 2023  

• 10% Of Deliverables 1 
• 10% Of Deliverables 2 
• 10% Of Deliverables 3
• 10% Of Deliverables 4 
• 10% Of Deliverables 5 
• 10% Of Deliverables 6 

By June 2023 

• 10% Of Deliverables 1 
• 7% Of Deliverables 2 
• 10% Of Deliverables 3 
• 10% Of Deliverables 4 
• 10% Of Deliverables 5 
• 10% Of Deliverables 6 

By July 2023

• 10% Of Deliverables 1 
• 8% Of Deliverables 2 
• 10% Of Deliverables 3 
• 10% Of Deliverables 4 
• 7% Of Deliverables 5 
• 10% Of Deliverables 6

By August 2023

• 10% Of Deliverables 1 
• 7% Of Deliverables 2 
• 10% Of Deliverables 3 
• 10% Of Deliverables 4 
• 8% Of Deliverables 5 
• 10% Of Deliverables 6

By September 2023

• 5% Of Deliverables 1 
• 8% Of Deliverables 2 
• 5% Of Deliverables 3 
• 5% Of Deliverables 4 
• 7% Of Deliverables 5 
• 10% Of Deliverables 6 

By October 2023

• 10% Of Deliverables 1 
• 7% Of Deliverables 2 
• 10% Of Deliverables 3 
• 10% Of Deliverables 4 
• 8% Of Deliverables 5 
• 10% Of Deliverables 6

By November 2023

• 10% Of Deliverables 1 
• 8% Of Deliverables 2 
• 10% Of Deliverables 3 
• 10% Of Deliverables 4 
• 7% Of Deliverables 5 
• 10% Of Deliverables 6

By December 2023

• 10% Of Deliverables 1 
• 7% Of Deliverables 2 
• 10% Of Deliverables 3 
• 10% Of Deliverables 4 
• 8% Of Deliverables 5 
• 10% Of Deliverables 6 

By January 2024

• 5% Of Deliverables 1
• 8% Of Deliverables 2 
• 5% Of Deliverables 3 
• 5% Of Deliverables 4 
• 7% Of Deliverables 5 
• 10% Of Deliverables 6 

By February 2023

• 10% Of Deliverables 1 
• 10% Of Deliverables 2 
• 10% Of Deliverables 3 
• 10% Of Deliverables 4 
• 8% Of Deliverables 5 
• 10% Of Deliverables 6 

To qualify as an advocate for every child you will have... 

Education:  

A first-level university Degree in Computer science/Mathematics/Statistics/IT is required. Any other additional training in a related field is an asset.  

Experience:  

• Minimum of 5 years of relevant professional experience is required.  
• Experience in cloud technologies, in particular Google Big Query is essential.  
• Strong SQL knowledge and experience working with relational and non-relational databases.  
• Experience in building analytics dashboards and using data to drive insights for campaign optimization.  

Languages:  

• Fluency in English is required. Fluency in Italian is highly desirable.  
• Knowledge of another official UN language is considered as an asset.  

Others:  

• Keen to learn new technology, trends in the fundraising space  
• Able to explain marketing solutions and data to non-technical colleagues.

For every Child, you demonstrate... 

UNICEF's values of Care, Respect, Integrity, Trust, Accountability, and Sustainability (CRITAS). 

To view our competency framework, please visit  here. 

Remarks:  

Please indicate your all-inclusive (lump sum) fees against the deliverables listed above, including all associated administrative and travel costs (if applicable), in the cover letter. The office selects the individual based on best value for money. 

Payment of professional fees will be based on submission of agreed deliverables. UNICEF reserves the right to withhold payment in case the deliverables submitted are not up to the required standard or in case of delays in submitting the deliverables on the part of the consultant.

Only shortlisted candidates will be contacted and advance to the next stage of the selection process. 

Individuals engaged under a consultancy or individual contract will not be considered “staff members” under the Staff Regulations and Rules of the United Nations and UNICEF’s policies and procedures, and will not be entitled to benefits provided therein (such as leave entitlements and medical insurance coverage). Their conditions of service will be governed by their contract and the General Conditions of Contracts for the Services of Consultants and Individual Contractors. Consultants and individual contractors are responsible for determining their tax liabilities and for the payment of any taxes and/or duties, in accordance with local or other applicable laws. 

The selected candidate is solely responsible to ensure that the visa (applicable) and health insurance required to perform the duties of the contract are valid for the entire period of the contract. Selected candidates are subject to confirmation of fully-vaccinated status against SARS-CoV-2 (Covid-19) with a World Health Organization (WHO)-endorsed vaccine, which must be met prior to taking up the assignment. It does not apply to consultants who will work remotely and are not expected to work on or visit UNICEF premises, programme delivery locations or directly interact with communities UNICEF works with, nor to travel to perform functions for UNICEF for the duration of their consultancy contracts. 

UNICEF is here to serve the world’s most disadvantaged children and our global workforce must reflect the diversity of those children. The UNICEF family is committed to include everyone, irrespective of their race/ethnicity, age, disability, gender identity, sexual orientation, religion, nationality, socio-economic background, or any other personal characteristic.

UNICEF offers reasonable accommodation for consultants/individual contractors with disabilities. This may include, for example, accessible software, travel assistance for missions or personal attendants. We encourage you to disclose your disability during your application in case you need reasonable accommodation during the selection process and afterwards in your assignment. 

UNICEF has a zero-tolerance policy on conduct that is incompatible with the aims and objectives of the United Nations and UNICEF, including sexual exploitation and abuse, sexual harassment, abuse of authority and discrimination. UNICEF also adheres to strict child safeguarding principles. All selected candidates will be expected to adhere to these standards and principles and will therefore undergo rigorous reference and background checks. Background checks will include the verification of academic credential(s) and employment history. Selected candidates may be required to provide additional information to conduct a background check.