RESPONSIBILITIES: With oversight from the Senior Digital Inclusion Specialist, the Data Automation Intern will:
Automate Excel-based tasks using advanced formulas, macros, and VBA.
Develop scripts to streamline data processing and reporting.
Support ongoing improvements to internal data workflows and documentation.
Participate in data quality activities to ensure accuracy, consistency, and integrity across all datasets.
Use Excel pivot tables and Power BI to calculate key metrics and analyze data for tracking program performance.
Implement SharePoint to develop training sites, create materials, and set up a calendar for team coordination.
LEARNING OBJECTIVES:
Interns will gain expertise in data management and visualization 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 Data Science, Information Technology, or a related discipline.
Strong proficiency in Microsoft Excel, including pivot tables, macros, and Visual Basic for Applications (VBA); experience with Power BI and SharePoint is a plus.
Experience in data analysis, visualization, and reporting.
Strong attention to detail and ability to ensure data accuracy and integrity.
Ability to work independently and manage time effectively.
Willingness to learn about the IRC and engage in cross-cultural communication.
Ability to communicate clearly and effectively in English.
Currently residing in San Diego County and have lived locally for at least one year.
Must pass the IRC background check.
Compensation: This is an unpaid internship opportunity.
Working Environment:
The Digital Inclusion and Data Visualization Internship offers flexibility, with the opportunity to be completed remotely.
El Cajon Office hours are scheduled Monday-Friday, 8:30am-5:00pm PST. Selected interns can choose their hours based on this window of availability.
Standard of Professional Conduct:The IRC and the IRC workers must adhere to the values and principles outlined in the IRC Way – our Code of Conduct. These are Integrity, Service, Accountability, and Equality.