eCommerce Analyst
R
RocketAMSE-commerce
Philippines, AEST timezone (7:00 AM – 4:00 PM PHT)Full-TimeMiddle
Salary not disclosed
Apply NowOpens the employer's application page
Job Details
- Required Skills
- jQueryMicrosoft ExcelGoogle Sheets
Requirements
- Comfortable working in the AEST timezone (7:00 AM – 4:00 PM PHT)
- Reliable internet connection
- Stable power source
- Suitable laptop or desktop for remote work
- Recent hands-on experience (within the last 3 months) using XLOOKUP
- Recent hands-on experience (within the last 3 months) using VLOOKUP
- Recent hands-on experience (within the last 3 months) using INDEX/MATCH
- Recent hands-on experience (within the last 3 months) using QUERY
- Recent hands-on experience (within the last 3 months) using FILTER
- Experience building a financial or inventory forecast or budget from scratch
- Strong analytical reasoning skills
- Advanced Google Sheets or Excel proficiency (SUMIFS, pivot tables, conditional formatting, Apps Script or automation experience ideal)
- Financial literacy (budgeting, forecasting, variance reporting)
- Systems thinking
- Self-direction
Responsibilities
- 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.
View Full Description & ApplyYou'll be redirected to the employer's site
