The IT team seeks a summer intern to join their team this summer!
The IT Data Team is seeking a summer intern to assist with data cleaning, mapping, and automating processes for Business Intelligence purposes. The intern will have the opportunity to learn basic T-SQL or apply/explore their existing knowledge of basic Python (not required). Their tasks will include preparing data for visualization for the Company to enhance existing reporting, and ensure accurate mailing data for outreach and communications, all while deepening their understanding of Holocaust history through work with information about survivors' backgrounds and current residence regions.
Tasks/Responsibilities/Specific Projects:
-
Introductory project: Apply Excel and/or SQL skills to find and correct duplicates and discrepancies in the existing reference datasets (geo, postal, historical).
-
Main projects: Clean and map the city-level data for regional survivor populations, using Excel and SQL.
-
Advanced responsibilities, if time and qualifications allow: Contribute to improving existing scripts for outlier and duplicate detection and cleaning, with a focus on geospatial data.
Length of Projects/Timeline:
The aforementioned projects require a minimum of six weeks to complete.
Skills/Experience Required:
Candidates must possess solid Microsoft Excel skills (formulas, lookups, formats) and a strong interest in data. Those with an interest in geography and/or linguistics will find our projects particularly engaging. Knowledge of French or Russian is advantageous regardless of level.
Days Expected in the Office/Remote:
Ideally, the intern will be present in the office once or twice a week (flexible). Additionally, at the onset of each project, an additional day in the office may be requested.