DATABASE & CRM Intern

This internship offers practical experience in donor database management, CRM administration, fundraising operations and data analysis within UNHCR's Private Sector Partnerships programme in Mexico. The intern will support CRM migration, data quality, donor segmentation, and operational processes to enhance fundraising activities.

Responsibilities

• Support the CRM migration project by documenting business processes, reviewing existing data structures, assisting with data mapping and migration activities, supporting data cleansing initiatives, validating records, and contributing to user acceptance testing (UAT) and other project activities.
• Support the weekly processing of recurring donation updates in Finhub and Salesforce, including cancellations, donor retention outcomes, refunds, payment method updates and other donor record changes by performing bulk data uploads and updates while ensuring data accuracy and compliance with established procedures.
• Provide first-level support to Salesforce users from the Donor Care and Donor Development team by resolving operational tickets related to donor record updates (merges, duplicate management, tax receipt requests, user access and other CRM-related issues).
• Carry out manual data cleansing activities in Salesforce prior to the monthly programme closing to ensure data integrity and reporting accuracy.
• Perform data quality checks by comparing datasets, validating records and identifying inconsistencies using Excel, database queries and other analytical tools.
• Generate donor segmentations and prepare data extracts for donor engagement, retention and fundraising campaigns requested by different fundraising teams.
• Support the management and reconciliation of payment chargebacks across different payment platforms, including Stripe, PayPal and offline payment channels.
• Support the manual offline collection process and payment retries through bulk uploads and updates in Salesforce.
• Prepare operational reports, data extracts and routine analyses to support decision-making within the Individual Giving programme.
• Perform other related duties as required.

Requirements

• Be either a recent graduate (having completed their studies within two years of applying) or a current student in a graduate/undergraduate school programme from a university or higher education facility accredited by IAU/UNESCO.
• Have completed at least two years of undergraduate studies in a field relevant or of interest to the work of UNHCR.
• Not have exhausted the maximum cumulative internship period with UNHCR, including any prior internships (8 months for full-time and 12 months for part-time).
• Preferred fields of study include Data Science, Information Systems, Computer Science, Statistics, Business Administration, Industrial Engineering, Economics, Mathematics, Finance, Information Management, or other related disciplines.
• First Required Language is English at B2 level.
• Strong analytical and problem-solving skills.
• High attention to detail and commitment to data quality.
• Advanced knowledge of Microsoft Excel (Pivot Tables, formulas, data validation, lookups).
• Experience working with large datasets.
• Knowledge of SQL or database querying is desirable.
• Familiarity with CRM systems (preferably Salesforce) is an asset.
• Excellent written and verbal communication skills in English and Spanish.
• Good organizational and administrative skills.
• Ability to prioritize multiple tasks and work independently.
• Interest in fundraising, nonprofit organizations and humanitarian work.

Skills

• Data Analysis
• Database querying
• SQL
• CRM Administration
• Salesforce
• MS Excel
• Pivot Tables
• Data Validation
• Lookup Formulas
• Large Dataset Handling
• Donor Database Management
• Fundraising Operations
• Data Quality Assurance
• Analytical Skills
• Problem Solving
• Organizational Skills
• Administrative Skills
• Task Prioritization

Languages

English, Spanish