Support and execute critical data and workflow processes across Purple Carrot’s supply chain systems (Fishbowl ERP, Galley Menu Planner, Google Sheets, Excel, Apps Script, Looker, SQL tools)
Manage data flow across systems, including imports, exports, updates, and reconciliations, with a strong focus on data integrity.
Own recurring BOM and recipe workflows for weekly meal kits and prepared meals, ensuring accurate data transfer 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.
Build and maintain reporting and dashboards (Fishbowl, Looker) to support visibility and decision-making.
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 operations, operations analyst, supply chain operations, or similar role
Bachelor’s degree or equivalent experience
Strong experience with Google Sheets and Microsoft Excel
Experience with ERP systems (Fishbowl or similar) and operational databases
Experience with SQL/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
High attention to detail and commitment to data accuracy
Ability to manage multiple priorities and collaborate cross-functionally
Able to commute to our fulfillment partner located in the Chicago Stockyards Industrial Park

Benefits

Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills & Tools

SQLGoogle SheetsMicrosoft ExcelGoogle Apps ScriptFishbowl ERPLookerLookMLdata integrityroot-cause analysisBOM workflows

Soft Skills

analytical skillsproblem-solving skillsattention to detailcollaborationability to manage multiple priorities

Certifications

Bachelor’s degree