Shopbop is seeking an experienced Business Analyst to drive strategic inventory planning and operational excellence across our fulfillment network. This role will focus on optimizing forecasting models and analytical tools to reduce costs within our inventory placement strategy. The successful candidate will be instrumental in building and maintaining sophisticated forecasting models that drive labor planning decisions and inventory placement strategies. They will work closely with multiple fulfillment centers, vendors, and cross functional partners to optimize inventory distribution and reduce transportation costs while maintaining service levels. The role requires someone who can translate complex data analyses into actionable insights for stakeholders across the organization, from operations to finance. The ideal candidate will combine strong analytical capabilities with excellent cross-functional partnership skills to drive data-informed decisions across the organization.
Key job responsibilities
• Develop and maintain weekly unit forecast to validate placement strategies to inform labor planning, and partner with warehouse teams to determine appropriate prioritization
• Manage PO allocations by FC in partnership with Buying and Vendors
• Create and maintain dashboards and reports to track key performance indicators (KPIs) for operational success
• Identify process improvement opportunities for existing processes and reporting, design additional controls to solve deficiencies, and drive positive change across the organization
• Support Accounts Payable with the validation and auditing of new operational data flows
• Support the development of inventory placement models and optimizations to reduce the cost of moving our inventory throughout the network
• Trace inventory transactions across receipt, stow, outbound, and return to identify gaps, resolve issues, and implement controls to systematically correct
• Track down and identify sources of data, determine the validity of the data, and analyze the variance in the data between various systems and reports
• Provide ad-hoc analysis on revenue trends and inventory health
• Support processes for managing inventory exception paths to limit out-of-pocket inventory (i.e. unsellable inventory)
• Pull and report data from numerous databases (using Excel, SQL, and/or other data management systems) and dive deep via research and problem-solving techniques