Business & Market Data Research Intern at American Red… · New Jersey

Summary: The American Red Cross is the world's largest humanitarian network, and they are seeking a Summer Intern for the Business & Market Data Analyst role. This internship offers undergraduate and graduate students the opportunity to gain work experience while assisting with data hygiene and enrichment activities across various datasets. Responsibilities: - Proficient in conducting online research using search engines such as Google and/or Bing - Skilled in Microsoft Excel - Market Business Data Enrichment - Conduct research to assign and validate NAICS codes associated to US business entities - Enrich company profiles with market attributes - Support segmentation enhancements - Support internal users with NAICS-related inquiries - Obtain instruction and gather inputs from stakeholders for enrichment processes and activities - Complete various online training modules related to data, and data analytics offered on Red Cross Learning site Percipio - Data Hygiene & Quality Control - Validate, clean, and standardize business customer and market data - Identify duplicate, incomplete, or inconsistent records - Support recurring audits of datasets - Document discrepancies and improvement recommendations and processes Required Qualifications: - High School or equivalent required - Internship is typically part of an undergraduate program which requires some university credit hours - Up to 1 year of related experience - Excellent written and verbal communication skills - Ability to research and analyze data to identify trends - Ability to work on a team - Ability to travel to attend meetings in person 10-20% Preferred Qualifications: - Strong skills in SQL (Structured Query Language) for data extraction, manipulation, and analysis - Experience with Excel Power Query to clean, transform, and automate data workflows - MS Access …converting Excel data sheets into MS Access tables - Data Management and Analysis using MS Access Required Skills: Data analysis, Microsoft Excel, SQL Important Skills: Data hygiene, Market research