Hybrid Supply Chain Systems Analyst

at The Agency

• Job title: Supply Chain Systems Analyst
• Job type: Full Time
• Experience level: Mid level, Senior
• Salary: $63,000 - $70,000 per year
• Degree requirement: Bachelor's Degree
• Tech skills: ERP, MySQL, SQL
• Location requirements: Hybrid, Chicago, United States

About the role

• Supply Chain Systems Analyst driving process excellence and data integrity for plant-based meal delivery. Partnering with teams across operations to enhance efficiency and scalability.

Responsibilities

• Support and execute critical data and workflow processes across Purple Carrot’s Supply Chain systems, including Fishbowl ERP, Galley Menu Planner, Google Sheets, Microsoft Excel, Google Apps Script, Looker, and SQL-based reporting tools.
• Manage data flow across internal systems and databases, including data entry, updates, imports, exports, and reconciliations, with a strong focus on accuracy and data integrity.
• Support recurring Bill of Materials (BOM) and recipe workflows for weekly meal kits and prepared meals, including transferring, transforming, and validating data between Galley and Fishbowl.
• Maintain and enhance spreadsheet- and script-based workflows that support menu planning, ingredient and item setup, unit-of-measure conversions, and other cross-functional supply chain processes.
• Investigate discrepancies, troubleshoot system and workflow issues, and perform root-cause analysis to resolve errors before they impact downstream operations.
• Serve as a subject matter expert for core Supply Chain tools and support internal users across Operations, Culinary, Procurement, and related teams.
• Create, update, and maintain reports and dashboards that support operational visibility and business decision-making, including reporting in Fishbowl and dashboard development in Looker.
• Support the setup and maintenance of core item, vendor, pricing, ingredient, and packaging data in Fishbowl and related systems to ensure operational and financial processes are supported by reliable, well-maintained data.
• Assist with ad-hoc projects and tasks as necessary.

Requirements

• 2–5 years of experience in a systems analyst, operations analyst, supply chain analyst, data workflow, or similar role.
• Bachelor’s degree or equivalent experience.
• Strong experience with Google Sheets and Microsoft Excel.
• Experience with Fishbowl or another ERP platform, business systems, or operational databases.
• Experience with SQL or MySQL.
• Experience with Google Apps Script or similar automation tools.
• Experience with Looker, LookML, or other BI/reporting tools.
• Strong analytical and problem-solving skills, with the ability to identify inconsistencies and troubleshoot issues independently.
• Highly detail-oriented, with a natural inclination to audit work and maintain strong data quality.
• Strong organizational and time management skills, with the ability to manage multiple priorities and deadlines.
• Ability to collaborate effectively across teams and communicate clearly with both technical and non-technical stakeholders.
• Able to commute to our fulfillment partner located in the Chicago Stockyards Industrial Park

Benefits

• Medical insurance
• Dental insurance
• Vision insurance
• Flexible Spending Account (FSA)
• Life insurance
• Matching retirement plan
• Generous and flexible paid time off
• Purple Carrot box delivery credits
• Professional development