The Aramark Business Intelligence interview guide, interview questions, salary data, and interview experiences.

Aramark Business Intelligence Interview Guide

<p>Getting ready for an Business Intelligence interview at Aramark? The Aramark Business Intelligence interview span across 10 to 12 different question topics. In preparing for the interview:</p>
<ul>
<li>Know what skills are necessary for Aramark Business Intelligence roles.</li>
<li>Gain insights into the Business Intelligence interview process at Aramark.</li>
<li>Practice real Aramark Business Intelligence interview questions.</li>
</ul>
<p>Interview Query regularly analyzes interview experience data, and we've used that data to produce this guide, with sample interview questions and an overview of the Aramark Business Intelligence interview.</p>


Getting ready for an Business Intelligence interview at Aramark? The Aramark Business Intelligence interview span across 10 to 12 different question topics. In preparing for the interview:

- Know what skills are necessary for Aramark Business Intelligence roles.
- Gain insights into the Business Intelligence interview process at Aramark.
- Practice real Aramark Business Intelligence interview questions.

Interview Query regularly analyzes interview experience data, and we've used that data to produce this guide, with sample interview questions and an overview of the Aramark Business Intelligence interview.
        

Overview

<p>We've gathered this data from parsing thousands of interview experiences sourced from members.</p>

We've gathered this data from parsing thousands of interview experiences sourced from members.

Aramark Business Intelligence Interview Process

<p>Suppose your company needs to cut costs due to an economic downturn. During a coffee break, you hear a rumor that a lot of money goes to employees who don’t do their work, and you decide to find out if the rumor is true.</p>

<p>Given two tables: <code>employees</code> and <code>projects</code>, find the sum of the salaries of all the employees who didn’t complete any of their projects.</p>

<p>Clarification:</p>

<p>We will consider a project unfinished if it has no end date (its <code>End_dt</code> is <code>NULL</code>).</p>

<p>Given this, we’ll say an employee didn’t finish any of their projects when:</p>

<ul>
<li>They were assigned at least one project.</li>
<li>None of their projects have an <code>End_dt</code>.</li>
</ul>

<p><strong>Example:</strong></p>

<p><strong>Input:</strong></p>

<p><code>employees</code> table</p>

<table>
<thead>
<tr>
<th>id</th>
<th>salary</th>
</tr>
</thead>

<tbody>
<tr>
<td>INTEGER</td>
<td>FLOAT</td>
</tr>
</tbody>
</table>
<p><code>projects</code> table</p>

<table>
<thead>
<tr>
<th>employee_id</th>
<th>project_id</th>
<th>Start_dt</th>
<th>End_dt</th>
</tr>
</thead>

<tbody>
<tr>
<td>INTEGER</td>
<td>INTEGER</td>
<td>DATETIME</td>
<td>DATETIME</td>
</tr>
</tbody>
</table>
<p><strong>Output:</strong></p>

<table>
<thead>
<tr>
<th>total_slack_salary</th>
</tr>
</thead>

<tbody>
<tr>
<td>INTEGER</td>
</tr>
</tbody>
</table>


Find the total salary of slacking employees.

Slacking Employees Salaries

<p>You’ve been asked to analyze the player’s behaviors at a gaming company.</p>

<p>Write a query to get the number of players who played between 5 and 10 games (5 and 10 excluded), and the number of players who played 10 games or more.</p>

<p><strong>Example:</strong></p>

<p><strong>Input:</strong></p>

<p><strong><code>players</code></strong> table</p>

<table>
<thead>
<tr>
<th>Column</th>
<th>Type</th>
</tr>
</thead>

<tbody>
<tr>
<td>id</td>
<td>INTEGER</td>
</tr>

<tr>
<td>name</td>
<td>VARCHAR</td>
</tr>

<tr>
<td>games_played</td>
<td>INTEGER</td>
</tr>

