Fall 2026: Data Integration & Reporting Intern (Unpaid)

Responsibilities

• Support data extraction from diverse sources, including file-based data (Excel, CSV), databases, cloud storage, and system data retrieved through APIs.
• Auxiliary in data transformation activities, including cleaning, structuring, and standardizing datasets.
• Perform data loading tasks into internal systems, dashboards, or databases.
• Build scripts to automate recurring tasks.
• Support ongoing improvements to internal data workflows and documentation.
• Aid in creating indicators, calculated fields, and key metrics, and in analyzing data for tracking program performance.
• Automate Excel-based tasks using advanced formulas, macros, and VBA.

Requirements

• Must be currently enrolled in or have recently completed an Associate’s, Bachelor’s, or Master’s program in a relevant field such as Information Technology, Computer Science, Statistics, Mathematics, or a related discipline.
• Experience with data processing tools, including Python (pandas, numpy, openpyxl), Microsoft Excel (advanced formulas, pivot tables, macros, VBA), and SQL.
• Familiarity with APIs for retrieving data and basic data modeling concepts.
• Ability to extract, clean, and transform datasets (e.g., reading/writing Excel and CSV files, merging tables, filtering, handling missing values).
• Ability to work independently and manage time effectively.
• Willingness to learn about the IRC and engage in cross-cultural communication.

Learning Objectives

• Gain expertise in data management, automation, ETL workflow, and performance reporting to support decision-making in a nonprofit focused on refugees and underserved communities.
• Improve ability to manage and ensure data accuracy through quality control activities.
• Learn about CRM systems and information management used in the nonprofit sector.
• Practice designing and presenting visual reports to effectively communicate data insights to diverse stakeholders.

Compensation

This is an unpaid internship opportunity.

Working Environment

The internship is offered as an in-person position. Address: 5348 University Ave, San Diego, CA 92105 Office hours are scheduled Monday-Friday, 8:30am-4:30pm PST. Selected interns can choose their hours based on this window of availability.