Data Analytics Intern

Assist with data collection, cleaning, analysis, and visualization

This opening is not available anymore. Do not try to apply for this job.

IRC - The International Rescue Committee

Open positions at IRC
Logo of IRC

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.
Added 1 year ago - Updated 1 year ago - Source: rescue.org