Data Base Associate - Business Intelligence, (GS-6), Mexico City, Mexico, #124081 [Temp Appointment]
Job no: 560162
Contract type: Temporary Appointment
Duty Station: Mexico City
Categories: Fund Raising
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, love
The number of suppliers (Face to Face Agencies, Call Centers, Online Payment Gateways, etc.) doing donor acquisition has increased in numbers with a subsequent growing complexity in terms of database management. The inclusion of security measures in hand with new standards required by UNICEF made these processes even more sophisticated.
The payment processes for local fundraising purposes also increased in the last 5 years, which makes more demanding and diverse the bank/credit card transaction activities.
Evolution of fundraising analysis and reports constantly developed by UNICEF made the database management and user support more complex and demanding.
For information of the work of our organization in Mexico, please visit our website: UNICEF Mexico and the video of our amazing results in 2021: Informe Anual 2021: Acciones de UNICEF - YouTube
How can you make a difference?
Under the supervision of the Fundraising Officer (Database), the Data Base Associate (BI) primary responsibility will be to work with Individual Giving team to provide data analytics and reporting to the various types of information related to donor data, such as fulfilment rates by channel, effectivity of payment methods, return of investment and campaigns’ results among others. This includes implementing solutions for optimizing and automating existing reporting as well as leveraging tools such as SQL, Power BI or Tableau to create and monitor the key performance indicators and operational metrics. Data Base Associate (BI) will also attend specific demands or exceptions related to the automatic processes generated by active donors, that contributes to the country office Individual Giving Program, which operates with a high diversification of channels and means of payment. The staff member also acts as a translator between technical and non-technical stakeholders to help them make use of the data in terms that they understand.
- Development of dashboards and reports requested by the Individual Giving area for strategic decision making using PBI, SQL, and DAX knowledge.
- Analyze raw data, dashboards and reports, perform complex quantitative analysis, assess risk and convert it into actionable business goals.
- Translate the data into insights once it’s analyzed and present it for key members of the team to understand in a meaningful and comprehensive manner.
- Collaborate with internal teams to bring ideas to achieve, set benchmarks, assess risks, and coordinate solutions with Individual Giving strategies.
- Provide individual team members with the knowledge and resources to independently understand metrics and make informed decisions.
- Support to identify critical points in the processes already implemented, through recurrent analysis, aiming constant improvements of the processes/systems and help to adapt them to what is most appropriate for the area.
To qualify as an advocate for every child you will have…
- Completion of secondary education (High School) is required, preferably supplemented by technical or university courses related to the field of work in computer sciences or database analysis. Alternatively, completion of a bachelor's degree may replace some of the required years of experience, that is if the candidate has this level of degree he/she may be considered if their relevant experience sums four years.
- A minimum 6 years of relevant work experience in business intelligence reporting or analytics and proven skills in developing real-time analysis reporting using data visualization tools.
- Fluency in Spanish.
- An intermediate level of English
You may also have the following desired education, experience, and languages, although they are not mandatory:
- Advanced SQL (Structured Query Language) knowledge
- Experience in business analytics or business intelligence in a high transaction-volume environment.
- Working with a database or CRM (customer relationship management) system.
- Salesforce platform knowledge.
- Fundraising experience.
- Fluency in English. If you do not have it and you are selected, you will have to commit to improving your English skills in the first months of work.
UNICEF constantly works for the well-being of its team. We offer:
- Hybrid work
- Flexible working hours and other flexible working arrangements
- International exposure (contact and networking with people from other UNICEF offices)
- Benefits above those provided by law in Mexico, such as 4-month parental leave for non-gestational parents and 6-month parental leave for gestational parents
- Paid vacations that are accrued after each month of work and can be taken flexibly
- The opportunity of impacting the future of children in Mexico.
- And many more, so apply now!
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
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.
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.
Non-Mexican candidates must be in possession of an existing Mexican FM3 visa or be a Mexican permanent resident/citizen.
UNICEF’s active commitment towards diversity and inclusion is critical to deliver the best results for children. For this position, eligible and suitable males are encouraged to apply.
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.
Only shortlisted candidates will be contacted and advance to the next stage of the selection process.
Advertised: Central Standard Time (Mexico)
Deadline: Central Daylight Time (Mexico)