Supply Chain Business Analyst

Position Summary We are seeking a highly capable Supply Chain Business Analyst Contractor to lead business analysis and support the development of a supplier forecast model. The contractor will rapidly learn complex supply chain processes, translate business needs into clear model requirements, and build practical, accurate, and user-friendly Excel-based solutions that improve supplier demand visibility and planning decisions. The ideal candidate is a fast learner with strong logical reasoning, structured problem-solving skills, and advanced Microsoft Excel expertise. This individual will own the end-to-end analytical lifecycle, from requirements gathering and business-rule definition through model design, VBA automation, validation, documentation, user enablement, and ongoing support. Key Responsibilities Business Analysis & Stakeholder Partnership Partner with supply chain, sourcing, procurement, planning, logistics, manufacturing, operations, and leadership teams to understand supplier forecasting needs. Translate business questions into clear functional requirements, business rules, data specifications, calculation logic, and model outputs. Facilitate requirement-gathering sessions, map current and future-state processes, document assumptions and exceptions, and align stakeholders on definitions and expected outcomes. Communicate clearly with technical and non-technical audiences and serve as the bridge between business stakeholders, data owners, and solution developers. Supplier Forecast Model Development Design, develop, test, deploy, and maintain an Excel-based supplier forecast model that is reliable, scalable, and easy to use. Create intuitive model outputs and charts that help users quickly understand supplier demand, timing, trends, exceptions, risks, and required actions. Develop forecast logic across customer demand, project schedules, product configuration, material requirements, supplier allocation, lead times, and planning horizons. Build effective filtering, scenario analysis, data refresh, navigation, input controls, and self-service capabilities while maintaining a consistent user experience. Optimize model performance, calculation speed, refresh reliability, usability, maintainability, and user adoption. Data Analysis, Integration & Governance Design scalable, reusable, and well-structured data models that can support changing supplier forecast requirements. Integrate, cleanse, reconcile, and transform data from ERP, planning, manufacturing, operational, Excel, SharePoint, database, and other approved sources. Use advanced Excel formulas, Power Query, VBA macros, PivotTables, and established data-modeling practices to prepare reliable forecast datasets and outputs. Ensure data accuracy, consistent business logic, transparent assumptions, traceability, appropriate access controls, and adherence to data governance standards. Establish robust validation, reconciliation,…