Ecommerce Data Analyst - Freelance, Remote

The Impact you’ll make

• 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.

Skills, Knowledge and Expertise

• 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.

• Technical: SQL; dashboarding (Looker/Tableau/Power BI); advanced Excel/Google Sheets; exposure to Python or R for forecasting; comfort working with Shopify, Amazon, and 3PL data; understanding of forecasting methods (seasonality, trend, promo uplift); KPI design (MAPE, OTIF, CPP, lead time, inventory turns).
• Soft skills: Clear data storytelling, business acumen, curiosity, attention to detail, proactive problem-solving, and the ability to partner across Growth and Operations.

• 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

• You love turning messy operational data into simple, actionable decisions.
• You’re energized by fast-paced DTC environments and enjoy collaborating across teams.
• You care about the end customer experience and want to shorten delivery times without increasing cost.
• You take ownership, iterate quickly, and continuously improve processes.

• Work-from-home setup: Reliable internet, quiet workspace, and professional calling environment required
• Working hours: Full-time, Central Timezone
• Compensation: $7/hour

• Remote position
• Must have a reliable internet connection and a quiet workspace
• Required to provide own computer with Intel Core i5 or something similar or higher operating system

• 40 hours per week
• Central Timezone

• $7 per hour
• No benefits package included

Benefits