Excel Macro Jobs Near Me

What You’ll Do

The Senior Demand & Supply Planner is responsible for building accurate SKU-level demand forecasts, establishing supply plans, and managing inventory levels to meet customer and business objectives. This role bridges demand forecasting and supply planning to ensure service levels, profitability, and efficient inventory utilization.

You will collaborate cross-functionally with Sales, Merchandising, Sourcing, Distribution, Finance, and Account Support to balance customer demand with supplier and operational constraints. The position requires advanced analytical skills, business acumen, and leadership potential to drive improvements in forecasting accuracy, inventory productivity, and supply continuity. The individual will have an opportunity to move into leadership in 1-3 years if successful and has the desire to lead.

Specific Responsibilities

• Create, document, and maintain demand sku level forecasts aligned with supply for long-range planning.
• Reconcile the differences between macro business plans and sku level forecasts.
• Partner with Sales, Merchandising, and customers to develop assortment and demand plans.
• Monitors and measures forecast accuracy and volatility. Diagnoses, categorizes, quantifies and summarizes root causes of inaccuracy, poor service levels, and higher-than-expected excess and obsolete inventory. Leverages the results of this analysis in future forecasting process improvement.
• Analyze and distribute weekly and monthly demand reports with insights to cross functional teams.
• Collaborates cross-functionally to deliver against demand forecast and financial expectations. This includes monitoring demand through the value chain from forecast to delivery, taking actions to minimize risks and maximize opportunities. Works with the Sales team to develop incremental opportunities to close gaps to expectations.
• Establish and maintain 12-month rolling supply plans with supplier and distribution constraints.
• Identify, quantify and help resolve supply constraints that impede achievement of the demand plan.
• Recommends the best safety and cycle stock policies by SKU segment, balancing overall corporate inventory and service goals with customer requirements. Maintains and refines SKU classification and corresponding policies to ensure continuous improvement in both service and inventory productivity.
• Quantify and qualify any supply shortfall that may put fill rate targets at risk.
• Create and maintain accurate purchase orders with factories.
• Create and maintain choice level sku details.

Qualifications

•  Bachelor’s degree in Supply Chain, Operations Research, Statistics, Business, or related field.
• 3–5 years’ experience in demand and/or supply planning, forecasting, or related roles.
• Advanced analytical skills & proficiency in Excel (sumifs, index match, lookups, if function, pivot measures, power query, etc.
• Proficiency in a BI tools (Tableau, SQL, Snowflake, MicroStrategy or Sigma, etc.).
• Strong knowledge of supply chain processes including forecasting, inventory management, sourcing, and distribution.
• Excellent organizational, problem-solving, and communication skills.
• Ability to manage multiple priorities in a fast-paced environment.
• Leadership potential with mentoring or supervisory experience.
• Alignment with RG Barry’s values of trust, ambition, inclusion, creativity, responsibility, and teamwork

Benefits

• Medical
• Dental
• Vision
• Short Term Disability (100% Company Paid)
• Long Term Disability (100% Company Paid)
• Basic Life Insurance (100% Company Paid)
• Voluntary Life Insurance
• Accident
• Critical Illness
• 401(k) with Company Contributions
• Legal and Identity Theft Coverage
• Generous Team Member Discount
• Education Assistance
• Scholarships for Team Member’s Children
• 8 Paid Holidays
• One Week of Paid Summer Vacation
• One Week of Paid Winter Vacation
• Generous PTO
• Hybrid Work Schedule

Salary Information

The salary range for this position is $76,300-$135,000. This range is posted in good faith as an expected base amount the job will pay, and it may vary based on experience and location. Additionally, there is an opportunity for an annual bonus and merit increase based on performance.