Procurement & Supply Chain Data Analytics Specialist

Description

POSITION DESCRIPTION:

This position is responsible for end-to-end SCM data management, PSI analysis (Purchase–Sales–Inventory), vendor performance evaluation, and ERP information integrity. The role will support Procurement, Logistics, Sales Operations, and Finance by calculating optimal purchasing timing and quantities based on demand forecasts, safety stock models, and lead-time planning. The position is based in San Franciso, California; 10% of domestic travel may be required.

RESPONSIBILITIES

- Develop and manage PSI dashboards to determine optimal purchase timing, reorder points, minimum order quantities, and supply planning scenarios.

- Analyze historical demand, installation forecasts, vendor lead times, and inventory turns to recommend procurement strategies.

- Maintain vendor master data including pricing, contractual lead times, MOQ, freight terms, and performance KPIs.

- Perform supply chain data auditing between ERP systems to ensure information accuracy and consistency.

- Monitor and validate BOM accuracy and update material attributes to support procurement planning.

- Prepare monthly supply chain risk reports, including material shortage risk, excess/obsolete status, and forecast accuracy metrics.

- Conduct root cause analysis for supply delays, forecast deviations, and ERP data gaps.

- Support S&OP meetings with supply/demand balancing analysis.

- Collaborate with procurement to propose optimized order strategies based on inventory aging reports, consumption trends, and budget control.

- Maintain and improve data pipelines to track PO life cycle, inbound shipments, and invoice matching accuracy.

- Create automated reporting tools in Excel (Power Query, PowerPivot, Macros), and assist in the transition to internal BI platforms.

- Work closely with internal stakeholders including Engineering, Fulfillment, Project Delivery, and Finance to support data-driven decision-making.

- Perform other duties and special projects, as assigned.

REQUIRED QUALIFICATIONS

- Bachelor’s degree + 5+ years of experience in Supply Chain, Procurement, Business Analysis, or related field.

- Proven experience in PSI planning, demand forecasting, or material requirements planning (MRP).

- Strong understanding of procurement processes, lead-time calculation, and inventory management principles.

- Experience with ERP data management (e.g., Rootstock, Salesforce, SAP, Oracle, NetSuite, Dynamics).

- Ability to analyze large datasets and develop actionable business insights.

- Advanced Excel skills: VLOOKUP/XLOOKUP, COUNTIFS, Power Query, Pivot Tables, data modeling.

- Excellent written and verbal communication skills.

- Critical and strategic thinking skills with the ability to solve complex supply chain problems.

- Ability to prioritize multiple and simultaneous projects under tight deadlines.

- Strong interpersonal, cross-functional collaboration, and facilitation skills.

- Self-motivated, proactive, and detail-oriented team player.

PREFERRED QUALIFICATIONS

- BI tool experience (Tableau, Power BI, Looker, or similar)

- SQL query knowledge

- S&OP / MRP / demand planning experience

- Solar, construction material, or manufacturing industry experience

Hanwha Q CELLS America Inc. (“HQCA”) is a Qcells company, one of the world’s largest manufacturers and providers of solar photovoltaic (PV) products and solutions. Headquartered in Irvine, California, HQCA has been rapidly expanding its business in North America through the expansion of products and solutions, including distributed energy solutions, direct-to-homeowner solar sales and financing, and EPC services. We provide an opportunity to be part of an exciting and growing world-class global business in an interesting and expanding industry of the future.

PHYSICAL, MENTAL & ENVIRONMENTAL DEMANDS:

To comply with the Rehabilitation Act of 1973 the essential physical, mental and environmental requirements for this job are listed below. These are requirements normally expected to perform regular job duties. Incumbent must be able to successfully perform all of the functions of the job with or without reasonable accommodation.

Mobility

Standing

20% of time

Sitting

70% of time

Walking

10% of time

Strength

Pulling

up to 10 Pounds

Pushing

up to 10 Pounds

Carrying

up to 10 Pounds

Lifting

up to 10 Pounds

Dexterity (F = Frequently, O = Occasionally, N = Never)

Typing

F

Handling

F

Reaching

F

Agility (F = Frequently, O = Occasionally, N = Never)

Turning

F

Twisting

F

Bending

O

Crouching

O

Balancing

N

Climbing

N

Crawling

N

Kneeling

N

The salary range is required by the California Pay Transparency Act and may differ depending on the location of those candidates hired nationwide. Actual compensation is influenced by a wide array of factors including but not limited to, skill set, education, licenses and certifications, essential job duties and requirements, and the necessary experience relative to the job’s minimum qualifications.

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

You may view your privacy rights by reviewing Qcells' Privacy Policy or by contacting our HR team for a copy.