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

Applicant Tracking System Keywords

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

Hard Skills & Tools

data workflowdata entrydata integrityroot-cause analysisreportingSQLMySQLGoogle Apps ScriptLookerFishbowl ERP

Soft Skills

analytical skillsproblem-solving skillsdetail-orientedorganizational skillstime management skillscollaborationcommunication

Certifications

Bachelor’s degree