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