Inventory & Demand Planning Analyst

INVENTORY & DEMAND PLANNING ANALYSTAbout UsJP Ecommerce, doing business as Bare Home, has been named one of the top-ten fastest growing businesses in Minnesota by Inc. 5000 for four consecutive years. With annual sales approaching $100 million, we are a leading eCommerce retailer committed to providing customers with high-quality bedding through our brand Bare Home. As a global player in the textile industry, we source products from key regions including China, India, Pakistan, and Turkey, while also manufacturing cotton products in the USA. We emphasize cost-effectiveness, superior quality, and reliable availability through optimized operations and strategic partnerships.Position OverviewBare Home is seeking a technically sharp, detail-driven Inventory & Demand Planning Analyst to sit at the intersection of data, forecasting, and operations. This is a hands-on analytical role — you will own the numbers that drive our inventory decisions, build and maintain the models that keep us in stock and out of trouble, and work directly within our ERP and demand planning systems to ensure our data is clean, current, and actionable.The right candidate brings strong SQL skills, lives in Excel and Power BI, understands how demand planning tools are configured and optimized (not just opened), and has working knowledge of Amazon Seller Central or FBA fulfillment operations. You do not wait to be told what the data says — you already know, and you bring a recommendation with it.Key ResponsibilitiesInventory Planning & AnalysisMonitor and analyze inventory levels across all SKUs, warehouses, and fulfillment channels — identifying overstock, understock, and slow-moving positions and recommending corrective actionBuild and maintain safety stock models, reorder point calculations, and replenishment triggers tied to lead time, demand variability, and service level targetsTrack inbound purchase orders, vendor shipment timelines, and receipts — flagging gaps or delays before they impact operationsSupport seasonal planning cycles, prebook order management, and inventory alignment with promotional calendarsManage and maintain inventory master data integrity within the ERP system — if the data is wrong, the plan is wrongDemand Forecasting & Planning ToolsDevelop, maintain, and continuously improve short- and long-range demand forecasts using statistical models, historical sales data, and market signalsOperate and optimize our demand planning software platform — experience configuring or implementing a tool (Slimstock, Blue Yonder, o9, SAP IBP, NetSuite, or similar) is a strong plusEnsure planning system parameters — lead times, safety stock logic, replenishment rules — accurately reflect current business realities and are updated as conditions changeIdentify forecast accuracy issues at the SKU level and drive root cause analysis to reduce error rates over timeSupport S&OP and cross-functional planning cycles with accurate, well-documented demand dataERP Systems & Data ManagementWork fluently within our ERP system (NetSuite, SAP, Microsoft Dynamics, Oracle, or equivalent) for inventory tracking, purchase order management, and reportingMaintain data quality and accuracy within ERP/MRP modules — validate inputs, identify discrepancies, and own correctionsSupport ERP configuration improvements and participate in system enhancement projects related to inventory and planning workflowsServe as a subject matter resource for inventory and planning data within the systemSQL, Excel & Power BIWrite and execute SQL queries independently to extract, join, and transform data from internal databases — this is a daily tool, not an occasional oneBuild and maintain advanced Excel models: replenishment trackers, open-to-buy analysis, vendor scorecards, lead time variance models, and forecast vs. actual comparisonsDevelop and own Power BI dashboards that give operations and leadership real-time visibility into inventory position, forecast accuracy, and supply chain KPIsTranslate data into clear, actionable insights — you present a story and a recommendation, not just a table of numbersAutomate recurring reporting workflows where possible to increase capacity for higher-value analysisAmazon & Fulfillment Channel ManagementSupport demand and inventory planning for Amazon FBA and FBM channels — understanding how replenishment cadence, IPI scores, storage limits, and lead time requirements affect inventory strategyMonitor Amazon Seller Central data: stranded inventory, restock recommendations, sell-through rates, and aged inventory fees — flagging issues and recommending corrective actionsCoordinate inbound FBA shipment planning aligned with demand forecasts and promotional timingApply working knowledge of fulfillment operations — 3PL, warehouse workflows, pick-pack-ship processes — to ensure inventory plans are executable on the groundCross-Functional CollaborationPartner with Supply Chain, Purchasing, Warehouse Operations, and Finance to ensure inventory plans are aligned and communicated effectivelyWork with overseas vendors across China, India, Pakistan, and Turkey to share demand signals, track production timelines, and surface supply risk earlySupport Finance with inventory position reporting and working capital inputs tied to inventory levelsPresent findings and recommendations to leadership in a clear, business-ready formatRequired QualificationsEducation & Experience3–5 years of progressive experience in inventory planning, demand planning, supply chain analytics, or a closely related roleBachelor's degree in Supply Chain Management, Business Analytics, Finance, Operations Management, or a related fieldDemonstrated experience working within a product-based or eCommerce business environmentTechnical SkillsProficient in SQL — writes and executes queries independently; uses data to drive decisions, not just confirm themAdvanced Excel skills: XLOOKUP, INDEX/MATCH, Power Query, pivot tables, dynamic models, and data validationHands-on Power BI experience — building dashboards, connecting data sources, and publishing reports for operational and leadership audiencesExperience working within an ERP system (NetSuite, SAP, Microsoft Dynamics, Oracle, or equivalent) for inventory control, purchasing, and data managementFamiliarity with at least one demand planning or forecasting software platform — experience using a tool to actively build and manage forecasts, not just receive outputsWorking knowledge of Amazon Seller Central, FBA operations, or eCommerce fulfillment platformsProfessional Certifications (Preferred)APICS CPIM (Certified in Planning and Inventory Management) or CSCP (Certified Supply Chain Professional)Experience supporting or participating in a demand planning software implementation or ERP go-liveFamiliarity with Slimstock, Blue Yonder, o9, Kinaxis, or SAP IBP specificallyBackground in eCommerce, consumer goods, or retail with high SKU counts and seasonal demand patternsCore CompetenciesStrong analytical and problem-solving mindset with exceptional attention to detailAbility to manage large, complex data sets with accuracy and structureClear communicator — can translate complex data into plain language recommendations for cross-functional audiencesSelf-motivated, organized, and comfortable managing multiple priorities in a fast-moving environmentCollaborative team player who builds trust with internal partners and external vendors alikeWhat We OfferCompetitive salary: $75,000 – $95,000 based on experience and technical qualificationsComprehensive benefits package including health, dental, and vision insurance401(k) retirement plan with company matchPaid time off and holidaysA collaborative, entrepreneurial culture where analytical work directly drives business decisionsReal opportunity to grow with a function we are actively building — your impact here is visiblePosition DetailsLocation: Forest Lake/Columbus, Minnesota (100% on-site)Employment Type: Full-time, ExemptSchedule: Monday – Friday, standard business hours with flexibility as neededHow to ApplyInterested candidates should submit their resume and a cover letter highlighting their ERP experience and the demand planning or forecasting tools they have worked with to wyeargan@barehome.com or mfreeman@barehome.com. Please include "Inventory & Demand Planning Analyst" in the subject line.Come Visit Us: https://barehome.com/At Bare Home, we strive to create a culture where all people come first. We are committed to attracting and retaining a diverse workforce. Therefore, all qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, or veteran status. Bare Home is an equal opportunity employer, and by doing so, we aim to sustain and promote an inclusive culture that supports future growth for all.