Procurement & Supply Chain Data Analytics Specialist

Description

• Work closely with internal stakeholders including Engineering, Fulfillment, Project Delivery, and Finance to support data-driven decision-making.
• Monitor and validate BOM accuracy and update material attributes to support procurement planning.
• Maintain vendor master data including pricing, contractual lead times, MOQ, freight terms, and performance KPIs.
• Create automated reporting tools in Excel (Power Query, PowerPivot, Macros), and assist in the transition to internal BI platforms.
• Prepare monthly supply chain risk reports, including material shortage risk, excess/obsolete status, and forecast accuracy metrics.
• Maintain and improve data pipelines to track PO life cycle, inbound shipments, and invoice matching accuracy.
• Conduct root cause analysis for supply delays, forecast deviations, and ERP data gaps.
• Collaborate with procurement to propose optimized order strategies based on inventory aging reports, consumption trends, and budget control.
• Support S&OP meetings with supply/demand balancing analysis.
• Analyze historical demand, installation forecasts, vendor lead times, and inventory turns to recommend procurement strategies.
• Develop and manage PSI dashboards to determine optimal purchase timing, reorder points, minimum order quantities, and supply planning scenarios.
• Perform supply chain data auditing between ERP systems to ensure information accuracy and consistency.

Requirements

• Advanced Excel skills: VLOOKUP/XLOOKUP, COUNTIFS, Power Query, Pivot Tables, data modeling.
• Self-motivated, proactive, and detail-oriented team player.
• Excellent written and verbal communication skills.
• SQL query knowledge
• Ability to prioritize multiple and simultaneous projects under tight deadlines.
• Strong interpersonal, cross-functional collaboration, and facilitation skills.
• Critical and strategic thinking skills with the ability to solve complex supply chain problems.
• Proven experience in PSI planning, demand forecasting, or material requirements planning (MRP).
• Strong understanding of procurement processes, lead-time calculation, and inventory management principles.
• BI tool experience (Tableau, Power BI, Looker, or similar)
• Bachelor’s degree + 5+ years of experience in Supply Chain, Procurement, Business Analysis, or related field.
• Experience with ERP data management (e.g., Rootstock, Salesforce, SAP, Oracle, NetSuite, Dynamics).
• Solar, construction material, or manufacturing industry experience
• Ability to analyze large datasets and develop actionable business insights.
• S&OP / MRP / demand planning experience

Benefits

• This target salary range is for CA positions only and should not be interpreted as an offer of compensation.

Training + Development

Interview process

Visa Sponsorship

Security clearance