Supply Chain Analyst Job at LHH, Mount Prospect, IL

L0RBM0RsMm1BNTZ5YzRRZ2hnT1hpeTQ3Nnc9PQ==
  • LHH
  • Mount Prospect, IL

Job Description

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 platforms
  • Standardize 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 tools

Planning & Inventory Analytics

  • Translate demand and supply signals into MRP exception reports and inventory dashboards
  • Model safety stock and reorder points; monitor lead-time accuracy
  • Map raw materials to intermediates and finished goods using production calendars

Logistics & Internal Transfers

  • Automate BOL workflows and track SLA compliance
  • Monitor ASN accuracy and its impact on receiving performance
  • Track internal transfers for cycle time, accuracy, and discrepancies

Supplier & Cost Analytics

  • Develop supplier scorecards (OTD, quality, responsiveness, lead-time, PPV)
  • Analyze freight and expedite costs; recommend sourcing or planning adjustments

S&OE / S&OP Support

  • Publish daily execution exceptions and weekly planning summaries
  • Conduct root-cause analysis and track corrective actions

Automation & Tools

  • Build dashboards in Power BI and Excel (Power Query/Pivot)
  • Create Power Automate flows; write SQL and optionally Python for data transformation

Key Performance Indicators (KPIs):

  • Service : OTIF/fill rate, backorders, allocation accuracy
  • Inventory : DOH/turns, slow/obsolete %, expiry risk exposure, master data accuracy
  • Execution : MRP exception resolution, supplier OTD, ASN accuracy, BOL cycle time
  • Data Quality : Data defect rate, resolution time, audit pass rate

Qualifications:

  • Bachelor’s degree in Supply Chain, Industrial Engineering, Data/Business Analytics, or related field; Master’s degree is a plus
  • 3–6+ years of experience in supply chain analytics or planning within a manufacturing environment; experience in regulated, pharmaceutical, or CPG liquids preferred
  • Proficiency in Excel (Power Query), Power BI (DAX, data modeling), and SQL; experience with Sage 100
  • Familiarity with MRP, BOMs/routings, safety stock modeling, UoM conversions, and lot/expiry tracking
  • Strong communication skills and a continuous improvement mindset

Preferred 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 Act
  • Los Angeles City Fair Chance Ordinance
  • Los Angeles County Fair Chance Ordinance for Employers
  • San Francisco Fair Chance Ordinance

Job Tags

Full time, Local area,

Similar Jobs

Aviva Glendale

STNA or CNA PT/PRN night shift Job at Aviva Glendale

 ...loved ones are cared for and treated well Shift Details: We are currently searching for a Resident Assistant to join the night shift. Please note, this may change...  ...year of related work experience preferred, CNA preferred Ability to safely assist residents... 

ManTech

VMware Specialist Job at ManTech

 ...Salary: $100,000 - 140,000 per year Requirements: High School Diploma More than 5 years of experience in overseeing VMware vSphere environments Expertise in VMware vSphere, vCenter Server, and ESXi administration Solid understanding and experience with virtualization... 

Hire Counsel

Paralegal Job at Hire Counsel

 ...Hire Counsel is seeking a paralegal to work with the federal government in Texarkana, AR. Must be able to obtain and maintain an MRPT security clearance. Responsibilities Include: Working with multiple Assistant United States Attorneys Examining, preparing,... 

Hays

Project Engineer - Civil Construction Job at Hays

 ...Our client is a trusted name in heavy civil construction across the Gulf Coast region. Thir reputation reputation is built on precision...  ...We are seeking a highly motivated Civil Construction Project Engineer to support field operations and project management on heavy... 

Feral Fungi

Lead Sales Representative Job at Feral Fungi

 ...Lead Sales Representative Feral Fungi is a family-owned company passionate about producing high-quality, sustainably sourced mushroom...  ...experience in sales and account management within the wellness, food, or related industries, with at least 5 years in a leadership...