Supply Chain Business Analyst

Supply Chain Business Analyst ContractorWe 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.Business Analysis & Stakeholder PartnershipPartner 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 DevelopmentDesign, 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 & GovernanceDesign 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, exception-handling, and quality-control processes to build trust in forecast outputs.Model Sustainability & SupportOwn the ongoing maintenance and enhancement of the supplier forecast model after initial deployment.Document data sources, transformations, formulas, VBA code, business rules, assumptions, refresh processes, dependencies, version control, and support procedures.Diagnose and resolve data, calculation, macro, refresh, performance, and usability issues in partnership with business and technical teams.Create reusable standards, templates, controls, and development practices that reduce dependency on individual developers.Train business users and designated support resources on model usage, forecast interpretation, data refresh, and basic troubleshooting.