Fall 2025: Data Automation Intern (Unpaid)
Contribute to the Digital Inclusion Program as a Data Automation Intern.
This opening is not available anymore.
Do not try to apply for this job.
Overview
Contribute to the Digital Inclusion Program as a Data Automation Intern.
You have:
- 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.
Job Description
SCOPE OF INTERNSHIP: In this internship, students will contribute to the Digital Inclusion Program, which helps refugees, newcomers, and low-income families develop essential digital skills to improve their lives and job opportunities. We are looking for a detail-oriented and technically skilled Data Automation Intern to support the development and optimization of automated tools and workflows. The internship will focus on improving data handling processes through Excel automation, macros, and programming tools such as VBA and Python.
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.
Qualifications
Potential interview questions
| Describe a time when you used Excel automation to improve a process. | This question assesses your practical experience with Excel and problem-solving skills. | Provide a specific example where your use of Excel automation led to improved efficiency. |
| How do you ensure the accuracy and integrity of your data analysis? | This question evaluates your attention to detail and data management skills. | Pro members can see the explanation. |
| Can you explain a project where you used data visualization to convey insights? | Pro members can see the explanation. | Pro members can see the explanation. |
| What strategies do you use to manage your time when working on multiple projects? | Pro members can see the explanation. | Pro members can see the explanation. |
| Tell me about a situation where you had to communicate complex information to a non-technical audience. | Pro members can see the explanation. | Pro members can see the explanation. |
| How would you approach learning a new software tool, like SharePoint? | Pro members can see the explanation. | Pro members can see the explanation. |
| Describe a time when you worked in a culturally diverse team. | Pro members can see the explanation. | Pro members can see the explanation. |
| What motivates you to work with underserved communities? | Pro members can see the explanation. | Pro members can see the explanation. |
Added 11 months ago
-
Updated 10 months ago
-
Source:
rescue.org
