Program Analyst - Assortment, BOM & Quantity Planning

The Senior Production Program Analyst will work remotely from OH, MI, NY or PA and will be responsible for managing complex customer program data, store trait analysis, assortment logic, production quantities, BOM development, and Excel-based program databases. This role supports Customer Success, Account & Business Management, Graphics, Procurement, Production, Warehouse, Inventory, and Finance teams by ensuring that program quantities, store lists, trait assignments, modular assortments, graphics requirements, inventory assumptions, and production BOMs are accurate, current, and ready for quoting, ordering, production, kitting, fulfillment, and invoicing. This is a senior-level analytical role requiring advanced Excel/database skills, strong production awareness, and the ability to understand how store traits, modular layouts, customer assortments, graphics, fixtures, parts, SAP items, and production quantities connect across a retail program. The Senior Production Program Analyst must be able to work independently, identify gaps in customer-provided data, validate quantities, and translate assortment and store-level information into accurate production, procurement, and quoting outputs. This role reports to the VP Business Management and is remote.

Responsibilities

Analyze customer store lists, store traits, modular footprints, assortment files, and program data to determine accurate production quantities; Review and maintain trait-by-store databases, store count files, modular assortment files, and related program trackers; Translate customer assortment and store trait information into usable production, graphics, fixture, part, inventory, and kitting requirements; Identify inconsistencies, missing information, duplicate stores, outdated store counts, or mismatched traits before they impact quotes, procurement, production, fulfillment, or invoicing; Maintain accurate program-level databases that support production BOM creation, quoting, procurement, production planning, warehouse preparation, inventory tracking, and fulfillment; Compare revised store lists, modular assortments, and customer updates to prior versions to identify changes in scope, quantity, production requirements, or complexity; Provide clear quantity summaries by store trait, modular type, assortment type, part type, fixture, graphic, kit, and production component where applicable; Draft, review, and approve production BOMs based on approved store traits, assortment logic, modular requirements, customer program details, and production needs; Convert store-level and trait-level data into accurate production quantities for parts, fixtures, graphics, kits, components, and related materials; Partner with Graphics, Procurement, Production, Warehouse, Inventory, and Customer Success teams to ensure BOMs are complete, buildable, and aligned with approved program scope; Support production quantity planning for new inventory, open fulfillment inventory, graphics overs, signing kits, replenishment needs, and customer-specific production overs where applicable; Ensure production quantities reflect the latest customer information before quotes, purchase orders, component ordering, production launches, kitting, or fulfillment activities begin; Track and communicate changes in quantities, store counts, assortment logic, BOM requirements, inventory needs, or production scope that could impact pricing, procurement, production schedules, warehouse planning, or delivery; Help ensure that production teams have accurate, complete, and clearly structured BOMs and quantity files before work begins; Support Account Management and Customer Success teams with quote quantity preparation using the latest store counts, trait files, assortment data, production BOMs, and quantity logic; Validate that quote quantities are based on current customer data and clearly identify assumptions used in the quantity build; Apply appropriate production overage logic based on program requirements, including safety inventory, signing kit quantity additions, and customer- or program-specific overs; Work with account team to confirm key quote assumptions before submission; Help reduce quote rework by identifying customer quantity questions, production assumptions, and overage requirements early; Ensure quote quantities are practical for production, procurement, inventory setup, kitting, and fulfillment; Analyze graphics requirements by modular type, store trait, assortment, and footprint; Determine accurate graphic quantities based on trait/store counts, BOM requirements, kit structure, and production requirements; Support signing kit quantity development, including simplified kits by modular footprint such as 4 ft., 8 ft., 12 ft., and other modular types; Ensure signing kit quantities are added as exact quantity requirements based on store trait quantities, not estimated only as a general percentage when specific trait counts are available; Communicate graphic quantity logic clearly to Customer Success, Account Management, Graphics, Production, Procurement, and Warehouse teams; Partner with production and warehouse teams to ensure graphics quantities align with kitting and fulfillment requirements; Support data accuracy when new customer items are created and SAP numbers are assigned; Track SAP numbers, item descriptions, pricing, part information, and related fulfillment data where applicable; Understand that once an SAP number and price are assigned, new order fulfillment and inventory value follow that pricing structure; Support Procurement by maintaining accurate component, part, production, and SAP-related information for quoting, sourcing, and ordering activities; Help identify whether designs, fixtures, graphics, or components may be patented or proprietary when Procurement is reviewing bid opportunities; Support inventory forecasting, reorder planning, safety stock, and open fulfillment inventory processes as needed; Monitor inventory and production assumptions that may impact future reorders, customer fulfillment, or program continuity; Assist with invoice preparation, backup documentation, and quantity validation as needed; Support sales tax preparation by helping organize program, order, item, production, and customer data required for review; Ensure invoice-related quantities and supporting documentation align with approved program scope, orders, BOMs, production quantities, fulfillment data, and shipped quantities; Work with internal stakeholders to resolve discrepancies between quoted, ordered, produced, shipped, and invoiced quantities; Serve as a key analytical resource between Customer Success, Account Management, Graphics, Procurement, Production, Warehouse, Inventory, and Finance teams; Communicate data issues, production risks, quantity changes, program changes, assumption gaps, and inventory concerns clearly and proactively; Translate complex Excel data and customer files into practical production summaries for non-technical team members; Support internal meetings with quantity analysis, BOM details, production status updates, inventory assumptions, and change summaries; Escalate risks related to missing data, unclear assortment logic, outdated store counts, production shortages, inventory gaps, or customer quantity changes; Help ensure that all teams are working from the same current quantity assumptions and production data

Requirements

Senior-level experience in program analysis, production planning, customer program support, retail execution, merchandising, kitting, inventory analysis, BOM management, or a similar analytical role; Advanced Microsoft Excel skills, including complex formulas, lookups, pivot tables, data validation, cross-file comparisons, and large database management; Strong ability to analyze store lists, trait files, assortment files, modular data, BOMs, production quantities, and inventory requirements; Experience working with production BOMs, kitting logic, graphics quantities, fixtures, components, parts, or retail display programs; Strong understanding of how customer data flows into quotes, orders, procurement, production, inventory, warehouse planning, fulfillment, invoicing, and reporting; Ability to manage multiple large Excel files while maintaining version control and data accuracy; Strong attention to detail and ability to identify discrepancies before they create downstream production or fulfillment issues; Ability to work independently with minimal supervision; Strong communication skills with the ability to explain quantity logic, production assumptions, overage calculations, and risks clearly; Comfortable working in a fast-paced environment with changing customer requirements, revised store counts, updated assortments, production needs, and evolving program details

Nice to have

Experience with store lists, modular assortments, traits by store, SAP numbers, and customer quote requests; Experience creating, reviewing, or maintaining master kitting BOMs; Experience analyzing graphics quantities, signing kits, fixture parts, production overs, safety inventory, and reorder requirements; Experience supporting Account Management, Customer Success, Procurement, Production, Warehouse, Inventory, or Finance teams; Experience with sales tax preparation, invoice backup, or customer billing support; Experience with Power Query, Power Pivot, Access, Smartsheet, Power BI, or other database/reporting tools is a plus