Data Analyst, Supply Chain

📋 Description

• • Own the end-to-end demand forecast for every book, gift, and paper product that lands on the doorsteps of more than 100,000 Book of the Month members each month. You will maintain and refine daily, weekly, and monthly forecasting models that balance service-level goals with inventory risk, ensuring that the right titles are in the right warehouse at the right time.
• • Build and iterate on SQL-based forecasting pipelines that ingest point-of-sale data, web traffic, promotional calendars, and external signals to predict demand across multiple concurrent monthly selection cycles. Your code will be the single source of truth used by Finance, Marketing, and Operations to plan cash flow, set print quantities, and schedule labor.
• • Drive continuous improvement in forecast accuracy (MAPE) and inventory health (turns, weeks-of-supply, obsolescence) by designing exception-based alerts that flag potential stockouts, overstock, or backorders before they impact the member experience. You will present these findings in weekly cross-functional S&OP meetings attended by the COO, Head of Merchandising, and VP of Operations.
• • Automate repetitive inventory tasks—cycle-count reconciliation, PO-status scraping, and inbound-delay notifications—using Python or similar scripting languages. Your automations will free the Supply Chain team to focus on strategic initiatives such as new-product launches, international expansion, and sustainability initiatives.
• • Collaborate with Merchandising and Editorial to translate qualitative excitement about a debut novel or celebrity book club pick into quantitative forecasts. You will translate marketing briefs into scenario models that quantify upside, downside, and risk, enabling leadership to make data-driven print-run decisions weeks before release.
• • Design and maintain executive-level dashboards in our BI tool (Looker) that track KPIs such as fill rate, backorder rate, forecast bias, and inventory aging. Your visualizations will be used in board meetings and investor updates to showcase operational excellence and working-capital efficiency.
• • Lead root-cause analysis on inventory variances discovered during cycle counts or inbound audits. You will partner with 3PL warehouse teams to identify systemic issues (mis-picks, ASN errors, damages) and implement corrective actions that reduce shrink and improve data integrity.
• • Support ad-hoc strategic projects—e.g., launching a new kids’ book line, testing on-demand printing, or optimizing carton sizes for freight savings—by building quick-turn models that size opportunities, quantify costs, and recommend go/no-go decisions.
• • Champion a culture of data literacy within the Supply Chain team by hosting monthly “SQL for Ops” workshops and creating self-service query libraries that empower non-technical teammates to answer their own questions.
• • Stay ahead of industry trends in demand-planning methodologies (e.g., probabilistic forecasting, machine-learning ensembles) and DTC supply-chain best practices. You will pilot new techniques on small data sets, measure lift, and scale what works across the full SKU catalog.