Supply Chain Analyst in Suwanee, Georgia at Evermark LLC

1.Develop 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.

2.Analyze 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.

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

4.Convert 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.

5.Monitor 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.

6.Support 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.

7.Validate & 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.

8.Assist 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.

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

10.Develop demand & supply planning models using SQL, CPIM methodologies & statistical techniques to optimize replenishment strategies for US–China supply flows.

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

12.Analyze 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.

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

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

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

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

17.Lead 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.

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

19.Guide 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 bachelor’s 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 #SCA05042026Evermark to HR Manager, Evermark LLC at wkennedy@evermark-lnl.com