R

RocketAMS

Ecommerce Analyst

Data Analysis +1Confirmed live in the last 24 hours
Full-timeRemote in PhilippinesA$1k - A$1.2k /mo

About the Job

Requirements

  • Advanced proficiency in Google Sheets or Excel, including XLOOKUP, VLOOKUP, INDEX/MATCH, FILTER, QUERY, SUMIFS, pivot tables, and conditional formatting; Apps Script or automation experience is a plus.
  • Must have recent hands-on experience within the last three months using advanced spreadsheet functions such as XLOOKUP, VLOOKUP, INDEX/MATCH, QUERY, and FILTER.
  • Must have experience building a financial or inventory forecast or budget from scratch, not just updating existing files.
  • Must be comfortable working in the AEST timezone (7:00 AM–4:00 PM PHT) and managing tasks independently.
  • Must have a reliable internet connection, stable power source, and suitable laptop or desktop for remote work.
  • Strong analytical reasoning, including the ability to assess unfamiliar datasets, identify key insights, and determine actionable next steps.
  • Financial literacy and experience with budgeting, forecasting, or variance reporting.
  • Systems thinking, including the ability to structure, standardize, and scale processes.
  • Ability to manage time independently, flag blockers early, and manage deadlines independently.

Responsibilities

  • Build and maintain weekly, monthly, and quarterly Google Sheets dashboards tracking revenue, conversion, advertising efficiency, and catalog health across multiple client accounts.
  • Develop 12-month sales forecasts, budget-versus-actual variance analyses, scenario models, and promotional impact projections for events such as Prime Day and Black Friday.
  • Interpret performance metrics including revenue, units sold, conversion rate, return on advertising spend, average selling price, and cost per acquisition to identify trends, flag risks, and recommend actions.
  • Maintain product data accuracy, troubleshoot listing issues, and coordinate promotional calendars alongside Brand Managers.
  • Create standard operating procedures, automate recurring workflows using advanced formulas or scripts, and improve internal processes.

Desired Qualifications

  • Familiarity with Seller Central or Vendor Central; training is provided.
  • Apps Script or automation experience.

About the Company

Company size
Not listed
Company stage
Not listed
Total funding
Not listed
Headquarters
Not listed
Founded
Not listed

Recently Posted Jobs

Explore more opportunities at RocketAMS

See more jobs