PRODUCT DATA & ANALYTICS INTERN

Founded in 2009 in Orange County, California, Yes4All has grown to become one of the leading names in the fitness, furniture and lifestyle market. A significant player in e-commerce since 2016, we were among the first invited to Amazon's Vendor Central (AVC) program and have been a top-12 Sports & Outdoors brand on Amazon since 2021.
We expanded our presence across the USA and 17 international markets, reaching $132M GMV with 74% YoY growth in 2023, achieving 26% YoY GMV growth in 2024 and a 3.5X increase in EBITDA. With 2,000+ SKUs on platforms like Amazon, Wayfair, and Walmart, we continue to scale.
Guided by Mr. Nguyen Chi My, we leverage Vietnam's competitive strengths and strategic manufacturing partnerships to drive innovation. Beyond our own success, we empower Vietnamese SMEs, providing expertise to scale internationally.
JOB PURPOSE
Support the SSO team in collecting, consolidating, cleaning, standardizing, and updating product data for more than 2,000 active SKUs based on predefined rules and confirmed data sources. The role also supports product analysis, reporting, and data visualization for New Product Development (NPD), Product Improvement, and portfolio review under the guidance of the PD&D team.
Reason & Impact: SSO currently manages a large active SKU portfolio while product data still requires significant consolidation, standardization, and regular updating, and dedicated analytics resources are limited. This internship provides execution support to improve product-data readiness and enables the PD&D team to use structured data more effectively for product analysis and decision support.
RESPONSIBILITIES & KEY TASKS
Responsibility 1: Product Data Collection & Preparation (40%)
· Collect and consolidate product information from assigned internal data sources into the SSO Product Master Database.
· Check data completeness and identify missing, duplicated, inconsistent, or unusual information based on predefined checking rules.
· Prepare and maintain a Data Issue List and submit identified gaps or inconsistencies to the assigned data owner/team for verification and confirmation.
· Clean and standardize product data according to predefined templates, naming conventions, units of measurement, Data Dictionary, and Taxonomy rules.
· Update confirmed information into the Product Master Database and maintain clear update records.
EXPECTED OUTCOME
· Product data is systematically collected, consolidated, cleaned, and standardized according to predefined rules.
· Missing, duplicated, inconsistent, or unusual data is clearly identified and tracked for verification by responsible data owners.
· Confirmed product information is correctly updated into the Product Master Database.
Responsibility 2: Product Data Update & Tracking Support (20%)
· Update product data based on confirmed information provided by responsible teams/data owners.
· Maintain Data Issue List, Missing Data List, and Update Tracking Log.
· Perform periodic data completeness and consistency checks using predefined checklists or rules.
· Prepare periodic Product Data Status reports for PD&D review and follow up assigned data-update actions.
EXPECTED OUTCOME
· Product data updates are tracked and completed based on confirmed information.
· Data issues and missing information are visible through clear tracking lists.
· Periodic Product Data Status is available for PD&D review.
Responsibility 3: Product Analytics Support (40%)
· Prepare and organize datasets required for assigned product analyses under the guidance of the PD&D team.
· Perform basic descriptive analysis such as SKU count, sales/GMV, ASP, price range, category, market, product type, and other assigned dimensions.
· Support product comparison, portfolio review, NPD, and Product Improvement analyses using predefined templates and analytical frameworks.
· Prepare Pivot Tables, comparison tables, charts, and basic dashboards to visualize analytical results.
· Summarize key observations from data and support the PD&D team in preparing analytical reports and management summaries.
EXPECTED OUTCOME
· Assigned analytical datasets and reports are prepared accurately and on time.
· Product performance and portfolio information is presented in a clear and easy-to-understand format.
· Basic data observations support PD&D in NPD, Product Improvement, and portfolio review activities.
· Reusable analytical templates and basic dashboards help reduce repetitive manual work.
REQUIREMENTS
Education
· Final-year student or recent graduate in Business Analytics, Data Analytics, Management Information Systems, Economics, Finance, Business Administration, Industrial Engineering, Supply Chain Management, Statistics, or a related field.
Skills
· Good Microsoft Excel / Google Sheets skills; able to work with structured datasets and use common functions such as XLOOKUP/VLOOKUP, SUMIFS, COUNTIFS, IF, Pivot Tables, filtering, and data validation.
· Good attention to detail and structured thinking; able to identify missing, duplicated, inconsistent, or unusual data based on predefined rules.
· Basic analytical and quantitative skills; able to interpret data and communicate findings clearly.
· Knowledge of Power Query, Power BI, SQL, Looker Studio, Python, data visualization, or dashboard development is an advantage but not mandatory.
· Able to read English product information, specifications, reports, and online sources; basic written English for reporting is preferred.
Experience
· No full-time work experience required. Internship, academic projects, or hands-on experience involving data preparation, Excel analysis, dashboards, product data, e-commerce, or business/product analysis is preferred. Candidates must be able to commit to a 6-month full-time internship.