RemoteRemote role; work AEST hours (7:00 AM–4:00 PM PHT).
Data & AnalyticsData Analysis, Business Intelligence
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.
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 You'll Bring
Advanced proficiency in Google Sheets/Excel for analysis and reporting.
Strong ability to interpret data and generate actionable insights.
Experience with budgeting, forecasting, financial modeling, and variance reporting.
Familiarity with Seller Central or Vendor Central is a plus (training provided).
Highly organized, proactive, and capable of managing deadlines independently.
What We Offer
Comprehensive Training and Mentorship
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.
Learn advanced Amazon strategies and operational best practices to set you up for success.
Exciting Career Growth
Join a fully remote team with substantial growth potential as RocketAMS continues to expand.
Work in Australian time (10 AM Sydney start) and collaborate closely with seasoned professionals to refine your skills and grow in your career.
Monthly Compensation Range:
Trainee (Level 1): $900 AUD/month (40 hours per week)
Progression is based on performance and readiness to handle accounts independently
Level 2 (Full-Time): $1,000 – $1,200 AUD/month (40 hours per week)
Depending on number of clients managed and performance (reviewed quarterly)
We will only consider applications submitted through this link.
Submit your application now, this role is moving quickly!
RocketAMS is an Australian company and our recruitment process reflects Australian hiring standards. Shortlisted candidates will be invited to complete a recorded video interview, followed by a practical assessment, so please be prepared for these steps as part of the process.
Successful candidates who progress to the final stage may be placed into our talent pool, which we actively draw from as roles become available. This means opportunities may open immediately or over the coming weeks as our client demand grows.
Requirements
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