Data Analytics Intern
Assist with data collection, cleaning, analysis, and visualization
Overview
Assist with data collection, cleaning, analysis, and visualization
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.
- 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.
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 Yorkprogram office. The intern will receive first-hand experience in database management, metrics development and evaluation, and dashboard design and implementation. The intern will have theopportunity 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.
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. Position Description
Equal Opportunity Employer: We are an equal opportunity employer and value diversity at our company. We do not discriminate on the basis of race, religion, color, national origin, sex, gender, gender expression, sexual orientation, age, marital status, veteran status, or disability status. We will ensure that individuals with disabilities are provided reasonable accommodation to participate in the job application or interview process, to perform essential job functions, and to receive other benefits and privileges of employment. Please contact us to request accommodation.
Qualifications
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
• 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 a time when you had to clean a large dataset? | The interviewer is looking to assess your attention to detail and data handling skills. | Share your relevant experiences and focus on the methods you used to ensure data accuracy. |
| What techniques do you use for data analysis? | The interviewer wants to understand your familiarity and proficiency with various data analysis methods. | Pro members can see the explanation. |
| How do you prioritize tasks when working on multiple projects? | Pro members can see the explanation. | Pro members can see the explanation. |
| Can you give an example of a successful data visualization project you completed? | Pro members can see the explanation. | Pro members can see the explanation. |
| Describe a challenging problem you encountered during data analysis and how you resolved it. | Pro members can see the explanation. | Pro members can see the explanation. |