[Spring 2027] High School Data and Assessment Intern

Reporting to the High School Data Manager, the Data and Assessment Intern: High School will spend 85% of their time planning, executing and analyzing assessments and 15% developing business intelligence products using our data stack. This is an exciting opportunity for someone to utilize their strong skills in planning, Google Sheets and SQL to support educational equity while gaining experience with data analysis. 25-week internship: Jan 4, 2027 - June 25, 2027. Schedule: Tuesday-Thursday, 9am-2pm EST, with additional hours during testing weeks. Hybrid, with office time split between 20 Bruckner Boulevard, Bronx, NY (10 hr/wk) and 1991 2nd Avenue, New York, NY (5 hr/wk).

Responsibilities

Create testing plans for major assessments (Finals, Regents, AP Exams, etc); Work closely with operations to prepare for and execute assessments; Enter and analyze student assessment data; Utilize Google Sheets to visualize student assessment data; Assist in creating data presentations for stakeholders; Attend Data team meetings; Use Google Sheets and SQL to support additional Data Team projects; Other duties as assigned

Requirements

Basic proficiency in Google Sheets (sum, sumif, count, countif, conditional formatting); Interest in learning data analysis or SQL; Exemplary attention to detail; Excellent organizational skills and the ability to meet deadlines in a fast-paced environment; Highly resourceful with the ability to proactively solve problems and troubleshoot in the moment; Ability to communicate effectively with school staff and other stakeholders; Impeccable integrity, including the ability to maintain a high level of confidentiality and discretion; A team player who can be relied on to get the job done; A strong belief in the mission and values of DREAM, including the belief that all students can succeed, and a deep desire to make a difference in the lives of students, families, and community

Nice to have

Intermediate proficiency in Google Sheets (Index, match, lookups, nested ifs); Data analysis or SQL background