Ecommerce Data Analyst - Freelance, Remote

Magic

9d•Remote

About The Position

Our client is a fast-growing consumer health brand that designs award-winning, doctor-engineered humidifiers for modern households. They sell DTC via Shopify and across marketplaces like Amazon, with a strong reputation for product quality and customer experience. The team values data-driven decision-making to keep operations lean, improve delivery speed, and scale sustainably. As the company scales DTC and marketplace channels, they need a dedicated analyst to turn raw Shopify, Amazon, and 3PL data into clear operational decisions. This role exists to improve inventory planning, reduce logistics costs, and align stock with marketing plans through robust forecasting and real-time visibility. The analyst will help the business move from reactive to proactive operations, ensuring products are in the right place at the right time—at the lowest possible cost.

Requirements

Hands-on experience working with ecommerce or operations data (inventory, 3PL, shipping).
Proficient in SQL (joins, window functions, CTEs) for analysis and reporting.
Built production dashboards in Looker, Tableau, or Power BI.
Familiarity with Shopify and/or Amazon Seller Central data and reporting.
Demonstrated ability to analyze logistics performance and drive cost/time improvements.
Computer with at least 8GB RAM, an Intel i5 core processor/AMD Ryzen 5 Processor and up.
Internet speed of at least 40MBPS
Headset with an extended mic that has noise cancellation and a webcam
Back-up computer and internet connection
Quiet, dedicated workspace at home
Reliable internet connection and a quiet workspace
Provide own computer with Intel Core i5 or something similar or higher operating system

Nice To Haves

Exposure to Python or R for forecasting
Understanding of forecasting methods (seasonality, trend, promo uplift)
KPI design (MAPE, OTIF, CPP, lead time, inventory turns)
Clear data storytelling
Business acumen
Curiosity
Attention to detail
Proactive problem-solving
Ability to partner across Growth and Operations

Responsibilities

Build SKU-level demand forecasts using trends, marketing spend, and seasonality.
Recommend safety stock levels and reorder points to prevent stockouts and overstocks.
Reconcile sell-through vs. on-hand and inbound to improve inventory turns.
Analyze carrier performance, delivery speed, and shipping cost per order to identify savings.
Monitor 3PL SLAs, lead times, receiving delays, and pick/pack accuracy.
Surface root causes for late deliveries and propose corrective actions.
Create automated dashboards in Looker/Tableau/Power BI for real-time visibility (orders, OTD, cost-to-serve, inventory health).
Write and maintain SQL queries to unify Shopify, Amazon, and 3PL data.
Build ad hoc analyses for promotions, product launches, and seasonality.
Align stock plans with Growth/Marketing calendars and budgets.
Provide scenario analyses (e.g., promo lift, channel mix shifts, inbound delays).
Translate technical insights into clear recommendations for non-technical stakeholders.
Validate data accuracy across sources; document assumptions, definitions, and logic.
Standardize KPIs (e.g., MAPE, OTIF, CPP, inventory turns) and reporting cadence.