layiq

/la·yiq/adjective

worthy; deserving; fitting; suitable.

A role, opportunity, or path that merits attention, time, and pursuit.

Supply Chain Business Analyst at IS International Services | LAYIQ

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

Supply Chain Business Analyst

Employer job description

Key Responsibilities

Requirements

Preferred Qualifications

About this listing