Fall 2026: Data Integration & Reporting Intern (Unpaid)

International Rescue Committee•San Diego, CA

1d•Onsite

About The Position

The International Rescue Committee (IRC) responds to the world's worst humanitarian crises, helping to restore health, safety, education, economic wellbeing, and power to people devastated by conflict and disaster. Founded in 1933 at the call of Albert Einstein, the IRC is one of the world's largest international humanitarian non-governmental organizations (INGO), at work in more than 40 countries and 29 U.S. cities helping people to survive, reclaim control of their future and strengthen their communities. A force for humanity, IRC employees deliver lasting impact by restoring safety, dignity and hope to millions. If you're a solutions-driven, passionate change-maker, come join us in positively impacting the lives of millions of people world-wide for a better future. SCOPE OF INTERNSHIP: The Data Integration & Reporting Intern will contribute to the operational excellence and innovation of the IRC in San Diego by supporting data management initiatives focused on data extraction, transformation, and loading. The intern will assist in integrating and consolidating datasets from various sources and building automation modules using tools such as Python, SQL and Excel automation. The role includes automating recurring tasks, improving data reliability, supporting internal reporting needs, and participating in data quality checks for the Efforts to Outcomes (ETO) database and related data sources to strengthen data integrity and program reporting. LEARNING OBJECTIVES: Interns will gain expertise in data management, automation, ETL workflow and performance reporting to support decision-making in a nonprofit focused on refugees and underserved communities. Interns will improve their ability to manage and ensure data accuracy through quality control activities, while learning about CRM systems and information management used in the nonprofit sector. Interns will practice designing and presenting visual reports to effectively communicate data insights to diverse stakeholders.

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.
Ability to extract, clean, and transform datasets (e.g., reading/writing Excel and CSV files, merging tables, filtering, handling missing values).
Familiarity with APIs for retrieving data and basic data modeling concepts.
Ability to work independently and manage time effectively.
Willingness to learn about the IRC and engage in cross-cultural communication.
Must pass the IRC background check.
Applicants must currently reside in San Diego County.

Responsibilities

Support data extraction from diverse sources, including file-based data (Excel, CSV), databases, cloud storage, and system data retrieved through APIs.
Assist 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.
Assist 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.

Benefits

10 sick days
10 US holidays
20-25 paid time off days depending on role and tenure
medical insurance starting at $163 per month
dental starting at $6.50 per month
vision starting at $5 per month
FSA for healthcare and commuter costs
a 403b retirement savings plans with immediately vested matching
disability & life insurance
an Employee Assistance Program which is available to our staff and their families to support counseling and care in times of crisis and mental health struggles.