Compass Group, North America
SPECIALIST, DATA INTELLIGENCE SR
Compass Group, North America, Charlotte, North Carolina, United States, 28245
Who is Foodbuy?
We are the industry leader in procurement and supply chain solutions. We are the subsidiary to the 6th largest company in the world (Compass Group PLC), yet Foodbuy has the feel of a small entrepreneurial Company. We pride ourselves on our ability to source and provide a variety of products and services that help our customers more easily, and cost effectively, run their businesses. We work with clients in the Hospitality, Restaurant, Healthcare, Education, Entertainment, and Gaming industries, and of course we support Compass Group-- which is the world’s largest contract food and support services provider.
Why Foodbuy? We care about our associates, our clients, and our community. We think big, encourage innovation and debate, and seek out game changers. Our benefits and PTO offerings are strong. Our compensation packages are competitive. And we are constantly growing, and we want our associates’ careers to grow along with us. We have an open and modern work environment, believe in flexibility, and promote a collaborative open door environment.
People FIRST
, which stands for
F lexibility,
I nclusion,
R esults,
S ustainability and
T ransparency.
People FIRST
is the foundation for everything we do at Foodbuy. It is how we connect and interact with our clients, business partners and fellow associates.
Job Summary The Sr. Data Intelligence Specialist role sits in out our Termset Management, Operations Department and is expected to be a subject matter expert on all aspects of contract implementation within Foodbuy’s proprietary contract tracking system, “Supply Chain”. The Procurement Specialist will have varying forms of direct process ownership including our more financially challenging and risky tasks: high ROI commodity suppliers, system overlap resolution, financial quality control and reporting. This role has significant autonomy to innovate and develop solutions to a wide range of team and departmental challenges. It is highly analytical in nature and a successful candidate will be organized and detail oriented with proven experience utilizing Excel. Ideal candidates will have experience with Excel VBA Macro’s.
Responsibilities
High powered use of Excel to:
Perform contracting gap analyses (audits and reconciliations) against master contract data vs termset standards
Calculate historical VA owed by calculating rates per period and applying to transactional data
Find the “needle in the haystack” to solve root cause for Termset Overlaps
Generate results for complex ad hoc analysis requests
Calculate figures and amounts such as discounts, interest, commissions, proportions, percentages, metric conversions, area, and volume
Compile and present data summaries in a clean and concise manner
Run point for multiple “central owner/bulk” managed processes
Daily application of algebra and basic calculus concepts
Process high volumes of data requests accurately and ahead of very strict deadlines
Remain flexible and adapt as needed to unforeseen technology challenges
Act as team SME and support analysts with problem solving activities before they are escalated to management
Act as backup for the Pricing Analyst to support the weekly Price Release processes
Utilize, edit, create intelligent spreadsheets that reduce human touchpoints across routine tasks
Utilize Excel VBA to create/edit/maintain Macros as needed
Strong desire to self-teach new technical skills not limited to SQL, PowerBI, PowerQuery, PowerAutomate, etc.
Train new analysts on all Termset Management concepts and best practices
Absorb functionality to cover for associate turnover
Regularly pull tangible and intangible data pieces together to draw conclusions and provide recommendations for solutions where limited standardization and multiple variables exist
Maintain training and Standard Operating Procedure (SOP) documents.
Deliver results against annually provided SMART KPI’s.
Requirements
High proficiency with entire MS Office Suite including advanced Outlook and Excel (Lookups, Pivot Tables, Intelligent Formulas).
Ability to write/understand Nested If Statements to remove human decision making from spreadsheets
MS Teams, Zoom, or other video conferencing tools.
Ability to read/edit/write Excel VBA to maintain and modify Excel Macro’s. (Experience with PowerBI/SQL/PowerAutomate will be accepted in lieu of VBA).
Experience manipulating and analyzing datasets of at least 50,000 rows up to 100,000 rows in size.
Prior experience working smarter, not harder, delivering improvements on daily/weekly/monthly processes.
Knowledge of Supply Chain (or other system-based data management technology) preferred.
Qualities of Preferred Candidate
Minimum of a bachelor’s degree.
2+ years working with large amounts of data, managing complex processes, and process reengineering within a fast-paced technology driven environment.
Prior experience utilizing Excel Formulas to automate repetitive tasks
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.
Forward thinking with the ability and confidence to challenge the status quo.
Self-driven and able to produce results with minimal supervision.
Ability to work effectively on an individual basis and collaboratively as part of a team
Apply to Foodbuy today! Foodbuy is a member of Compass Group USA
Click here to Learn More about the Compass Story (http://www.compass-usa.com/our-story/)
Compass Group is an equal opportunity employer. At Compass, we are committed to treating all Applicants and Associates fairly based on their abilities, achievements, and experience without regard to race, national origin, sex, age, disability, veteran status, sexual orientation, gender identity, or any other classification protected by law.
Qualified candidates must be able to perform the essential functions of this position satisfactorily with or without a reasonable accommodation. Disclaimer: this job post is not necessarily an exhaustive list of all essential responsibilities, skills, tasks, or requirements associated with this position. While this is intended to be an accurate reflection of the position posted, the Company reserves the right to modify or change the essential functions of the job based on business necessity. We will consider for employment all qualified applicants, including those with a criminal history (including relevant driving history), in a manner consistent with all applicable federal, state, and local laws, including the City of Los Angeles’ Fair Chance Initiative for Hiring Ordinance, the San Francisco Fair Chance Ordinance, and the New York Fair Chance Act.
Applications are accepted on an ongoing basis.
Foodbuy maintains a drug‑free workplace.
Benefits
Medical
Dental
Vision
Life Insurance/ AD
Disability Insurance
Retirement Plan
Paid Time Off
Paid Parental Leave
Holiday Time Off (varies by site/state)
Personal Leave
Associate Shopping Program
Health and Wellness Programs
Discount Marketplace
Identity Theft Protection
Pet Insurance
Commuter Benefits
Employee Assistance Program
Flexible Spending Accounts (FSAs)
Associates may also be eligible for paid and/or unpaid time off benefits in accordance with applicable federal, state, and local laws. For positions in Washington State, Maryland, or to be performed Remotely, click here (https://www.compass-usa.com/wp-content/uploads/2023/08/2023_WageTransparency_CorpAndFoodbuy.pdf) for paid time off benefits information.
#J-18808-Ljbffr
Why Foodbuy? We care about our associates, our clients, and our community. We think big, encourage innovation and debate, and seek out game changers. Our benefits and PTO offerings are strong. Our compensation packages are competitive. And we are constantly growing, and we want our associates’ careers to grow along with us. We have an open and modern work environment, believe in flexibility, and promote a collaborative open door environment.
People FIRST
, which stands for
F lexibility,
I nclusion,
R esults,
S ustainability and
T ransparency.
People FIRST
is the foundation for everything we do at Foodbuy. It is how we connect and interact with our clients, business partners and fellow associates.
Job Summary The Sr. Data Intelligence Specialist role sits in out our Termset Management, Operations Department and is expected to be a subject matter expert on all aspects of contract implementation within Foodbuy’s proprietary contract tracking system, “Supply Chain”. The Procurement Specialist will have varying forms of direct process ownership including our more financially challenging and risky tasks: high ROI commodity suppliers, system overlap resolution, financial quality control and reporting. This role has significant autonomy to innovate and develop solutions to a wide range of team and departmental challenges. It is highly analytical in nature and a successful candidate will be organized and detail oriented with proven experience utilizing Excel. Ideal candidates will have experience with Excel VBA Macro’s.
Responsibilities
High powered use of Excel to:
Perform contracting gap analyses (audits and reconciliations) against master contract data vs termset standards
Calculate historical VA owed by calculating rates per period and applying to transactional data
Find the “needle in the haystack” to solve root cause for Termset Overlaps
Generate results for complex ad hoc analysis requests
Calculate figures and amounts such as discounts, interest, commissions, proportions, percentages, metric conversions, area, and volume
Compile and present data summaries in a clean and concise manner
Run point for multiple “central owner/bulk” managed processes
Daily application of algebra and basic calculus concepts
Process high volumes of data requests accurately and ahead of very strict deadlines
Remain flexible and adapt as needed to unforeseen technology challenges
Act as team SME and support analysts with problem solving activities before they are escalated to management
Act as backup for the Pricing Analyst to support the weekly Price Release processes
Utilize, edit, create intelligent spreadsheets that reduce human touchpoints across routine tasks
Utilize Excel VBA to create/edit/maintain Macros as needed
Strong desire to self-teach new technical skills not limited to SQL, PowerBI, PowerQuery, PowerAutomate, etc.
Train new analysts on all Termset Management concepts and best practices
Absorb functionality to cover for associate turnover
Regularly pull tangible and intangible data pieces together to draw conclusions and provide recommendations for solutions where limited standardization and multiple variables exist
Maintain training and Standard Operating Procedure (SOP) documents.
Deliver results against annually provided SMART KPI’s.
Requirements
High proficiency with entire MS Office Suite including advanced Outlook and Excel (Lookups, Pivot Tables, Intelligent Formulas).
Ability to write/understand Nested If Statements to remove human decision making from spreadsheets
MS Teams, Zoom, or other video conferencing tools.
Ability to read/edit/write Excel VBA to maintain and modify Excel Macro’s. (Experience with PowerBI/SQL/PowerAutomate will be accepted in lieu of VBA).
Experience manipulating and analyzing datasets of at least 50,000 rows up to 100,000 rows in size.
Prior experience working smarter, not harder, delivering improvements on daily/weekly/monthly processes.
Knowledge of Supply Chain (or other system-based data management technology) preferred.
Qualities of Preferred Candidate
Minimum of a bachelor’s degree.
2+ years working with large amounts of data, managing complex processes, and process reengineering within a fast-paced technology driven environment.
Prior experience utilizing Excel Formulas to automate repetitive tasks
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.
Forward thinking with the ability and confidence to challenge the status quo.
Self-driven and able to produce results with minimal supervision.
Ability to work effectively on an individual basis and collaboratively as part of a team
Apply to Foodbuy today! Foodbuy is a member of Compass Group USA
Click here to Learn More about the Compass Story (http://www.compass-usa.com/our-story/)
Compass Group is an equal opportunity employer. At Compass, we are committed to treating all Applicants and Associates fairly based on their abilities, achievements, and experience without regard to race, national origin, sex, age, disability, veteran status, sexual orientation, gender identity, or any other classification protected by law.
Qualified candidates must be able to perform the essential functions of this position satisfactorily with or without a reasonable accommodation. Disclaimer: this job post is not necessarily an exhaustive list of all essential responsibilities, skills, tasks, or requirements associated with this position. While this is intended to be an accurate reflection of the position posted, the Company reserves the right to modify or change the essential functions of the job based on business necessity. We will consider for employment all qualified applicants, including those with a criminal history (including relevant driving history), in a manner consistent with all applicable federal, state, and local laws, including the City of Los Angeles’ Fair Chance Initiative for Hiring Ordinance, the San Francisco Fair Chance Ordinance, and the New York Fair Chance Act.
Applications are accepted on an ongoing basis.
Foodbuy maintains a drug‑free workplace.
Benefits
Medical
Dental
Vision
Life Insurance/ AD
Disability Insurance
Retirement Plan
Paid Time Off
Paid Parental Leave
Holiday Time Off (varies by site/state)
Personal Leave
Associate Shopping Program
Health and Wellness Programs
Discount Marketplace
Identity Theft Protection
Pet Insurance
Commuter Benefits
Employee Assistance Program
Flexible Spending Accounts (FSAs)
Associates may also be eligible for paid and/or unpaid time off benefits in accordance with applicable federal, state, and local laws. For positions in Washington State, Maryland, or to be performed Remotely, click here (https://www.compass-usa.com/wp-content/uploads/2023/08/2023_WageTransparency_CorpAndFoodbuy.pdf) for paid time off benefits information.
#J-18808-Ljbffr