Database Management Assistant GS5 - FTA, Stgo - Chile #121511

The Database Management Assistant, at a GS5 level, in the Fundraising area, in the partners section of the Chile office, reports to the Business Intelligence Associate, who is at a GS6 level. The Data Analysis Assistant will provide support in the generation of reports that help the Fundraising team make decisions based on data, something that is key to achieving the goals of the area.

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, a Childhood

Under the supervision of the Business Intelligence Associate, the incumbent will provide support in the processing, exploration, and segmentation of data, in addition to the construction of predictive models.

This position will help the work plan of the Fundraising area in the following ways:

• By presenting new metrics that evaluate the performance of the campaigns, it helps maximize their effectiveness
• By collaborating in the creation of predictive models, it participates in the generation of key tools for decision making
• By integrating data between systems, it allows information to remain consistent and correct

How can you make a difference?

1. Conduct data analysis obtaining data from of donors, prospects, hand-raisers, leads and any other entity relevant for fundraising
   • Identify metrics of interest for decision making
   • Detect deviations and anomalies in the data, compared to the expected values ​​and the goals established periodically
   • Segment donors, prospects, hand-raisers and leads based on the needs of the acquisition, retention, legacy, and other campaigns that are carried out by the Individual Donors team.
2. Prepare reports and data visualizations
   • Prepare the data (perform data cleansing, adjust the format, automate import processes) to be shown in reports and visualizations
   • Create reports and visualizations that are updated frequently, as requested by the Fundraising team
   • Perform maintenance tasks on reports and visualizations that are currently in use
3. Support the construction of data prediction models
   • Perform data explorations, looking for relevant patterns and variables that describe the behavior of donors, prospects, leads, and hand-raisers
   • Generate SQL data queries that obtain the required input for prediction models
   • Assist in the implementation and validation of the generated models
4. Provide support in data processing tasks
   • Build ETL processes (Extraction, Transformation and Loading) that integrate the different data sources managed by the Business Intelligence area

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

• Completion of secondary education. Desirable technical and/or university-level courses in Computer Science, Systems Engineering, Data Analysis or any another related field relevant to the post is an asset.
• A minimum of 5 of relevant professional experience in database management and data analysis.
  Technical knowledge in: SQL Server, MySQL, Azure SQL, T SQL, advanced use of MS Excel and other tools: SSRS, Power BI. Knowledge of languages R and Python is a plus.
• Fluency and excellent writing skills in Spanish are required. Proficiency in English is desirable, but not required.
• Developing country work experience and/or familiarity with emergencies is considered an asset.

For every Child, you demonstrate...

UNICEF’s Core Values of Care, Respect, Integrity, Trust and Accountability and Sustainability (CRITAS) underpin everything we do and how we do it. Get acquainted with Our Values Charter: https://uni.cf/UNICEFValues

UNICEF competencies required for this post are…

• Demonstrates Self Awareness and Ethical Awareness (1)
• Works Collaboratively with others (1)
• Builds and Maintains Partnerships (1)
• Innovates and Embraces Change (1)
• Thinks and Acts Strategically (1)
• Drive to achieve impactful results (1)
• Manages ambiguity and complexity (1)

During the recruitment process, we test candidates following the competency framework. Familiarize yourself with our competency framework and its different levels: competency framework here.

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.
We offer a wide range of benefits to our staff, including paid parental leave, breastfeeding breaks and reasonable accommodation for persons with disabilities. UNICEF strongly encourages the use of flexible working arrangements.
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 is committed to promote the protection and safeguarding of all children. All selected candidates will, therefore, undergo rigorous reference and background checks, and will be expected to adhere to these standards and principles. 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.

Remarks:

Salary Estimator Tool - This tool enables you to calculate an estimate of the various elements of your salary and provides you with an overview and estimate, so you can better understand your finances and plan for future assignments.*

*While UNDP makes every attempt to ensure that information is up-to-date and correct, we make no representations or warranties of any kind, express or implied, about the completeness, accuracy, reliability, suitability or availability with respect to the website or the information contained on the website for any purpose. Any reliance you place on such information is therefore strictly at your own risk.

UNICEF’s active commitment towards diversity and inclusion is critical to deliver the best results for children. For this position, eligible and suitable are encouraged to apply.

Mobility is a condition of international professional employment with UNICEF and an underlying premise of the international civil service.

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

UNICEF appointments are subject to medical clearance.  Issuance of a visa by the host country of the duty station, which will be facilitated by UNICEF, is required for IP positions. Appointments are also subject to inoculation (vaccination) requirements, including against SARS-CoV-2 (Covid). Government employees that are considered for employment with UNICEF are normally required to resign from their government before taking up an assignment with UNICEF. UNICEF reserves the right to withdraw an offer of appointment, without compensation, if a visa or medical clearance is not obtained, or necessary inoculation requirements are not met, within a reasonable period for any reason.