Strategic Sourcing & Analytics — Bonus Eligible

Hengstler-Dynapar; Illinois; On-site; USD 73,000 - 135,000; Full time

Job summary

Hengstler is seeking a Strategic Sourcing Analyst to support global commodity strategies, supplier performance, and data-driven decision making across Global Procurement. You will analyze spend, run RFQs, coordinate with engineering and finance, and help deliver savings and continuity.

Candidates should have 5+ years in procurement or data analytics, strong Excel, Power BI, SQL, and ERP/MRP familiarity, and a bachelor’s degree in a related field. CPSM or Power BI Data Analyst cert is a plus.

Qualifications

• Strong analytical, commercial, project-management, communication, negotiation, and problem-solving skills.
• Advanced Microsoft Excel skills and proficiency with data analytics, reporting, visualization, and business-intelligence tools; Power BI, Power Query, and DAX experience preferred.
• Working knowledge of ERP/MRP systems and manufacturing supply chains; experience with data warehouses or SQL is preferred.
• Ability to translate complex data into concise insights, business implications, and recommended actions.
• Strong attention to data accuracy, governance, documentation, and repeatable processes.

Responsibilities

• Support global commodity strategies and convert priorities into sourcing projects, negotiations, milestones, and implementation plans.
• Execute sourcing activities from opportunity identification and RFQ through analysis, supplier selection, implementation, and savings realization.
• Analyze spend, quotations, market conditions, cost drivers, capacity, lead times, and demand to identify savings opportunities and supply risks.
• Support PPV, VAVE, competitive bidding, supplier consolidation, resourcing, and other productivity initiatives.
• Prepare sourcing recommendations, total-cost analyses, business cases, and executive-ready presentations.
• Support supplier negotiations, commercial terms, alternate-source development, capacity reviews, recovery plans, and business-continuity actions.
• Coordinate with Engineering, Quality, Operations, Finance, Materials, regional procurement teams, and suppliers to deliver project objectives.
• Support supplier scorecards, business reviews, corrective actions, development plans, and escalation follow-up.
• Develop and deliver data analytics and decision-support solutions that improve visibility, data integrity, and fact-based decision-making across Global Procurement and the supply chain.
• Integrate, reconcile, and validate ERP/MRP, data-warehouse, sourcing, and supplier data to improve accuracy, consistency, traceability, and accessibility.
• Maintain standard metric definitions, reporting logic, data dictionaries, and self-service reporting that provide a reliable source of truth.
• Automate recurring analyses and provide ad hoc decision support for sourcing, negotiations, productivity, and risk mitigation.
• Maintain accurate project trackers, savings forecasts, risk registers, sourcing documentation, and reporting.
• Manage multiple sourcing projects, analytics priorities, and supply escalations with urgency and disciplined follow-through.

Skills

Analytical

Project management

Communication

Negotiation

Problem solving

Education

Bachelor's degree

Tools

Power BI

Power Query

DAX

SQL

ERP/MRP

Job description

Hengstler is seeking a Strategic Sourcing Analyst to support global commodity strategies, supplier performance, and data-driven decision making across Global Procurement. You will analyze spend, run RFQs, coordinate with engineering and finance, and help deliver savings and continuity.

Candidates should have 5+ years in procurement or data analytics, strong Excel, Power BI, SQL, and ERP/MRP familiarity, and a bachelor’s degree in a related field. CPSM or Power BI Data Analyst cert is a plus.