Summer 2026: Data Automation Intern… at International… · San Diego

Summary: The International Rescue Committee (IRC) responds to the world's worst humanitarian crises and is seeking a Data Automation Intern to support data management initiatives. The intern will assist in data extraction, transformation, and loading, while building automation modules to improve data reliability and support internal reporting needs. 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 Required Qualifications: - 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 Required Skills: Python, SQL, Excel automation Important Skills: Data extraction, APIs Nice-to-Have Skills: Cross-cultural communication Internship Start Date: Start in 2026 Summer 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.