Project Planner and Supply Chain Analyst

Required Experience

• Minimum 5+ years of experience in Project Planning, Production Planning, Master Scheduling, or Supply Chain Planning.
• Proven experience developing and maintaining production schedules in a manufacturing environment.
• Strong background in demand planning, capacity planning, inventory management, and material forecasting.
• Demonstrated experience analyzing large datasets and transforming data into actionable business insights.
• Extensive experience creating reports, dashboards, KPIs, and management presentations.
• Experience supporting executive decision-making through data analysis and performance reporting.

Key Responsibilities

• Project & Production Planning
  • Develop and maintain integrated project and production schedules to support customer delivery requirements.
  • Coordinate production, procurement, inventory, and logistics activities to ensure schedule adherence.
  • Monitor schedule performance and proactively identify risks, delays, and resource constraints.
  • Manage capacity planning activities and recommend adjustments to support demand fluctuations.
• Data Analysis & Reporting
  • Analyze production, inventory, and supply chain data to identify trends, risks, and improvement opportunities.
  • Develop and maintain dashboards, scorecards, and performance metrics for management review.
  • Generate weekly and monthly reports on production performance, inventory levels, schedule attainment, material shortages, and operational KPIs.
  • Support business decisions through detailed data analysis and forecasting models.

Technical Competencies

Proficiency in Microsoft Excel, pivot Tables, XLOOKUP/VLOOKUP, INDEX/MATCH, Power Query, Conditional Formatting, Data Validation, Complex Formulas, Macros/VBA (preferred), Dashboard Development, Ability to analyze large datasets and create executive-level reports and visualizations.

Other Tools: Experience with ERP/MRP systems such as SAP, Oracle, Microsoft Dynamics, or similar, Basic experience with Power BI.

Soft Skills

• Problem-solving: Rapid troubleshooting mindset for complex global logistics bottlenecks.
• Communication: Translating dense datasets into strategic, plain-language insights for company executives.
• Negotiation: Comfort collaborating with third-party vendors on pricing and lead times.

Preferred Qualifications

• Bachelor's degree in Supply Chain Management, Industrial Engineering, Business Administration, Operations Management, or related field.
• APICS CPIM or CSCP certification preferred.
• PMP certification is a plus.