eCommerce Analyst - Remote (PH)

About RocketAMS

RocketAMS is a fully remote Amazon eCommerce agency based in Australia, founded by ex-Amazon Australia employees with over $100 million in collective sales experience. We partner with brands across the APAC region to drive growth on Amazon through data-led strategy and operational excellence. We're scaling fast and building a team of sharp, analytical thinkers who want to grow with us.

About the Role 

We're looking for an E-Commerce Analyst who thrives on turning messy data into clear decisions. You'll work across a portfolio of brands, owning the numbers behind their Amazon performance — building models, surfacing insights, maintaining reporting systems, and supporting the strategic decisions that drive revenue.

This isn't an Amazon role that happens to use spreadsheets. It's an analyst role that happens to be in Amazon eCommerce. If you're sharp with data, comfortable building systems in Google Sheets, and want to learn a high-growth channel inside and out — we'll teach you the Amazon side.

What You'll Do

• 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.

What You'll Bring

• Advanced Google Sheets or Excel proficiency — you're genuinely comfortable with XLOOKUP, INDEX/MATCH, FILTER, QUERY, SUMIFS, pivot tables, conditional formatting, and ideally some Apps Script or automation experience.
• Strong analytical reasoning — you can look at a dataset you've never seen before and figure out what matters, what's broken, and what to do about it.
• Financial literacy — experience with budgeting, forecasting, or variance reporting in any context (agency, finance, operations, consulting — it doesn't have to be eCommerce).
• Systems thinking — you naturally look for ways to structure, standardise, and scale how things are done rather than just completing tasks.
• Self-direction — you manage your own time, flag blockers early, and don't wait to be told what to do next.
• No Amazon experience required. We provide comprehensive training on Seller Central, Vendor Central, and the full Amazon ecosystem.

What We Offer

• Hands-on mentorship from our founders and senior specialists — you'll learn Amazon strategy from people who helped build the Australian marketplace.
• A high-growth environment where strong performers move into Brand Manager and strategy roles as we scale.
• Fully remote work on Australian business hours (10 AM Sydney start).

Job Requirements (Must-Have Qualifications)

• 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

• Paid Time Off

• Work From Home
• Training & Development
• Private Health Insurance After 12 Months
• Day Shift - 7am to 4pm PH Time