Build and maintain reporting systems — weekly, monthly, and quarterly dashboards in Google Sheets that track revenue, conversion, advertising efficiency, and catalog health across multiple client accounts.
Develop financial models — 12-month sales forecasts, budget-vs-actuals variance analysis, scenario modelling, and promotional impact projections for events like Prime Day and Black Friday.
Analyse performance data — interpret metrics like revenue, units sold, conversion rate, ROAS, average selling price, and cost per acquisition to identify trends, flag risks, and recommend actions.
Support catalog and listing operations — maintain product data accuracy, troubleshoot listing issues, and coordinate promotional calendars alongside Brand Managers.
Design and improve internal processes — create SOPs, automate recurring workflows using advanced formulas or scripts, and continuously improve how we work.
Requirements
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 a suitable laptop or desktop for remote work
Must have recent hands-on experience (within the last 3 months) using advanced spreadsheet functions such as:
XLOOKUP
VLOOKUP
INDEX/MATCH
QUERY
FILTER
Must have experience building a financial or inventory forecast or budget from scratch (not limited to updating existing files)
Must have strong analytical reasoning skills — able to assess unfamiliar datasets, identify key insights, and determine actionable next steps