Business Intelligence Assistant

Volunteering Admin IT & Telecom

Overview

Assist with data management and quality control for UNICEF's donors.

You have:

• 3 years of experience working in CRM/database
• Minimum 2 years of experience in data analysis, validation, and quality control, as well as in monitoring operational processes
• Knowledge of SQL for queries, Power Query, validations, and database management
• Intermediate to advanced proficiency in Microsoft Excel for data cleaning, validation, and analysis
• Salesforce experience is desirable
• Experience with data visualization tools such as Power BI is desirable
• Knowledge of Payment Gateways, Payment processing and API calls is desirable
• Excellent analytical skills, attention to detail, and organizational skills
• Ability to work collaboratively with internal teams and external vendors
• Ability to follow instructions, planning and organizing tasks and daily routine, analysing inconsistencies
• Interest in UNICEF's work, fundraising, volunteerism as a mechanism for development, and the United Nations system

Contract

This is a UNV contract. More about UNV contracts.

Brazil Office Individual Giving Program has 219,385 active donors and needs to collect, monitor and make the financial reconciliation of thousands of monthly transactions with banks, credit cards and utilities companies. A strong database maintenance, routines of data import and export, and specific demands or exceptions to automatic processes needs to be performed to assure the process of donations.

The UN Volunteer will perform daily tasks, and keep the database updated with personal and financial data; and assure that every donor data recorded is accurate for processing. Support in data maintenance and checking the accuracy of the data in all process, provide valuable input to keep data integrity.

Under the supervision of the Fundraising Specialist, the UN Volunteer will assist in data validation and quality control, analysis of campaign results, review of the status of the donations and pledges in Salesforce performing very detailed checking against the information we have in our Payment Gateway, and processes that contribute to optimizing the operational and analytical management of the area. They will undertake the following tasks and responsibilities:

• Daily update UNICEF database both in parts: donors’ personal data and financial data. • Manage and monitor operational processes related to Donor Care and Acquisition campaigns, contributing to the proper execution of the area's workflows. • Perform validations and quality controls on the information managed in the current CRM (Salesforce) and other systems used by the team. • Contact suppliers and telemarketing agency for the validation, reconciliation, and follow-up of information sent and received. • Verify and ensure the correct implementation of changes and updates on PSP platforms and associated systems. • Monitor and follow up with various teams on priority cases and incidents related to donors, campaigns, and operational processes. • Provide support in the development and updating of validation, control, and monitoring tools that contribute to optimizing the area's operational and analytical management. • Prepare reports and provide support in information analysis for decision-making. • Support the continuous improvement and documentation of processes related to data management and fundraising campaigns. • Perform other related tasks as required by the Business Intelligence team

KEY COMPETENCES

Builds and maintains partnerships; Demonstrates self-awareness and ethical awareness; Drive to achieve results for impact; Innovates and embraces change; Manages ambiguity and complexity; Thinks and acts strategically; Works collaboratively with others.

CORE VALUES

1. Care
2. Respect
3. Integrity
4. Trust
5. Accountability

• 3 years of experience working in CRM/database • Minimum 2 years of experience in data analysis, validation, and quality control, as well as in monitoring operational processes. • Knowledge of SQL for queries, Power Query, validations, and database management. • Intermediate to advanced proficiency in Microsoft Excel for data cleaning, validation, and analysis. • Salesforce experience is desirable. • Experience with data visualization tools such as Power BI is desirable. • Knowledge of Payment Gateways, Payment processing and API calls is desirable. • Excellent analytical skills, attention to detail, and organizational skills. • Ability to work collaboratively with internal teams and external vendors. • Ability to follow instructions, planning and organizing tasks and daily routine, analysing inconsistencies. • Interest in UNICEF's work, fundraising, volunteerism as a mechanism for development, and the United Nations system.

Brasilia is a family duty station and classified A (hardship). The living conditions in Brasilia are good as well as the access to health services. The accommodation facilities are in general good, and the choice is wide.

As this is a national UN Volunteer assignment, the UN Volunteer will be responsible for arranging their own housing and other living essentials. National UN Volunteers are part of the insurance plan.

United Nations Department of Safety and Security UNDSS Brazil advises exercising a high degree of caution in Brazil due to high levels of serious and violent crime, particularly in major cities. Violent crime as muggings, armed robbery, kidnappings, and sexual assault, is very high. Avoid shanty towns (favelas) in the big cities and if you are attacked or robbed, do not resist. Demonstrations can occur at any time and may turn violent with little or no warning. All United Nations personnel must scrupulously comply with UNDSS procedures and recommendations during their assignment in Brazil. For missions in rural areas or indigenous reservations, special procedures may apply; UN personnel should consult with the local DSS office in advance.

Specific UN Volunteer entitlements, including insurance coverage, Volunteer Living Allowance (VLA), and Deployment /Repatriation lump sums, among others, are available at https://app.unv.org/calculator . The complete UN Volunteer Conditions of Service is available at https://explore.unv.org/cos .

Apply now

Potential interview questions

Added 4 hours ago - Updated 4 hours ago - Source: unv.org