Data Integration & Reporting Intern (Unpaid)

The Data Integration & Reporting Intern will support 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 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.

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.

Skills

• Python
• Pandas
• NumPy
• openpyxl
• MS Excel
• Excel Advanced Formulas
• Excel Pivot Tables
• Excel Macros
• VBA Programming
• SQL
• Data Extraction
• Data Cleaning
• Data Transformation
• API data retrieval
• Data Modeling
• Data Integration
• Data Consolidation
• Automation Development
• Time Management

Languages

English