Teruko Weinberg, Inc., job recruitment agency, is looking to fill the following Supply Chain Analyst – NC #11878 for its client in NC – Raleigh:
Title: Supply Chain Analyst – NC
Type: Direct Hire
FLSA: Exempt
Location: NC – Raleigh
Work Style: In-person
Hours: M to F 9:00 AM – 5:00 PM
Pay Range: $80,000~$85,000
Benefit: Medical, Dental, Life, Vision, 401K
Travel: 10%
Duties/Responsibilities:
1.) Data Integration & Delivery Projection (VBA-based Tool Development)
- Develop and maintain VBA-based tools to project delivery timelines against current order backlog
Integrate multiple data sources (inventory, in-transit shipments, order backlog) into a unified master file - Customize and modify tools based on changing customer requirements
- Improve data accuracy and build mechanisms to ensure data reliability and consistency
- Streamline and automate processes to enhance efficiency and reduce manual workload
- Transition Excel-based solutions into enterprise systems (e.g., RPL) for long-term scalability2.) Sales Result Reporting & Performance Analysis
- Prepare and maintain sales result reports for hyperscale customer programs based on D365 data, shipment records, purchase orders, and delivery status.
- Track actual sales results against customer forecasts, purchase orders, delivery plans, and monthly sales projections.
- Analyze monthly, quarterly, and year-to-date sales performance, including variances between forecasted sales and actual sales results.
- Identify key factors impacting sales results, including delivery delays, inventory shortages, production constraints, customer priority changes, and logistics issues.
- Coordinate with Sales, Finance, Supply Chain, Logistics, and Production teams to validate sales result data and ensure reporting accuracy.
- Create regular sales performance reports, dashboards, and summaries using D365 data, Excel, VBA, and other analytical tools.
- Provide management with timely updates on sales performance, risks, opportunities, and expected future sales based on current order backlog and delivery projections.
- Support month-end and quarter-end reporting activities by providing accurate sales, shipment, backlog, and inventory-related information.
- Continuously improve sales reporting processes through automation, data validation, and standardization of reporting formats.3.) Analyzing forecast from the large Hyperscale customer
Compare last purchase orders and the latest purchase orders to find out differences in between. - Estimate monthly sales based on the latest purchase orders.
- Utilize D365 data extraction and Excel VBA automation to analyze purchase orders changes, identify demand trends, highlight risks, and generate accurate planning reports.
- Coordinate with relevant internal teams to investigate root causes of delivery delays, provide explanations to customers, and support recovery actions to meet customer requirements.4.) Manages and coordinates multiple purchase orders and the related logistical aspects
- Receive multiple purchase orders for multiple different projects/delivery locations every week.
- Closely monitor status of production, shipment to warehouse and shipment from warehouse.
- Manage delivery schedules by using D365 data, VBA tracking tools, and automated reports to monitor order status, inventory availability, shipment progress, and potential delays.
- Reflect change in priority of production and delivery based on customer request, and working with production entities and logistics partner to reflect such change in priority in timely manner enable deliveries to be made without delay.5.) Handle ERP (D365) system
- Input and update stock, delivery information in the system along with delivery schedule.
- Strongly encouraged to propose improvements on how to utilize D365’s functions based on actual work flow and needs.6.) Continued improvement activities
- Constant evaluation of company’s systems and processes to look for ways and/or methods to improve on current practices.
- Involvement with customer on projects related to system and process improvements
- Continually expanding knowledge base within D365.
- Work closely with production entities to identify operational improvement opportunities and drive continuous improvements in daily processes.7.) Interaction with internal and external employees
8.) Develop and prepare executive/administrative reports as directed
9.) Create KPI dashboards and forecast/delivery performance reports using D365 data, Excel VBA, and other analytical tools.
10) Support occasional matters as directed
Required Skills/Abilities:
- Ability to handle large volumes of data with high accuracy and attention to detail
- Strong data management skills, including validation, structuring, and consistency control
- Proficiency in Excel and VBA for data processing and automation
- Analytical thinking and problem-solving capability
- Flexibility to adapt to changing requirements and customize solutions accordingly
- Basic understanding of fiber optic cabling, connectorization, and network components.
- Advanced capability to analyze forecast, order, inventory, and delivery data using D365 and Excel VBA.
- Strong leadership skills with the ability to influence and drive change.
- Strong analytical, and project management skills.
- Proficiency in D365 systems and/or supply chain software.
- Excellent communication and interpersonal skills to build and maintain relationships.
- Ability to ensure fulfillment of customer requirements while effectively prioritizing and managing multiple tasks in a fast-paced environment.
- Knowledge and experience of quality assurance and control.
- Preferable skill: rich knowledge and experiences of VBA, Access, Java and/or other programming tools with actual experiences to implement automation of administrative transactions effectively.
- Pressure for deadlines – short time frame responses.
- Ability to process large amounts of email/chat traffic.
- Ability to efficiently communicate with others by summarizing problem, question, status and so on, instead of just forwarding e-mail or chat message without enough explanation.
- Willingness to work as a team, providing leadership to the department.
- Extremely well organized and must demonstrate some Project Management skills.
- Proven proficiency with Microsoft products especially Excel.
Excellent written and verbal skills. - Ability to proactively identify delivery risks and coordinate with internal/external stakeholders to achieve customer commitments.
- Ability to prepare and analyze sales result reports using D365, Excel, VBA, and other reporting tools.
- Ability to compare actual sales results against forecasts, purchase orders, delivery plans, and backlog.
- Ability to identify sales performance variances and explain root causes based on shipment, supply availability, production, and logistics status.
- Experience creating management reports, KPI dashboards, and sales performance summaries.
Education and Experience:
- Bachelor’s degree or minimum of 5 years relevant professional experience.
- Hands-on experience with Excel and VBA for data processing and automation
- Experience working with large and complex datasets, preferably in inventory, logistics, or order management
- Proven ability to develop data tools or reports to support business decision-making
- Proven experience within a supply chain management, project management, inventory management or production management.
If you are interested in the Supply Chain Analyst – NC #11878 position, please apply over online!