<tr>
<td>registered_at</td>
<td>TIMESTAMP</td>
</tr>
</tbody>
</table>
<p><strong>Output:</strong></p>

<table>
<thead>
<tr>
<th>Column</th>
<th>Type</th>
</tr>
</thead>

<tbody>
<tr>
<td>players_more_than_5_to_10_games</td>
<td>INTEGER</td>
</tr>

<tr>
<td>players_10_plus_games</td>
<td>INTEGER</td>
</tr>
</tbody>
</table>


Obtain count of players based on games played.

Player Analysis

<p>You have been given a table <code>tbl_numbers</code> with only one column: <code>int_numbers</code>.  It can have one integer number value per row in a sequential manner.</p>

<p>Write a query to return the number repeated by one times its own value.</p>

<p>For example, the integer number 5 would appear five times in the output (1 times 5).</p>

<p><strong>Example:</strong></p>

<p><strong>Input:</strong></p>

<p><code>tbl_numbers</code> table</p>

<table>
<thead>
<tr>
<th>int_numbers</th>
</tr>
</thead>

<tbody>
<tr>
<td><code>1</code></td>
</tr>

<tr>
<td><code>2</code></td>
</tr>

<tr>
<td><code>3</code></td>
</tr>

<tr>
<td><code>4</code></td>
</tr>
</tbody>
</table>
<p><strong>Output:</strong></p>

<table>
<thead>
<tr>
<th>seq_numbers</th>
</tr>
</thead>

<tbody>
<tr>
<td><code>1</code></td>
</tr>

<tr>
<td><code>2</code></td>
</tr>

<tr>
<td><code>2</code></td>
</tr>

<tr>
<td><code>3</code></td>
</tr>

<tr>
<td><code>3</code></td>
</tr>

<tr>
<td><code>3</code></td>
</tr>

<tr>
<td><code>4</code></td>
</tr>

<tr>
<td><code>4</code></td>
</tr>

<tr>
<td><code>4</code></td>
</tr>

<tr>
<td><code>4</code></td>
</tr>
</tbody>
</table>


Sequentially Fill in Integers

Aramark Business Intelligence Interview Questions

Job Description

The Pricing Analyst will support the development and execution of analytic processes used to ensure that distributors and suppliers comply with Avendra procurement contracts, charge accurate prices according to contractual terms to Avendra customers, and issue accurate credits for pricing errors. The Pricing Analyst plays an integral role in the audit of Regional Food and Non-Food pricing contracts and the delivery, tracking, and processing of audit results as well as supporting special projects and analyses. Price Audit is a high-visibility, high-impact department working with all aspects of the Avendra supply chain and a key department working to enforce Avendra?s value proposition.

Position Reports to Senior Manager, Price Audit

Job Responsibilities

Primary Responsibilities

Schedule and complete audits of distributors across North America for pricing compliance, including review of contract terms, preparation of work papers, schedules and a summary of work performed

Perform in-depth post-audit analysis of suppliers determined not to be in compliance with Avendra contracts to determine root causes for noncompliance. Develop and provide recommendations for resolving noncompliance issues

Communicate the results of audits, analyses and projects via written reports and oral presentations to suppliers and Avendra management

Perform research required to understand and correctly resolve audit issues.

Resolve Regional and Non-Food pricing support incidents

Consult with Avendra Price Audit management, commodity managers and regional managers to identify areas of risk and suppliers of specific concern; provide input into developing Avendra?s annual audit plans

Develop and maintain relationships with key external contacts involved in the audit process

Interact with multiple functional departments to communicate, track, and resolve issues with data, items, pricing, contracts, etc.

Work with contracting department to manage issues related to audit accuracy

Secondary Responsibilities

Assist in special projects and investigations

Assist with developing Avendra?s automated tools for performing pricing verifications, which includes the design of sampling methodologies and using Excel as well as other software where appropriate

