Supply Chain Business Analyst

Supply Chain Business Analyst Contractor

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.

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, exception-handling, and quality-control processes to build trust in forecast outputs.

Model Sustainability & Support

• Own 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.