Supply Chain Analyst – Full-Time | Mount Prospect, IL
Compensation :
This position offers a salary range of $75,000 – $95,000 per year , depending on experience and qualifications.
Bonus eligibility and amount are based upon company and / or individual performance.
Additional Compensation :
This role is not eligible for commissions, stock options, or profit sharing.
Benefits Offered :
Benefit offerings for full-time employment include :
- Medical, dental, and vision insurance
- 401(k) plan with employer match or a non-qualified deferred compensation plan
Work Arrangements :
This is an on-site role that has potential for hybrid after 6 months.
Position Summary :
The Supply Chain Analyst will support manufacturing operations in a regulated, batch-production environment. This role is responsible for building and managing data pipelines, dashboards, and exception reports that drive improvements in service levels, cost efficiency, and inventory management, while maintaining compliance with cGMP standards.
Key Responsibilities :
Data, Pipelines & Governance
Build and maintain data flows from ERP (e.g., Sage 100), quality systems, and logistics platformsStandardize and validate master data (e.g., UoM conversions, lead times, shelf life, lot / COA linkage)Document data lineage and retention policies using SharePoint and data governance toolsPlanning & Inventory Analytics
Translate demand and supply signals into MRP exception reports and inventory dashboardsModel safety stock and reorder points; monitor lead-time accuracyMap raw materials to intermediates and finished goods using production calendarsLogistics & Internal Transfers
Automate BOL workflows and track SLA complianceMonitor ASN accuracy and its impact on receiving performanceTrack internal transfers for cycle time, accuracy, and discrepanciesSupplier & Cost Analytics
Develop supplier scorecards (OTD, quality, responsiveness, lead-time, PPV)Analyze freight and expedite costs; recommend sourcing or planning adjustmentsS&OE / S&OP Support
Publish daily execution exceptions and weekly planning summariesConduct root-cause analysis and track corrective actionsAutomation & Tools
Build dashboards in Power BI and Excel (Power Query / Pivot)Create Power Automate flows; write SQL and optionally Python for data transformationKey Performance Indicators (KPIs) :
Service : OTIF / fill rate, backorders, allocation accuracyInventory : DOH / turns, slow / obsolete %, expiry risk exposure, master data accuracyExecution : MRP exception resolution, supplier OTD, ASN accuracy, BOL cycle timeData Quality : Data defect rate, resolution time, audit pass rateQualifications :
Bachelor’s degree in Supply Chain, Industrial Engineering, Data / Business Analytics, or related field; Master’s degree is a plus3–6+ years of experience in supply chain analytics or planning within a manufacturing environment; experience in regulated, pharmaceutical, or CPG liquids preferredProficiency in Excel (Power Query), Power BI (DAX, data modeling), and SQL; experience with Sage 100Familiarity with MRP, BOMs / routings, safety stock modeling, UoM conversions, and lot / expiry trackingStrong communication skills and a continuous improvement mindsetPreferred Skills & Certifications :
ASCM CPIM / CSCP, Python for analytics, Power Automate / SharePoint administration, ASN / BOL integration, cGMP documentation practices
Legal Disclaimers :
Equal Opportunity Employer / Veterans / Disabled
To read our Candidate Privacy Information Statement, which explains how we will use your information, please navigate to
The Company will consider qualified applicants with arrest and conviction records in accordance with federal, state, and local laws and / or security clearance requirements, including, as applicable :
The California Fair Chance ActLos Angeles City Fair Chance OrdinanceLos Angeles County Fair Chance Ordinance for EmployersSan Francisco Fair Chance Ordinance