Summer 2026: Data Automation Intern (Unpaid)

International Rescue Committee • San Diego, CA

5d • Hybrid

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. IRC BACKGROUND: Founded in 1933, the International Rescue Committee (IRC) is a leading organization providing relief, protection, and resettlement services for refugees and victims of oppression throughout the U.S. IRC in San Diego has resettled over 31,000 refugees to San Diego County over the past 51 years and provides numerous program services. In San Diego, the IRC opened its doors in 1975 and has grown to serve approximately 7,000 refugee and immigrant individuals from 115 countries of origin each year through 5 different departments. SCOPE OF INTERNSHIP: The Data Automation 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, Excel automation, and API-based data connectors. 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.

What This Job Offers

• Career Level: Intern
• Education Level: Associate degree