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, 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. Required Qualifications Bachelor's degree in business, Supply Chain, Engineering, Information Systems, Analytics, Computer Science, or a related field, or equivalent professional experience. Demonstrated experience in business analysis, supply chain analytics, forecasting, data modeling, or a related field, with substantial hands‑on Microsoft Excel experience. Advanced proficiency in Microsoft Excel, including VBA macros, complex formulas, charts, PivotTables, data validation, structured tables, and performance optimization. Strong logical reasoning and the ability to convert complex business rules into reliable calculations, formulas, and automation logic. Strong data-modeling and analytical skills, including relationships, data granularity, scenario logic, reusable model structures, and performance-conscious design. Proven ability to use Excel VBA macros to automate repeatable processes, improve data quality, and reduce manual effort. Working knowledge of Power Query, SQL, and data integration concepts. Demonstrated ability to gather requirements, challenge assumptions constructively, analyze complex data, identify gaps, and present findings in a clear and decision-oriented manner. Strong written and verbal communication skills, exceptional attention to detail, and the ability to work independently in a fast-paced contractor environment. Supply Chain Knowledge The candidate should understand core supply chain concepts and have practical exposure to several of the following: Sales & Operations Planning (S&OP), demand planning, and integrated planning processes Supplier forecasting, supply planning, backlog, capacity, and constraint visibility Bill of Material structures, material requirements, inventory availability, shortages, and working capital Manufacturing and project schedules, production plans, throughput, schedule adherence, and quality Procurement, supplier allocation, supplier capacity, performance, lead times, cost, and purchase-order visibility Logistics, transportation, regional lead times, delivery performance, and order fulfillment Forecast accuracy, scenario analysis, exception management, KPI governance, and root-cause analysis Preferred Qualifications Experience supporting a global or multi-region supply chain organization. Experience with ERP and planning platforms such as SAP, Oracle, NetSuite, or similar systems. Familiarity with Power BI, Power Automate, Microsoft Fabric, Azure data services, or Python. Experience developing supplier forecast models, planning tools, or management reporting for leadership reviews. Experience establishing model-development standards, documentation, testing, change control, version management, and user-adoption practices. APICS or ASCM certification, training, or equivalent practical supply chain experience. Engagement Deliverables & Success Measures Deliver a clear, scalable, and validated supplier forecast model using supply chain, project, product, and supplier data. Establish trusted business-rule definitions, assumptions, forecast logic, and transparent calculations aligned with business owners. Create reusable model structures that support future forecast requirements without unnecessary redevelopment. Use Excel VBA macros, formulas, PivotTables, and Power Query to improve automation, refresh reliability, data quality, and forecast-cycle speed. Provide business insights that help leaders identify supplier risks, demand changes, capacity constraints, priorities, and actions. Complete business, technical, code, and user documentation to support long-term ownership and continuity. Enable internal users to operate, understand, troubleshoot, and sustain the supplier forecast model after the engagement. #J-18808-Ljbffr IS International Services