Supply Chain Data Analyst

If you are an analytical powerhouse who thrives at the intersection of data manipulation and investigative auditing, this is your sandbox. This is a high-priority, 6-month special audit project in partnership with the client's Internal Audit team. This isn\'t just a data entry gig—it\'s a fast-paced, collaborative mission where you will have total ownership of your work, dig into the "why" behind the numbers, and directly impact the client\'s supply chain integrity. Running on an optimal 10:00 AM - 6:00 PM shift, this role offers the perfect balance of team collaboration and independent execution. Salary: $34 - $35 per hour, Shift: First, Work hours: 10 AM - 6 PM, Education: Bachelors. Responsibilities Data Investigation & Integrity: Dive deep into inventory and sales data pools to hunt down, analyze, and resolve discrepancies before they impact the business. Precision Forecasting & Order Management: Flawlessly execute and adjust high-stakes Purchase Orders and forecasted orders, ensuring every piece of data aligns perfectly with timelines. Logistical Problem-Solving: Put your mathematical skills to work by calculating truck capacities and pallet weights, ensuring our logistics are as efficient as our data. Variance Auditing: Own the tracking of variances (ordered vs. received, forecasted vs. actual sales, and ending inventory vs. targets) to keep our records immaculate. Supply Chain Tracing & Troubleshooting: Keep a pulse on supplier portals and inbound orders, proactively tracking shipments to guarantee delivery windows are met and system glitches are quickly resolved. Cross-Functional Collaboration: Partner directly with the Operations team to ensure physical reality matches our digital data, keeping SKU records accurate across all internal systems. Heavy Excel Usage: High proficiency in Microsoft Excel is non-negotiable. You should easily navigate massive pools of data using advanced formulas like V-LOOKUPs and X-LOOKUPs. Skills Bachelor Degree (4 years of experience is preferred) Data Entry Skills (4 years of experience is required) Microsoft Excel (4 years of experience is required) Excel Pivot Tables (2 years of experience is required) Math and Calculation (2 years of experience is required) Data Analysis (2 years of experience is preferred) Data Manipulation Inventory Auditing (2 years of experience is preferred) SKU understanding Ability to hit deadlines Organizational Skills Critical Thinking Skills Analytical Thinking Reporting SAP Blue Yonder Food or Beverage Industry (1 year of experience is preferred) Purchase Orders Variance Analysis Problem Solving Qualifications Years of experience: 2 years Experience level: Experienced Education: Bachelors Benefits Pay offered to a successful candidate will be based on several factors including the candidate\'s education, work experience, work location, specific job duties, certifications, etc. In addition, the employer offers a comprehensive benefits package, including medical, prescription, dental, vision, AD&D, and life insurance offerings, short-term disability, and a 401K plan (all benefits are based on eligibility). Posting Duration This posting is open for thirty (30) days. Equal Opportunity Employer Race, Color, Religion, Sex, Sexual Orientation, Gender Identity, National Origin, Age, Genetic Information, Disability, Protected Veteran Status, or any other legally protected group status. We welcome people of all abilities and want to ensure that our hiring and interview process meets the needs of all applicants. If you require a reasonable accommodation to make your application or interview experience a great one, please contact View email address on click.appcast.io. #J-18808-Ljbffr Randstad USA