The Role
Freelance ecommerce data analyst to build SKU-level forecasts, set safety stock and reorder points, reconcile inventory, analyze 3PL/carrier performance, create automated dashboards (Looker/Tableau/Power BI), write SQL to unite Shopify/Amazon/3PL data, produce ad-hoc analyses for promos and launches, and partner with Growth and Operations to improve inventory and logistics efficiency.
Summary Generated by Built In
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.
Skills Required
- Hands-on experience working with ecommerce or operations data (inventory, 3PL, shipping)
- Proficient in SQL (joins, window functions, CTEs)
- 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
- Write and maintain SQL queries to unify Shopify, Amazon, and 3PL data
- Experience building SKU-level demand forecasts and applying forecasting methods (seasonality, trend, promo uplift)
- Advanced Excel or Google Sheets skills
- Exposure to Python or R for forecasting
- Computer with at least 8GB RAM and Intel i5 or AMD Ryzen 5 (or higher)
- Internet speed of at least 40MBPS
- Headset with noise-cancelling mic and webcam
- Backup computer and internet connection
- Quiet, dedicated home workspace
- Availability to work full-time (40 hours/week) in Central Timezone
Am I A Good Fit?
Get Personalized Job Insights.
Our AI-powered fit analysis compares your resume with a job listing so you know if your skills & experience align.
Success! Refresh the page to see how your skills align with this role.
The Company
What We Do
Magic is a frictionless way to plug in thoroughly vetted, cost-effective remote workers, to help scale your key business functions. Through a combination of automation and active work, we tap into our network of vetted remote workers who handle tasks from virtual assistance and customer service to sales lead generation and scheduling across various team members—like magic.
