Retail & E-commerce Analyst
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