Design and execute ad hoc data analysis projects and compile results for presentation to management or external customers

Primary Competencies

Functional/Technical Skills

Planning and Organization

Problem Solving & Analytical Skills

Quality & Continuous Improvement

Effective Written and Oral Communications

Taking Initiative

Other Duties. Please note this role description is not designed to cover or contain a comprehensive listing of activities, duties or responsibilities that are required for this job. Duties, responsibilities and activities may change at any time with or without notice.

Work Environment. This job operates in an office setting. This role routinely uses standard office equipment such as computers, phones, photocopiers, filing cabinets and fax machines.

Physical Demands. This is largely a sedentary role with some light lifting of files possibly needed.

Qualifications

Role Requirements

Excellent organizational skills, including the ability to organize and execute work Strong writing and proofreading skills including grammar, punctuation, and spelling

Intermediate skills in Microsoft Access, Excel and Word

Able to demonstrate confidentiality

Ability to work independently

Overnight Travel Requirements. Type: None

Years of Relevant Experience. 0-2 years of experience

Education Requirements. BS/BA in relevant field or equivalent years' experience

Benefits

BENEFITS:  Aramark offers comprehensive benefit programs and services for eligible employees including medical, dental, vision, and work/life resources. Additional benefits may include retirement savings plans like 401(k) and paid days off such as parental leave and disability coverage. Benefits vary by location and are subject to any legal requirements or limitations, employee eligibility status, and where the employee lives and/or works. For more information about Aramark benefits, click here Aramark Careers - Benefits & Compensation (https://careers.aramark.com/benefits-compensation/) . ?

Flexible work arrangements

Generous PTO, Vacation and 9 paid holidays

Volunteer days, community partnerships, Employee Assistance Program

Employee discounts on select services and products

Your choice of three medical plan tiers, two carriers to choose from & My Healthy Changes well-being program

Adoption Assistance & Paid Parental Leave

Tuition Funding Sources and Scholarship Programs

Retirement plan (401K or SIRP for those eligible) with match on annual contributions

COMPENSATION:  The salary range for this position is $50,000 - $65,000. If both numbers are the same, that is the amount that Aramark expects to offer. This is Aramark?s good faith and reasonable estimate of the compensation for this position as of the time of posting.

?There is no predetermined application window for this position, the position will close once a qualified candidate is selected. Qualified applicants with arrest or conviction records will be considered for employment in accordance with all applicable laws, including, but not limited to all applicable Fair Chance Ordinances and Acts. For jobs in San Francisco, this includes the San Francisco Fair Chance Ordinance.

About Aramark

Our Mission

Rooted in service and united by our purpose, we strive to do great things for each other, our partners, our communities, and our planet.

At Aramark, we believe that every employee should enjoy equal employment opportunity and be free to participate in all aspects of the company. We do not discriminate on the basis of race, color, religion, national origin, age, sex, gender, pregnancy, disability, sexual orientation, gender identity, genetic information, military status, protected veteran status or other characteristics protected by applicable law.

About Aramark

The people of Aramark proudly serve millions of guests every day through food and facilities in 15 countries around the world. Rooted in service and united by our purpose, we strive to do great things for each other, our partners, our communities, and our planet. We believe a career should develop your talents, fuel your passions, and empower your professional growth. So, no matter what you're pursuing - a new challenge, a sense of belonging, or just a great place to work - our focus is helping you reach your full potential. Learn more about working here at http://www.aramarkcareers.com or connect with us on Facebook , Instagram and Twitter .

Education

Question	Topic	Difficulty	Ask Chance
Slacking Employees Salaries	SQL	Medium	Very High
Player Analysis	SQL	Easy	Very High
Sequentially Fill in Integers	SQL	Hard	Very High

Aramark Business Intelligence Interview Guide

Overview

Aramark Business Intelligence Interview Process

Aramark Business Intelligence Interview Questions

Aramark Business Intelligence Jobs