Foodbuy
is hiring
Senior Data Analyst
About Our Company
Foodbuy, LLC is the foodservice industry’s leading procurement services organization focused on lowering purchasing and product costs for both our parent company, Compass Group, as well as for our clients and members.
Foodbuy negotiates and contracts for more than $20bn of food, beverages, and services that our clients need, utilizing more than 600 leading manufacturers and distributors across the U.S. Ultimately, sourcing is at the heart of what we do on behalf of Compass Group and some of the most recognized organizations within the restaurant, healthcare, hospitality, leisure, and entertainment industries.
Job Description & Responsibilities
eVIA is Compass Group’s Procure to Pay Solution. The eVIA Support Specialist will act as a team lead and subject matter expert related to the complete and accurate processing of invoice-level reporting from 1400+ distributor locations representing over $20 billion in annual spend across the U.S. and Canada. Key team lead activities include oversight of our core statistical analyses and executing risk management dashboards. Additionally, they will be responsible for all opportunity analysis related to the monthly deployment of units onto Compass’s Procure to Pay Solution (eVIA).
Functional Responsibilities:
- Efficiently utilize Excel, system templates, and system navigation to modify the status of thousands of Unit-Vendor combinations in support of eVIA deployment.
- High powered use of Excel/SQL to:
- Perform financial gap analyses across systems to identify and correct discrepancies in support of eVIA deployment
- Generate varying audits/reconciliations across datasets to identify insights, specifically targeting missing DCN’s and incorrect AP. Share insights with others to drive results
- Improve data collections against gap analyses related to distributor reporting, Distributor Customer Number (DCN), and all User Interface interactions
- Continually modify/eliminate manual Excel tasks in favor of intelligent spreadsheets or automated processes
- Triage and resolve missing invoices via Remedy Helpdesk
- Utilize PowerBi plus the above-mentioned analytics tools to develop, deploy, and maintain Statistical Analysis/Risk Management tools, providing business intelligence to Data Acquisition Team on a daily, weekly, and monthly basis.
- Act as a subject matter expert regarding EDI Data Feeds, Compass AP, AP Vendor and Distributor Hierarchy, eVIA, DCN’s and internal systems.
- Work cross-functionally with internal teams to drive operational excellence and support Foodbuy initiatives.
- Ensure timely data collections via the Committed Member DET process and the Compass AP Recon processes.
- Communicate with and influence Distributor Partners to meet the ever-growing list of Foodbuy reporting needs.
- Oversee the manual NT DCN Mapping process and support the integration of NT Data within Supply Chain.
- Lead broad training exercises as needed remotely and in-person.
- Train new analysts and support the standardization of Microsoft SQL Server as the best practice across Data Acquisition to identify insights and actionable intelligence.
- Maintain training and Standard Operating Procedure (SOP) documents.
- Deliver results against annually provided SMART KPI’s.
Requirements
Qualifications And Requirements
- Minimum of a bachelor’s degree with coursework across these competencies: Computer Science, Statistics, Logic, Accounting or Finance. A broad business degree would be considered with role relevant experience.
- 4+ years working with large amounts of data, managing complex processes, and process reengineering within a fast-paced technology driven environment.
- Prior experience working in a corporate environment.
- Basic understanding of MS Visio.
- Experience with Remedy Helpdesk or other Ticket Tracking solution preferred.
- Understanding of basic algebra and financial trend/statistical analysis; able to make inferences based on data.
- Ability to manage conflicting priorities while meeting all required deadlines.
- Innovative mindset with the ability to implement solutions to process inefficiencies or complex ad hoc problems.
- Strong collaborator and communicator (via email, phone, video conferencing), able to work cross-functionally to solve problems.
- Extremely detail oriented.
- Able to think creatively to modify processes to support ad hoc challenges related to growing the business.
- Forward thinking with the ability and confidence to challenge the status quo.
- Self-driven and able to produce results with minimal supervision.
Required Technical Skills:
- High proficiency with entire MS Office Suite including advanced Outlook and Excel (Lookups, Pivot Tables, Nested If/And/Or Statements, Power Query, Data Connections, Intelligent Formulas)
- MS Teams, Zoom, or other video conferencing tools
- Experience manipulating and analyzing datasets of at least 100,000 rows up to 1,000,000 rows in size
- Experience creating/editing SQL queries to pull target insights across disparate databases
- Proven experience utilizing SQL/VBA/MS Power Automate/PowerBI to execute and improve daily/weekly/monthly processes
- Experience with Microsoft Power Apps a plus
- Knowledge of Supply Chain (or other data management technology) preferred
What we offer
Associates At Foodbuy Are Offered Many Fantastic Benefits.
- Medical
- Dental
- Vision
- Life Insurance/ AD
- Disability Insurance
- Retirement Plan
- Paid Time Off
- Holiday Time Off (varies by site/state)
- Associate Shopping Program
- Health and Wellness Programs
- Discount Marketplace
- Identity Theft Protection
- Pet Insurance
- Commuter Benefits
- Employee Assistance Program
- Flexible Spending Accounts (FSAs)