# Retail & E-commerce Analyst > Activate Talent · Philippines (Remote) · Full-time · Posted 2026-03-17 **Workplace:** remote **Department:** 003 ## Description **Title:** Retail & E-commerce Analyst**Job Type:** Full-Time/Part-Time**Location:** 100% Remote **Timezone:** US (EST)** Position Summary** The Retail & eCommerce Analyst is responsible for transforming raw sales data from retail partners, Shopify, and Amazon or Amazon Partner/Accelerator into actionable business insights. This role owns the end-to-end development of recurring and ad hoc performance reports, monitors SKU-level health across all channels, and serves as an early-warning system for demand planning, inventory risk, and revenue anomalies. The ideal candidate blends technical data skills with commercial acumen to influence merchandising, supply chain, and category strategy decisions. **Key Responsibilities** **Sales Reporting & Channel Performance** • Build and maintain weekly, monthly, and quarterly sales dashboards across retail (brick-and-mortar partners), Shopify DTC, and Amazon Seller/Vendor Central channels – direct or provided by Partner/Accelerator • Track net sales, gross margin, units sold, returns, and sell-through rates by channel, region, and time period • Deliver executive-ready sales summaries with clear narratives on performance drivers, headwinds, and opportunities • Monitor revenue pacing against targets and flag variances with root-cause analysis **SKU: Product Performance/ Category & Franchise Insights** • Analyze SKU-level performance metrics including velocity, rank, conversion rate, return rate, and contribution margin • Identify top performers, slow-movers, and at-risk SKUs across all channels • Track new item launch performance and provide early read-outs against forecast • Monitor listing health on Amazon (Buy Box ownership, suppressed listings, review scores) and Shopify (site search, add-to-cart, checkout drop-off) • Flag underperforming SKUs with recommended actions: promotional support, repricing, discontinuation, or bundling • Analyze category-level sales trends and competitive positioning across all channels • Identify growing, declining, and emerging categories; translate findings into assortment or promotional recommendations • Track franchise or brand family performance, comparing internal SKUs against category benchmarks • Deliver periodic category health scorecards covering share, growth, margin, and space productivity • Partner with product and brand teams to align category insights with go-to-market strategy **Demand Planning & Inventory Alerts** • Develop and maintain sell-through and velocity models to inform replenishment forecasts • Provide demand signals to supply chain and planning teams identifying over- or under-stock risk at the SKU and channel level • Alert stakeholders to stockout risk, excess inventory, or unusual velocity changes requiring action • Collaborate with demand planning on seasonality curves, promotional lifts, and new product ramp-up models **Cross-Functional Collaboration** • Partner with Sales, Marketing, Merchandising, Finance, and Supply Chain to align on data definitions and reporting cadences • Support trade marketing and promotional analysis measuring lift, ROI, and halo effects across channels • Participate in S&OP (Sales & Operations Planning) processes, providing data-driven inputs to consensus forecasts • Present findings and recommendations to senior leadership in a clear, concise, and visually compelling format **Data Management & Governance** • Maintain clean, well-documented data sources and transformation logic in central BI environments • Ensure data accuracy and consistency across all reports and dashboards • Work with IT or data engineering to onboard new retailer EDI or API data feeds • Document reporting methodologies, KPI definitions, and update cadences in a shared knowledge base **REQUIRED TOOLS & PLATFORM KNOWLEDGE** **eCommerce & Retail Platforms** • Shopify sales analytics, product performance, inventory, and admin reporting • Amazon Portal or Amazon Provider/Accelerator provided reports • Retailer portals: Ulta, Nordstrom, 3rd Party eCommerce, and EDI/portal environments **Business Intelligence &; Data Visualization** • Experience building production-ready dashboards and scheduled reports • Familiarity with Google Data Studio **Data/Analytics/Infrastructure** • Advanced Excel / Google Sheets: pivot tables, XLOOKUP/INDEX-MATCH, dynamic arrays, and complex formulas • SQL: writing queries to extract, join, and aggregate data from relational databases • Python or R for data wrangling, automation, and statistical modeling (preferred) • Comfort working with API data feeds and flat-file integrations (CSV, EDI 852/867) **Collaboration & Productivity** • Microsoft Office Suite and/or Google Workspace • Project and task management tools: Jira, Asana, Monday.com, or similar • Communication platforms: Slack, Microsoft Teams or similar **QUALIFICATIONS** **Required** • Bachelors degree in Business Analytics, Data Science, Statistics, Economics, or a related field • 3–5 years of experience in a data analytics, sales analytics, or eCommerce reporting role • Demonstrated experience with Shopify analytics • Strong command of Excel and at least one BI tool (Tableau, Power BI, or Looker) • Experience building automated reports and dashboards for business stakeholders • Excellent written and verbal communication skills; ability to present data to non-technical audiences • Strong attention to detail, organizational skills, and ability to manage multiple reporting cadences simultaneously **Preferred** • Experience in CPG, consumer electronics, apparel, or other retail-focused industries • Proficiency in SQL and working knowledge of Python or R • Familiarity with demand planning methodologies and S&OP processes • Experience with retail EDI data (852 POS, 867 ship-and-debit) • Knowledge of inventory health metrics and replenishment logic **KEY PERFORMANCE INDICATORS** • Accuracy and timeliness of weekly/monthly sales reports • Reduction in stockout and excess inventory incidents through proactive demand alerts • Speed and quality of SKU anomaly identification and escalation • Stakeholder satisfaction with reporting clarity and actionability • Improvement in category and franchise performance through data-driven recommendations • Data pipeline uptime and report refresh reliability ## Apply [Apply at Activate Talent](https://apply.workable.com/careersactivatetalent/j/5C2B5091CB/apply) --- Powered by [Workable](https://www.workable.com)