You are viewing a preview of this job. Log in or register to view more details about this job.
Email

The Claims Conference IT Data Team is seeking a summer intern to assist with data cleaning, mapping, and automating processes for Business Intelligence purposes and legacy database improvement. The intern will have the opportunity to learn basic T-SQL or apply/expand their existing knowledge of basic Python (not required). Their tasks will include preparing data for geospatial analysis and visualization for the Claims Conference 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: Correct and enhance the existing mapping of 800+ Israeli cities, moshavim, kibbutzim, and settlements to their respective regions, using Excel.

- Main projects: Enhance and finalize the existing mapping of historical countries and regions of birth to toponyms suitable for analysis; develop mapping and cleaning solutions for New York State, rest of the US, and depending on language skills, Eastern European countries, or Francophonie countries. The intern will be trained in T-SQL within a local database and provided anonymized datasets for these projects.

Advanced responsibilities, if time and qualifications allow: Contribute to improving existing scripts for outlier/issue 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 Russian, French, or Hebrew is advantageous regardless of level.

Days Expected in the Office/Remote:

Ideally, the intern will be present in our NYC office once or twice a week (flexible). Additionally, at the onset of each project, an additional day in the office may be requested.

 

The Claims Conference is an equal opportunity employer and values diversity. We do not discriminate on the basis of any category protected by law, including (without limitation) race, religion, color, national origin, gender, sexual orientation, age, marital status, veteran status, or disability status.