Provide SKU-level demand forecasts, set reorder points and safety stock, reconcile inventory, analyze 3PL/carrier performance and shipping costs, build automated dashboards and SQL pipelines unifying Shopify, Amazon, and 3PL data, run ad-hoc promo and launch analyses, and partner with Growth and Operations to align stock and reduce logistics cost.
About the Client
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.
Why does this role exist?
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.
The Impact you’ll make
Inventory, Forecasting, and Demand Planning
- 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
Required:
- 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.
Your superpowers are...
- 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.
WFH Set-Up:
- 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 should apply if...
- 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.
What to expect...
- Work-from-home setup: Reliable internet, quiet workspace, and professional calling environment required
- Working hours: Full-time, Central Timezone
- Compensation: $7/hour
Work Setup:
- 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
Working Hours:
- 40 hours per week
- Central Timezone
Compensation:
- $7 per hour
- No benefits package included
Benefits
About
Magic has connected top remote talent with fast-growing businesses for over 10 years.Founded in San Francisco in 2015, we now have thousands of remote workers around the world. Magic is backed by Sequoia Capital and Y Combinator.
Similar Jobs
Artificial Intelligence • Productivity • Software • Automation
Lead Zapiers security strategy for an AI-native SaaS platform. Own App and Infrastructure Security, Detection & Response, GRC, risk management, incident response, bug bounty triage, and enterprise security enablement. Partner with Product, Engineering, Legal, and GTM to embed secure-by-default design, shape AI-specific controls, support enterprise deals, and build a high-performing security engineering organization.
Top Skills:
AIBug Bounty PlatformsCloudDetection & ResponseForensicsIdentity And Access Management (Iam)Incident ResponseSecure SdlcThreat Modeling
Artificial Intelligence • Cloud • Computer Vision • Hardware • Internet of Things • Software
Lead and coach a team of ~8 account executives selling full-cycle to SMBs: hire, onboard, train, review pipeline, support deals, create training content, and collaborate cross-functionally to meet quarterly targets.
Top Skills:
Salesforce (Sfdc)
Artificial Intelligence • Healthtech • Machine Learning • Natural Language Processing • Biotech • Pharmaceutical
Lead the CFC CRM product for HCP/HCO-facing colleagues, define roadmap, translate stakeholder needs into prioritized enhancements, write requirements and user stories, partner with engineering, UX, vendors and compliance to deliver scalable global CRM solutions and measure business impact.
Top Skills:
Crm PlatformsLife Sciences CloudOceSalesforceVeeva
What you need to know about the Sydney Tech Scene
From opera to comedy shows, the Sydney Opera House hosts more than 1,600 performances a year, yet its entertainment sector isn't the only one taking center stage. The city's tech sector has earned a reputation as one of the fastest-growing in the region. More specifically, its IT sector stands out as the country's third-largest, growing at twice the rate of overall employment in the past decade as businesses continue to digitize their operations to stay competitive.
