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.
Logistics, 3PL, and Shipping Analytics
- 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.
Ecommerce Analytics and Reporting
- 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.
Cross-Functional Partnership
- 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.
Data Quality and Governance
- 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






