Supply Chain Analyst

automated reporting workflows & interactive dashboards using SQL SSRS database queries Excel Power Query & Visual Studio to automate daily data extraction; refresh processes reduce manual reporting time & improve internal data visibility.

sales & inventory datasets using SQL & Excel (Pivot Tables moving averages trend analysis) to identify demand patterns inventory risks & operational bottlenecks; provide data-supported recommendations to internal U.S. teams.

daily weekly & monthly reporting packages for inventory demand & supply performance ensuring accuracy consistency & on-time delivery across U.S. business functions.

business questions into precise data queries for report building create ad hoc analytical reports; summarize key findings into clear actionable insights for internal decision-making.

customer order patterns & sales trends across categories customers locations & product finishes using ERP (Sage) order histories & SQL-based dashboards identifying demand anomalies or emerging stock risks.

forecasting & inventory planning activities by preparing usage-based forecast models safety stock calculations & replenishment analyses aligned with CPIM (Certified in Planning & Inventory Management) planning methodologies.

& cleanse large datasets extracted from ERP systems including expired transfers open purchase orders requiring updates PLC (Product Life Cycle) items needing modifications & long-pending backorders.

in internal process improvement initiatives by identifying workflow gaps in tasks such as PO importing transfer creation & inbound information requests; recommend automation or standardization solutions.

with internal U.S teams including Sales Operations & Finance-on routine planning tasks such as purchase order review demand reconciliation & inventory tracking.

demand & supply planning models using SQL CPIM methodologies & statistical techniques to optimize replenishment strategies for USChina supply flows.

automated cross-border reporting systems consolidating data required by US & China teams with standardized formats regular refreshes & performance tracking.

delivery performance of China-based suppliers including on-time delivery lead-time behavior & shipment patterns using ERP (Sage) & SQL analytics. These tasks involve communication in Mandarin Chinese with Chinese manufacturing plants regarding delivery performance & shipment coordination.

US demand priorities forecast changes & inventory requirements to China planning teams & suppliers including communications in Mandarin Chinese to support accurate execution.

cross-time-zone coordination by engaging China teams during their working hours to address urgent supply disruptions or order changes.

U.S. customer ordering patterns category shifts & seasonal demand trends into actionable supply instructions for China suppliers.

with China-based suppliers to resolve data discrepancies & order or shipment issues thru data validation corrective guidance & follow-up including communications in Mandarin Chinese.

supply readiness planning for new product onboarding & ramp-ups by aligning US forecast requirements with China suppliers capacity & timing constraints as communicated with China teams in Mandarin Chinese when required.

supply risks such as capacity constraints shipment delays or abnormal demand spikes & coordinate cross-regional mitigation actions.

China-based teams on interpreting automated reports KPI definitions & US planning logic including training & explanations in Mandarin Chinese to ensure consistent execution across regions.

At least a bachelors degree in Statistics Business Computer Science or a closely related quantitative discipline plus 2 years of post-baccalaureate experience working as Supply Chain Analyst Operations Research Analyst Logistics Analyst Logistics Management Analyst or closely related positions. Foreign degree equivalent is acceptable. We will also accept any suitable combination of education training and/or experience. Experience should include minimum two years of working on SSRS database queries; Excel Power Query; Visual Studio; data extraction automation; sales & inventory datasets analysis; Excel Pivot Tables; inventory risks identification; sales trends monitoring; ERP (Sage); forecasting; replenishment analysis; identifying workflow gaps; demand reconciliation; inventory tracking.

Special Requirement: Must be Fluent in Mandarin Chinese Speaking Reading and Writing at native speaker proficiency level.

HOURS: M-F 9:00 a.m. 5:00 p.m.

JOB LOCATION: Suwanee GA 30024

CONTACT: Email resume referencing Job code #SCAEvermark to HR Manager Evermark LLC at