Data Analytics Intern
Assist with data analytics for social impact projects.
Overview
Assist with data analytics for social impact projects.
You have:
- A current graduate student (or having graduated within twelve months of the internship start date) in data science, business analytics, information systems, or a related degree.
- At least one year of full-time professional experience (internship experience included) in data analysis, visualization, or a related field.
- Passion for humanitarian or social impact work.
- Advanced knowledge of Microsoft data analysis tools, such as Power BI, Power Query, and Excel, is strongly preferred.
Job Description
SCOPE OF INTERN WORK: The Data Analytics Intern will assist with the process of collecting, cleaning, analyzing, and visualizing data for the International Rescue Committee’s New York program office. The intern will receive first-hand experience in database management, metrics development and evaluation, and dashboard design and implementation. The intern will have the opportunity to network with other interns and program teams to build their problem solving and collaboration capabilities. The intern will have the opportunity to identify an area of need and design a project that furthers their interests.
RESPONSIBILITIES: • Perform data cleaning steps on large datasets. • Monitor data consistency issues, such as duplicate records, and communicate these issues to their supervisor. • Perform monthly refreshes on existing Power BI reports. • Respond to requests for data from program teams as appropriate. • Perform data analysis techniques using DAX, including calculating measures and performing joins. • Build new Power BI reports that reflect program needs when needed. • Design, build, and implement an intern-led project in the field of data analysis and visualization.
LEARNING OBJECTIVES: 1. Gain firsthand experience in data analytics in the public sector and how data can be used to scale social impact. 2. Enhance problem solving and communication capabilities by working individually and in team settings. 3. Develop leadership capability through the implementation of an intern-led project.
TITLE: Data Analytics Intern
LOCATION: Hybrid NY/Remote START DATE: 05/15/2025 DURATION: 12 weeks POSITION REPORTS TO: Data and Quality Assurance Coordinator • Knowledge of DAX, including fuzzy merges, calculated tables, and advanced measures is preferred. • Knowledge of other Power Platform tools, such as Power Automate and Power Apps, is a plus but is not required.
Qualifications
REQUIREMENTS: • A current graduate student (or having graduated within twelve months of the internship start date) in data science, business analytics, information systems, or a related degree. • At least one year of full-time professional experience (internship experience included) in data analysis, visualization, or a related field. • Passion for humanitarian or social impact work. • Advanced knowledge of Microsoft data analysis tools, such as Power BI, Power Query, and Excel, is strongly preferred.
Potential interview questions
Can you describe your experience with Power BI and how you've used it in previous projects? | The interviewer is assessing your practical experience with Power BI, which is crucial for this role. | Provide specific examples of reports you've built and the impact they had. |
How do you approach data cleaning and what tools do you use? | The interviewer wants to know your method for ensuring data integrity and the tools you're familiar with. | Pro members can see the explanation. |
Describe a time you identified a significant issue in a dataset. | Pro members can see the explanation. | Pro members can see the explanation. |
What is your understanding of DAX and its importance in data analysis? | Pro members can see the explanation. | Pro members can see the explanation. |
What would you consider a successful outcome of your internship? | Pro members can see the explanation. | Pro members can see the explanation. |
Can you provide an example of a team project you worked on and your role? | Pro members can see the explanation. | Pro members can see the explanation. |
How do you prioritize tasks when working on multiple projects simultaneously? | Pro members can see the explanation. | Pro members can see the explanation. |
Describe how you've communicated complex data findings to a non-technical audience. | Pro members can see the explanation. | Pro members can see the explanation. |