Supply Chain Analyst

Evermark LLC•Suwanee, GA

1d•Onsite

About The Position

This role involves developing automated reporting workflows and interactive dashboards using SQL, SSRS, Excel Power Query, and Visual Studio to streamline data extraction and reduce manual reporting time. The analyst will examine sales and inventory data to identify demand patterns, risks, and bottlenecks, providing data-supported recommendations to internal U.S. teams. Responsibilities include maintaining daily, weekly, and monthly reporting packages, converting business questions into data queries, and creating ad hoc analytical reports. The position requires monitoring customer order patterns and sales trends using ERP systems and SQL dashboards, supporting forecasting and inventory planning with various models and calculations, and validating/cleansing large datasets from ERP systems. The analyst will also assist in process improvement initiatives, collaborate with internal U.S. teams (Sales, Operations, Finance), and develop demand and supply planning models for US-China supply flows. Additionally, the role involves designing automated cross-border reporting systems, analyzing delivery performance of China-based suppliers, communicating US demand priorities to China teams, supporting cross-time-zone coordination, converting US demand into supply instructions for China suppliers, resolving data discrepancies with China suppliers, leading supply readiness planning for new products, identifying supply risks, and guiding China-based teams on interpreting reports and planning logic. Communication in Mandarin Chinese is essential for many of these tasks.

Requirements

Bachelor’s degree in Statistics, Business, Computer Science or a closely related quantitative discipline.
2 years of post-baccalaureate experience working as Supply Chain Analyst, Operations Research Analyst, Logistics Analyst, Logistics Management Analyst, or closely related positions.
Minimum two years of working on SSRS database queries.
Minimum two years of working on Excel Power Query.
Minimum two years of working on Visual Studio.
Minimum two years of experience in data extraction automation.
Minimum two years of experience in sales & inventory datasets analysis.
Minimum two years of experience with Excel Pivot Tables.
Minimum two years of experience in inventory risks identification.
Minimum two years of experience in sales trends monitoring.
Minimum two years of experience with ERP (Sage).
Minimum two years of experience in forecasting.
Minimum two years of experience in replenishment analysis.
Minimum two years of experience in identifying workflow gaps.
Minimum two years of experience in demand reconciliation.
Minimum two years of experience in inventory tracking.
Fluent in Mandarin Chinese Speaking, Reading, and Writing at native speaker proficiency level.

Nice To Haves

CPIM (Certified in Planning & Inventory Management) planning methodologies.

Responsibilities

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.
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.
Maintain daily, weekly & monthly reporting packages for inventory, demand & supply performance, ensuring accuracy, consistency & on-time delivery across U.S. business functions.
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.
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.
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.
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.
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.
Collaborate with internal U.S teams, including Sales, Operations & Finance-on routine planning tasks such as purchase order review, demand reconciliation & inventory tracking.
Develop demand & supply planning models using SQL, CPIM methodologies & statistical techniques to optimize replenishment strategies for US–China supply flows.
Design automated cross-border reporting systems consolidating data required by US & China teams, with standardized formats, regular refreshes & performance tracking.
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.
Communicate US demand priorities, forecast changes & inventory requirements to China planning teams & suppliers, including communications in Mandarin Chinese, to support accurate execution.
Support cross-time-zone coordination by engaging China teams during their working hours to address urgent supply disruptions or order changes.
Convert U.S. customer ordering patterns, category shifts & seasonal demand trends into actionable supply instructions for China suppliers.
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.
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.
Identify supply risks such as capacity constraints, shipment delays, or abnormal demand spikes & coordinate cross-regional mitigation actions.
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.