Fund Raising Associate (Data Scientist), GS6, Temporary Appointment (TA) for 12 months, Bogotá - Colombia, Post No. 136124
Apply now
Job no: 590647
Contract type: Temporary Appointment
Duty Station: Bogota
Level: G-6
Location: Colombia
Categories: Fund Raising
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,
At UNICEF COLOMBIA we work to generate positive changes in the lives of children and adolescents. Our current work plan runs from 2021 to the end of 2024 and aims to ensure that children and adolescents enjoy their rights through equitable access to social services, improve their learning and live protected from all types of violence.
We work throughout Colombia, with special focus on the departments where children have fewer opportunities: Chocó, Cauca, Nariño, Vichada, Guainía, La Guajira, Arauca and Norte de Santander.
For more information visit the following link:
https://www.youtube.com/watch?v=Bc3OopCmEpM
How can you make a difference?
Under the close supervision and guidance of the Donor Relations Officer NOA, this post undertakes the administration and control of the well-functioning of the donor’s database and supports the fundraising areas by aiding on implementation of analysis that could help to optimize the use of resources with focus in improve the retention rates and the acquisition profiling. The inclusion of security measures in hand with the standards required by UNICEF made this process even more complex and sophisticated. The number of banks accounts for local fundraising purposes also was increased in numbers (from 1 to 3) which makes more complex and diverse the bank/credit card charging. The growing database presents other challenges like the imperative task to segment the audience per behavioral variables to better retention and acquisition profiling. As well as the performance of different test and pilots that demands profound data knowledge and analysis. In addition, the current processes implied ensure the debit process reconciliation between the batch debit and the donor´s management system (currently Salesforce).
Key functions, accountabilities and related duties/tasks
1. Database management:
- Ensure & follow up the processing credit/debit card charges of individual donors (pledge and one-off givers).
- Assisting the fundraising section in processing credit/debit card charges of individual donors (pledge and one-off givers).
- Control the right importing of donor’ records between UNICEF and selected suppliers such as Face to Face agencies, call centers, Digital platformsand Online payment gateways.
- Follow the contracts related to Database management and Payments (DPO, Payment gateways, others)
- provide information to Individuals Officer and/or Donor Relations Officer for the decision making related to this process.
- Performs segmentation of the database per different criteria to allow the implementation of different telemarketing campaigns and communications targeted to different donors’ groups.
- Assist in searching and evaluating potential suppliers (Payment gateways, systems, etc)Assist in the definition of test variables and closely monitoring the results in order to define the success of those tests.
2. Support on the analysis of current donor’s data base to determine their capacity of contribution, preferences & expected life time as donor. Analyze other external sources of information to find out social trends
- Be familiar with advanced statistical, business intelligence or data mining tools of and other common computer programs (EXCEL).
- Experience in predictive modeling and advanced data analysis
- Collaborate with the development of segmentation criteria of current donor’s data base.
- Correct analysis, compilation of data and presentation of results for decision making of the retention tools currently used.
- Support in the implementation of segmentation tools (for example surveys or profiling techniques) of current donor’s data base.
- Be familiar with research methodologies (qualitative & quantitative).
- Collaborate to define different criteria for marketing analysis of current and potential donors (based on behavioral and sociodemographic factors).
- Prepares reports executed in Donor Perfect for further analysis and develop new reports according to fundraising analytic needs. This has also been increased in terms of complexity. Donors´ analytics is essential for right decision making.
3. Support on the analysis for decision making of the retention tools currently used.
- Compilation of data and presentation of results.
- Generation of insights that could be applied in drawing up communications tools to improve retention rates.
4. Provide relevant business information for the preparation of the Individual fundraising workplan
- Assist in the analysis of donor’s data base to Leverage nutrition and upgrade campaigns.
- Contribute to building donor-behavior–based loyalty plans that help generate stronger connections and increased fundraising.
FIND THE COMPLETE JOB DESCRIPTION HERE:
JD_Private Sector Fundraising Associate - GS6.pdf
- Completion of secondary education is required, supplemented with formal training level in computational Engineering, Industrial Engineering or another related field.
- A minimum of six (6) years of work experience in Data analysis, Database management, Data mining or a related field.
- For this position, a bachelor’s degree from a recognized academic institution in a relevant field may replace three years of related work experience. A master’s degree may replace additional two years.
-
Experience in the implementation of segmentation solutions. Integration of omnichannel data (CRM, digital platforms, call center, social media) and optimization of journeys and strategies based on insights.
-
Fluent in MS SQL, Advanced MS Excel user (Graphics, Pivot Tables, Advance Functions, Integration with other Databases, VBA, Macros and automation), Database: SSRS, MS SQL Report Builder, SQL Integration Services, Email Marketing Software (MailChimp, Constant Contact or similar), CRM platform (Saleforce Marketing Cloud). Tools: Power BI, Tableu, Saleforce Marketing Cloud and BigQuery.
- Fluency in English and Spanish is required. Excellent communication and writing skills in Spanish is required.
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…
- Build and maintain partnerships (L1)
- Demonstrates self-awareness and ethical awareness (L1)
- Drive for results with impact (L1)
- Innovate and embraces change (L1)
- Manage ambiguity and complexity (L1)
- Thinks and acts strategically (L1)
- Working collaboratively with others (L1)
Familiarize yourself with our competency framework and its different levels.
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.
At UNICEF Colombia, we value diversity and inclusion in our team. As part of the selection process, we would like to ensure that all candidates have equal opportunities. Please take a moment to let us know if you have a disability and what supports you require for your participation. This allows us to know what reasonable accommodations you require to ensure that you are able to participate fully and equally.
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 promoting the protection and safeguarding of all children. All selected candidates will 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.
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.
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.
Advertised: SA Pacific Standard Time
Deadline: SA Pacific Standard Time