Overview
The Data Automation Intern will support data management initiatives focused on data extraction, transformation, and loading to enhance operational excellence and innovation.
Key Responsibilities
- Support data extraction from diverse sources including file-based data, databases, cloud storage, and APIs.
- Assist in data transformation activities such as 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 Experience
- 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.
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.
