Organization: UNICEF – United Nations Children’s Fund
Location: Santiago
Grade: Administrative support – GS-6, General Service – No need for Higher Education – Locally recruited position
Occupational Groups:
Statistics
Information Technology and Computer Science
Closing Date: 2024-11-30
Under the supervision of the Business Intelligence Officer, the Database Associate will manage the processing of accurate and timely data, ensuring data integrity and consistency across the various systems used by UNICEF.
UNICEF works in over 190 countries and territories to save children’s lives, defend their rights, and help them fulfill their potential, from early childhood through adolescence.
At UNICEF, we are committed, passionate, and proud of what we do. Promoting the rights of every child is not just a job – it is a calling.
UNICEF is a place where careers are built: we offer our staff diverse opportunities for personal and professional development that will help them develop a fulfilling career while delivering on a rewarding mission. We pride ourselves on a culture that helps staff thrive, coupled with an attractive compensation and benefits package.
Visit our website to learn more about what we do at UNICEF.
For every child, clean water
UNICEF’s fundamental mission is to promote the rights of every child, everywhere, in everything the organization does – from programs to advocacy and operations. The equity strategy, which emphasizes the most disadvantaged and excluded children and families, translates this commitment into action. For UNICEF, equity means that all children have the opportunity to survive, develop, and reach their full potential without discrimination, bias, or favoritism. Investing in the health, education, and protection of the most disadvantaged citizens contributes to the overall growth and stability of societies, accelerating progress toward the realization of children’s human rights as outlined in the Convention on the Rights of the Child.
The Database Associate will be responsible for processing accurate and timely data and overseeing PFP operation control dashboards. This ensures that relevant areas can make informed decisions while maintaining the integrity and consistency of the data in UNICEF’s systems.
How can you make a difference?
Under the supervision of the Business Intelligence Officer, the Database Associate will manage the processing of accurate and timely data, ensuring data integrity and consistency across the various systems used by UNICEF.
Key functions, accountabilities and related duties/tasks
Supervise and Update Dashboards: Oversee the publication and updating of dashboards, ensuring consistency across all dashboards.
Design and Define Reports: Create and design specific reports and dashboards related to campaign performance and regular operations to support decision-making and investment opportunities.
Ensure Data Quality: Verify the quality of data sourced from various systems, applying database uploading, maintenance criteria, and confidentiality procedures.
Database Auditing and Improvement: Develop periodic reports to audit the integrity of the database, identify inconsistencies, and suggest improvements, focusing on banking response data.
Donor Records Management: Manage the proper export and import of donor records between UNICEF systems and selected suppliers, ensuring clean and consistent data.
Coordinate with Vendors: Work closely with vendor-related areas to ensure data accuracy for vendor payments.
Data Access Management: Administer data delivery and provide access to relevant stakeholders.
Supervision and Automation: Supervise the Database Administrator, prioritizing tasks and planning improvements and automation for manual processes.
Cross-Functional Coordination: Collaborate with other areas, particularly Finance, and the Retention and Acquisition teams. Coordinate with the CRM Product Owner and Platforms Associate to ensure data quality and collection. Foster effective relationships with fundraising specialists and counterpart leaders to access key data.
This position will support the expansion of the fundraising operation by:
Ensuring efficient data management and information availability through the supervision of the Database Assistant.
Overseeing the information from different systems, ensuring data consistency.
Providing decision-makers with more accurate and detailed market analysis and reports on the Chile Country Office’s fundraising operations, identifying potential threats and opportunities.
If you would like to know more about this position, please review the complete Job Description here: JD Data Base Associate GS6 FTA.pdf
To qualify as an advocate for every child you will have…
Minimum requirements:
Education: Completion of secondary education. Technical and/or university-level courses in Systems Engineering, Marketing Analysis, or other related fields relevant to the post are an asset but not a requirement.
Work Experience: A minimum of 6 years of relevant work experience in systems database management, market research, analysis, or related functions. Experience in developing countries and/or familiarity with emergency contexts is considered an asset.
A bachelor’s degree from a recognized academic institution in a field relevant to the position may be considered to compensate for three (3) years of experience in case the candidate lacks the required experience.
A master’s degree from a recognized academic institution in a field relevant to the position may be considered to compensate for an additional two (2) years (in addition to the three years from above, totaling 5 years).
Technical knowledge: Proficiency in MS SQL and advanced Power BI user. Advanced MS Excel skills (charts, pivot tables, advanced functions, integration with other databases, VBA macros, and automation). Knowledge of SSRS, MS SQL Report Builder, R, SQL Integration Services, and email marketing software (e.g., MailChimp, ConstantContact). Salesforce experience is an asset.
Language Requirements: Fluency in English and Spanish. Excellent communication and writing skills in Spanish.
Desirables:
Developing country work experience and/or familiarity with emergency.
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: UNICEF Values
The UNICEF competencies required for this post are…
(1) Builds and maintains partnerships
(2) Demonstrates self-awareness and ethical awareness
(3) Drive to achieve results for impact
(4) Innovates and embraces change
(5) Manages ambiguity and complexity
(6) Thinks and acts strategically
(7) Works collaboratively with others
Familiarize yourself with our competency framework and its different levels.
GS-6 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 is committed to diversity and inclusion within its workforce, and encourages all candidates, irrespective of gender, nationality, religious or ethnic background, and persons with disabilities, to apply to become a part of the organization. To create a more inclusive workplace, UNICEF offers paid parental leave, breastfeeding breaks, and reasonable accommodation for persons with disabilities. UNICEF strongly encourages the use of flexible working arrangements. Click here to learn more about flexible work arrangements, well-being, and benefits.
According to the UN Convention on the Rights of Persons with Disabilities (UNCRPD), persons with disabilities include those who have long-term physical, mental, intellectual, or sensory impairments which, in interaction with various barriers, may hinder their full and effective participation in society on an equal basis with others. In its Disability Inclusion Policy and Strategy 2022-2030, UNICEF has committed to increase the number of employees with disabilities by 2030. At UNICEF, we provide reasonable accommodation for work-related support requirements of candidates and employees with disabilities. Also, UNICEF has launched a Global Accessibility Helpdesk to strengthen physical and digital accessibility. If you are an applicant with a disability who needs digital accessibility support in completing the online application, please submit your request through the accessibility email button on the UNICEF Careers webpage Accessibility | UNICEF.
UNICEF does not hire candidates who are married to children (persons under 18). 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 based on gender, nationality, age, race, sexual orientation, religious or ethnic background or disabilities. 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, and selected candidates with disabilities may be requested to submit supporting documentation in relation to their disability confidentially.
UNICEF appointments are subject to medical clearance. Issuance of a visa by the host country of the duty station is required for IP positions and will be facilitated by UNICEF. Appointments may also be subject to inoculation (vaccination) requirements, including against SARS-CoV-2 (Covid). Should you be selected for a position with UNICEF, you either must be inoculated as required or receive a medical exemption from the relevant department of the UN. Otherwise, the selection will be canceled.
Remarks:
As per Article 101, paragraph 3, of the Charter of the United Nations, the paramount consideration in the employment of the staff is the necessity of securing the highest standards of efficiency, competence, and integrity.
UNICEF’s active commitment to diversity and inclusion is critical to deliver the best results for children. For this position, eligible and suitable are encouraged to apply.
Government employees who are considered for employment with UNICEF are normally required to resign from their government positions 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.
UNICEF does not charge a processing fee at any stage of its recruitment, selection, and hiring processes (i.e., application stage, interview stage, validation stage, or appointment and training). UNICEF will not ask for applicants’ bank account information.
All UNICEF positions are advertised, and only shortlisted candidates will be contacted and advance to the next stage of the selection process. An internal candidate performing at the level of the post in the relevant functional area, or an internal/external candidate in the corresponding Talent Group, may be selected, if suitable for the post, without assessment of other candidates.
Additional information about working for UNICEF can be found here.