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 • 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
Artificial Intelligence • Professional Services • Business Intelligence • Consulting • Cybersecurity • Generative AI
Lead large Oracle Field Service implementation projects as a Solutions Architect senior manager. Design and deploy Oracle Fusion Service and Field Service Cloud solutions, guide assessment and future-state planning, interact with senior clients, coach teams, apply delivery methodologies and accelerators, and drive continuous improvement.
Top Skills:
Oracle Customer ExperienceOracle EpmOracle Field Service CloudOracle FinOracle Fusion ServiceOracle HcmOracle Lead ManagementOracle Marketing AutomationOracle Sales AutomationOracle Scm
Artificial Intelligence • Professional Services • Business Intelligence • Consulting • Cybersecurity • Generative AI
Lead end-to-end product lifecycle for internal and commercial software products, drive product strategy and commercialization, collaborate with cross-functional teams, apply Agile methods, coach teams, validate client outcomes, and execute roadmaps and go-to-market plans.
Top Skills:
Agile MethodologyProduct Lifecycle Management
What you need to know about the Boston Tech Scene
Boston is a powerhouse for technology innovation thanks to world-class research universities like MIT and Harvard and a robust pipeline of venture capital investment. Host to the first telephone call and one of the first general-purpose computers ever put into use, Boston is now a hub for biotechnology, robotics and artificial intelligence — though it’s also home to several B2B software giants. So it’s no surprise that the city consistently ranks among the greatest startup ecosystems in the world.
Key Facts About Boston Tech
- Number of Tech Workers: 269,000; 9.4% of overall workforce (2024 CompTIA survey)
- Major Tech Employers: Thermo Fisher Scientific, Toast, Klaviyo, HubSpot, DraftKings
- Key Industries: Artificial intelligence, biotechnology, robotics, software, aerospace
- Funding Landscape: $15.7 billion in venture capital funding in 2024 (Pitchbook)
- Notable Investors: Summit Partners, Volition Capital, Bain Capital Ventures, MassVentures, Highland Capital Partners
- Research Centers and Universities: MIT, Harvard University, Boston College, Tufts University, Boston University, Northeastern University, Smithsonian Astrophysical Observatory, National Bureau of Economic Research, Broad Institute, Lowell Center for Space Science & Technology, National Emerging Infectious Diseases Laboratories
