What are the responsibilities and job description for the SAP Supply chain and AI automation specialist position at SightSpectrum LLC?
Job title: SAP Supply chain and AI automation specialist
Location: On-site / Hybrid - Chicago / Salt Lake City
Key responsibilities
SAP analysis & traceability
- Lead end-to-end analysis of lot and batch traceability across SAP MM, PP, QM, and WM modules, identifying gaps in batch genealogy, shelf-life tracking, and FEFO compliance.
- Map traceability data flows across SAP tables (MCHA, MCH1, CHVW, MSEG) and document current-state problems with clear root-cause analysis.
- Design and implement configuration improvements within SAP S/4HANA to resolve traceability gaps, including batch classification, expiry date management, and goods movement tracking.
- Support recall readiness by ensuring all finished goods lots can be traced back to raw material batches within minutes.
Demand planning & MRP
- Analyse existing MRP models and demand planning processes, identifying inefficiencies in reorder point logic, safety stock calculations, and planned order management.
- Build improved demand planning models that account for ingredient shelf life, seasonal demand patterns, and batch-specific supply constraints.
- Configure and fine-tune MRP parameters in SAP including planning horizons, lot sizing, and procurement lead times specific to food manufacturing.
- Provide expertise in SAP IBP or APO (advantageous) for statistical forecasting and supply-demand balancing.
Copilot Studio - build & showcase
- Design, build, and deploy intelligent agents using Microsoft Copilot Studio, connecting to SAP via OData APIs and the SAP Power Platform connector.
- Deliver working applications including a natural-language lot traceability agent, a demand planning assistant, a recall impact assessment tool, and an executive supply chain summary copilot.
- Build Power Automate flows to orchestrate SAP data retrieval, exception alerting, and approval workflows triggered through Copilot Studio.
- Showcase solutions to business stakeholders through structured demonstrations, collecting feedback and iterating rapidly on the applications.
- Embed solutions into Microsoft Teams and web channels for broad business user adoption.
Stakeholder engagement
- Work closely with supply chain managers, quality teams, warehouse operatives, and senior leadership to understand pain points and translate them into technical requirements.
- Produce clear process documentation, solution design documents, and user guides for every application delivered.
- Run workshops and training sessions to embed Copilot Studio tools within day-to-day operations.
Required skills & competencies
| Competency area | What we need |
| SAP lot traceability | Hands-on experience with SAP batch management, FEFO, shelf-life settings, and batch where-used reports in MM/PP/QM/WM. Familiarity with GS1 traceability standards. |
| SAP MRP & demand planning | Proven ability to configure and optimise MRP in SAP S/4HANA - reorder points, safety stock, lot sizing, MRP types. SAP IBP or APO experience is a strong advantage. |
| SAP modules | Functional expertise across at minimum three of: MM, PP, QM, WM/EWM, SD. Food or FMCG manufacturing experience required. |
| Microsoft Copilot Studio | Ability to design and build custom copilots, topics, actions, and Power Automate flows. Experience connecting copilots to external systems via APIs. |
| Power Platform | Proficiency in Power Automate, Power BI, and Dataverse. Experience using SAP connectors within the Power Platform ecosystem. |
| API & integration | Working knowledge of OData APIs, REST, and SAP BTP or equivalent integration middleware for connecting SAP to external applications. |
| Food manufacturing domain | Understanding of food safety regulations, allergen management, traceability requirements (FSMA, HACCP), and production scheduling in an FMCG environment. |
| Stakeholder communication | Able to present complex SAP and AI topics clearly to non-technical business users. Experience facilitating workshops and delivering live system demonstrations. |
Desirable (not essential)
- SAP Certified Application Associate in MM, PP, or QM.
- Microsoft Power Platform Functional Consultant certification (PL-200) or Copilot Studio certification.
- Experience with Azure AI Services, Azure OpenAI, or Generative AI integration within Power Platform.
- Familiarity with GS1 digital link standards and barcode/RFID-based traceability systems.
- Prior experience delivering SAP transformation projects in a food, beverage, or nutraceutical business.