Guest Supply, LLC

  • Business Analyst, Senior

    Job Locations US-NJ-Somerset
    Posted Date 2 months ago(8/31/2018 2:21 PM)
    Job ID
    # of Openings
    Business Analytics
  • Overview

    Who We Are:
    Guest Supply is a leading global manufacturer and distributor to the Travel and Leisure industry, providing products to over 25,000 hotels in 88 countries. With annual revenue exceeding a billion dollars, Guest Supply has grown its’ business by over 200% in the last 7 years. Guest Supply is also a wholly owned subsidiary of Sysco. Sysco is an industry leading Fortune 50 food and beverage distribution company, employing hundreds of thousands of employees worldwide and home to the 13th largest sales organization in the world.

    The Senior Business Analyst is primarily focused on data management (financial, customer, sales, cost, etc.) and business analytics from all internal (i.e., Excel, PeopleSoft, etc.) and external data (i.e., Smith Travel) sources. The Senior Business Analyst is responsible for gathering data from various sources, creating and distributing reports and providing analytical support to Sales, Marketing and management to assist with decision making and creating efficiencies. The Senior Business Analyst will also engage in and lead team discussions, assist in the development of talent, develop business procedures and make strategic decisions that impact both internal and external customers.


    • Develop, maintain and distribute reports including but not limited to:
      • Sales Quota Report, Sales Ranking, Company Sales Analytics, & Historical Performance
      • Forecasting Analytics, Complete Understanding of Gross Profit, Rebates Earned and Owed
      • Credit Activity
      • Tax Reporting
      • Inventory Aging and # Cases Shipped
    • Prepares spreadsheets for data analysis; prepare reports with charts and graphs, mailing lists, maps and ad hoc requests.
      • Contribute to the continued and collaborative efforts of creating efficiencies and identifying trends and performance metrics aimed at growing the business. Provide consistent, relevant and accurate data as well as guidance/knowledge of the data and definitions that are available for analysis.
      • Analyze, report, make comparisons to industry/company benchmarks, determine trends, and prepare cost analyses.
      • Provide written recommendations to support the findings and analyses.
      • Conduct research for industry trends and benchmarks. Provide trending data to Marketing team.
      • Help measure performance of sales activity data and profitability of sales metrics by product or category of products.
      • Perform reconciliation of sales across multiple data sources.
      • Provide other analytical support and guidance to internal and external customers/vendors as needed.
    • Develop detailed business cases, ROI calculations, value definition, cost assessments, benefits and risk analyses.
    • Identify and resolve problems with data used to complete analytics from ERP business applications to create better efficiencies of ERP applications. Write algorithms as needed. Assist in the education of how ERP systems and procedures impact both internal and external customers.
    • Import, export, and manage data files and other forms of information from various formats such as CSV, text, Excel and third party software. Gather disparate data from various data sources; analyze and normalize to ensure data integrity for analysis. Build interfaces with third party data (i.e., property identification codes) as needed for cross reference.


    • Bachelor’s degree in Accounting, Finance, Business or related field
    • MBA preferred
    • 5+ years related experience


    • Experience using relational databases and database extraction tools desirable.
    • Demonstrated skill in data analysis techniques by resolving missing/incomplete information, inconsistencies/anomalies in more complex research/data.
    • Advanced computer skills and proficient knowledge of all Microsoft Office programs with an emphasis on Excel and Access is required. Experience working with PeopleSoft, Phocas, or High Jump is a plus.
    • Knowledge of key business, financial and accounting metrics and principles.
    • Ability to engage and lead team discussions and meetings. Understands team dynamics and works well within a team structure. Delegates responsibilities effectively.
    • A mastery of organizational and project management skills, including the ability to plan, prioritize and execute multiple initiatives/deadlines autonomously and shift priorities as necessary. Able to manage large, complex projects. Uses time effectively.
    • Ability to make presentations about new strategies, trends in the industry, and company performance.
    • Excellent communication (verbal and written), interpersonal and professional interactive skills are necessary to perform at a high degree of proficiency. Ability to effectively present information and respond to questions from suppliers, customers, management and inter-department staff. Capable of working with internal staff from other departments in a proactive and constructive manner.
    • Ability to make presentations about new strategies, trends in the industry, and company performance.
    • Customer Service – Respond promptly to requests for service and assistance as needed. Follow up as needed.
    • Planning / Organization - Ability to prioritize and manage multiple priorities/deadlines and shift priorities as necessary. Uses time effectively.
    • Problem Solving - Identifies and resolves problems in a timely manner. Gathers and analyzes information skillfully. Develops alternative solutions.
    • Judgment - Displays willingness to make decisions under pressure that impact both internal and external customers. Exhibits sound and accurate judgment. Makes timely decisions.
    • Professionalism - Approaches others in a tactful manner. Reacts well under pressure. Follows through on commitments.
    • Team player attitude with the ability to work independently.
    • Detail Oriented – Attention to details and accuracy.


    Here are just some of the benefits you will enjoy in this role:
    Health, dental and vision insurance
    401(k) with company match
    Short and long term disability insurance
    Flexible dependent and health spending accounts
    Paid time off – vacation, sick and personal days


    While performing the duties of this job, the employee is regularly required to sit, stand, walk and use hands and fingers to operate a computer keyboard, mouse, and telephone to talk and hear. The employee is frequently required to sit and reach with hands and arms. The employee must occasionally lift and/or move up to 20 lbs.
    While this position will primarily work in an office environment, travel, including overnight (approx. 30 %) may be required to attend company events, staff meetings, training sessions, customer meetings and/or industry or vendor trade shows.
    May be required to utilize personal vehicle for business travel that may result in long periods of sitting. Must maintain a valid driver license with a driving record that meets Company minimum standards and maintain current automobile insurance coverage as set forth by Sysco.
    The noise level in the work environment is usually moderate.
    Overtime work may be required depending on business needs.

    NOTICE: The above statements are intended to describe the general nature of the environment and level of work being performed by this job. This job overview in no way states or implies that the duties and responsibilities listed are the only tasks to be performed by the associate in this job. The associate will be required to follow any other instructions and to perform any other job related duties requested by his or her supervisor. Reasonable accommodations will be made to enable individuals with disabilities to perform the essential functions.

    This job description supersedes prior job descriptions. When duties and responsibilities change and develop, the job description will be reviewed and is subject to changes of business necessity.


    Guest Supply is an Equal Opportunity Employer – M/F/Veteran/Disability/Sexual Orientation/Gender Identity


    Sorry the Share function is not working properly at this moment. Please refresh the page and try again later.
    Share on your newsfeed