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

Sysco Business Intelligence Interview Guide

Getting ready for an Business Intelligence interview at Sysco? The Sysco Business Intelligence interview span across 10 to 12 different question topics. In preparing for the interview:
<ul>
<li>Know what skills are necessary for Sysco Business Intelligence roles.</li>
<li>Gain insights into the Business Intelligence interview process at Sysco.</li>
<li>Practice real Sysco Business Intelligence interview questions.</li>
</ul>
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 Sysco Business Intelligence interview.


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

- Know what skills are necessary for Sysco Business Intelligence roles.
- Gain insights into the Business Intelligence interview process at Sysco.
- Practice real Sysco 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 Sysco Business Intelligence interview.
        

Overview

Sysco Business Intelligence Salary

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

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

Sysco Business Intelligence Interview Process

We’re given a table of bank transactions with three columns, <code>user_id</code>, a deposit or withdrawal value (determined if the value is positive or negative), and <code>created_at</code> time for each transaction.

Write a query to get the total three-day rolling average for deposits by day.

Note: Please use the format <code>&#39;%Y-%m-%d&#39;</code> for the date in the outout

Example:

Input:

<code>bank_transactions</code> table

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

<tbody>
<tr>
<td><code>user_id</code></td>
<td>INTEGER</td>
</tr>

<tr>
<td><code>created_at</code></td>
<td>DATETIME</td>
</tr>

<tr>
<td><code>transaction_value</code></td>
<td>FLOAT</td>
</tr>
</tbody>
</table>
Output:

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

<tbody>
<tr>
<td><code>dt</code></td>
<td>VARCHAR</td>
</tr>

<tr>
<td><code>rolling_three_day</code></td>
<td>FLOAT</td>
</tr>
</tbody>
</table>

Rolling Bank Transactions

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

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.

Example:

Input:

<code>players</code> table

<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>
Output:

<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

Write a query to identify customers who placed more than three transactions each in both 2019 and 2020.

Example:

Input:

<code>transactions</code> table

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

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

<tr>
<td><code>user_id</code></td>
<td>INTEGER</td>
</tr>

<tr>
<td><code>created_at</code></td>
<td>DATETIME</td>
</tr>

<tr>
<td><code>product_id</code></td>
<td>INTEGER</td>
</tr>

<tr>
<td><code>quantity</code></td>
<td>INTEGER</td>
</tr>
</tbody>
</table>
<code>users</code> table

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

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

<tr>
<td><code>name</code></td>
<td>VARCHAR</td>
</tr>
</tbody>
</table>
 
Output:

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

<tbody>
<tr>
<td><code>customer_name</code></td>
<td>VARCHAR</td>
</tr>
</tbody>
</table>

Which of the following queries will return a list of customers and the total amount they have spent on orders?

Which of the following queries will return a list of customers and the total amount they have spent on orders?

Customer Orders

Sysco Business Intelligence Interview Questions

Job Summary: Review, maintain and deploy category pricing strategies across all Merchandising Business Centers by implementing and updating pricing architecture. Support category owners to build product brand tier and positioning by ensuring the appropriate analytical practices and processes are used to provide recommendations that improve performance at Sysco. Responsible for deriving data-driven, actionable insights that contribute to various Merchandising initiatives and other cross-functional collaboration including Assortment Strategy, Strategic Sourcing, Supply Chain, Revenue Management, and Marketing. Duties and Responsibilities: Assists with maintenance and refinement of the pricing architecture process, including pricing analytics, competitive pricing data benchmarking, and pricing insights to determine and to influence strategy and decisions. Present and communicate pricing architecture recommendations to Merchandising and Revenue Management Sr. Directors/Directors/Managers to facilitate alignment. Collaborate with Business Centers to build, socialize, monitor and manage Category Pricing Strategies to enable sustainable profitable growth and performance to plan. Support cross-functional teams to provide analytics and recommendations to inform discussion and decision-making around Pricing / Assortment / Merchandising analyses and processes. Engage with key internal stakeholders to ensure understanding of data-derived insights and adoption of recommended changes and enhancements. Perform routine analyses integrating robust data sets and variables as an input to merchandising strategies for product, price, placement, and promotions to reflect category strategic vision and performance metrics. Education Required: Bachelors degree in relevant field of study or equivalent combination of education/experience in lieu of a degree sufficient to successfully perform essential job functions. Experience Required: 1-4 years related experience. Skills to develop insights and recommendations with analyses from various data sources. Experience Preferred: A proven track record in Strategic Pricing, Assortment Management or Merchandising. CPG, Retail or Foodservice industry experience strongly preferred. Technical Skills and Abilities: Advanced knowledge of Microsoft Excel (e.g. pivot tables, data connections, and VBA macros). Proficiency with key analytical/visualization tools such as Tableau and other relational databases. Experience in SQL, R or other relevant data mining software. Strong quantitative problem-solving skills developing structured analytics to answer complex issues or business questions and interpret large data sets comfortably with guidance. Ability to multitask, prioritize and manage many ongoing projects at once. Critical thinker with strong general business acumen and can work independently and proactively with limited supervision. Confident communicator with strong verbal and written communication skills. Openness to changes and new ideas. Physical Demands: Reasonable accommodations will be made to enable individuals with disabilities to perform the essential functions of this job. AFFIRMATIVE ACTION STATEMENT: Applicants must be currently authorized to work in the United States. We are proud to be an Equal Opportunity and Affirmative Action employer, and consider qualified applicants without regard to race, color, creed, religion, ancestry, national origin, sex, sexual orientation, gender identity, age, disability, veteran status or any other protected factor under federal, state or local law. This opportunity is available through Sysco Corporation, its subsidiaries and affiliates.

Essential Functions: <ol><li>Manage all aspects of the data and analytics system from stream configuration to ETL to aggregate tables and cubes for reporting needs. Establish and maintain the data pipeline architecture. Anticipate and understand the impact of technical decisions across the organization.</li><li>Partner with all facets of the business to include development, operations and consumers of data. Form and maintain relationships with stakeholders to understand needs and translate those needs into priorities and executable plans.</li><li>Provide technical guidance to data engineers. Mentor engineers throughout the data and analytics organization. Review and provide feedback on technical deliverables from peer and junior data engineers.</li><li>Write scripts to schedule data ingestion and syncing. Evaluate, lead and form back end logic to create data marts from requirements for the purposes of self-serving stakeholders.</li><li>Oversee the code creation from junior members of the team. Troubleshoot issues and obstacles independently and act as a first level of escalation support for the team.</li><li>Fix and research highly complex or difficult technical problems as a final source of escalation.</li><li>Assist data architects to build the working framework for data search and retrieval.</li><li>Identify required changes to the design and communicate to the architects.</li><li>Other duties as assigned.</li></ol>Minimum Qualifications: <ol><li>10 years experience of hands-on data platform design and development in large-scale and complex environments.</li><li>Experience with SQL and Python.</li><li>Experience with Redshift and Postgres.</li><li>Experience with AWS platform and technologies including Kinesis, Firehose and Glue.</li><li>Experience with cloud storage such as S3.</li><li>Experience orchestrating data ingestion and syncing metadata with event data.</li><li>Experience with ETL for reporting and business users (marketing, finance, product owners).</li></ol>Preferred Qualifications: <ol><li>Recognized degree in computer science or certification in technical related field.</li><li>12 years experience of hands-on data platform design and development in large-scale and complex environments.</li><li>Experience with Tableau and Tableau Server.</li></ol>
#J-18808-Ljbffr

JOB SUMMARYDrives effective delivery of product/platform needs through developing high quality software and technical solutions. Fluent in Salesforce Service Cloud functionality and coaches junior developers to promote a flexible mindset and develop technical competenceRESPONSIBILITIESLeverages strong understanding of business to develop high quality code to meet product/platform requirementsDrives and leads adoption of architecture standards and development practices like Test-Driven development, code reviews, static code analysis etc.Writes effective technical user stories and ensures that non-functional requirements are met to ensure performance, scaling, resilience and maintainability of software/solutionsActively resolves defects and manages technical debtDevelops unit tests to ensure good coverage and regression testing abilityAssists in the development of automated tests and environment management scriptsPractices DevOps methods like CI/CD, SDLC automation and proactive monitoring/telemetryParticipates in sprint planning, daily stand-ups, sprint reviews and retrospectives to enable progress, and surface and resolve impedimentsEvaluates emerging technologies continually to identify opportunities, trends and best practices to strengthen Syscos development practicesMay play a supervisory role toward junior technical resources as they commit to and deliver workMANDATORY EXPERIENCEBachelor's degree in CS or 4-5 years of relevant developer experience5-8 years of experience in developing high performance and highly scalable applications in an agile environment, depending on educationExtensive hands-on experience and expertise using modern programming languages and platforms (Java, JavaScript, C#, Python, Ruby, Groovy, Salesforce, etc)5 years in solution design and development experience building cloud-native applications using open-source frameworks like Spring3 years of experience building & deploying applications on a cloud platform such as AWS, GCP or Azure3 years of knowledge and experience with REST API design and implementation, and event driven architectureCOMPETENCIESUnderstands and implements code quality best practices, and can support others on their team in these practicesDevelops effective unit tests and implements integration and end-to-end testing.Able to support a wide variety of release management processes: planning, scheduling, and controlling software through different phases and environments, including versioning, branching, merging, testing, and deploying software releasesProficiency with DevOps tools and concepts, including continuous integration, continuous deployment / delivery, configuration and containerization, infrastructure as a code, and monitoringPossesses skills, experience, and proficiency with Agile practices (e.g. Lean, XP, Scrum, Kanban) and leverages these to improve processes, estimation, etc.Strong experience building and deploying applications on a cloud platform such as AWSResearches the answers to questions independently, improves work skills, and identifies key growth areas and topics of interest for the team. Provides learning recommendations to team members that target professional growth. Directly supports team strategies and processes for continuous learning (e.g. feedback processes, team development efforts)Directly communicates with key business and technical stakeholders across multiple channels: meetings and discussions, demos and presentations, written communication, etc. sWorks and collaborates effectively within a product team and connects with other teams and team members in and outside of the product family as needed.AWS/Azure/GCP Certified Developer and DevOps Engineer is a big plusAFFIRMATIVE ACTION STATEMENT:Applicants must be currently authorized to work in the United States. We are proud to be an Equal Opportunity and Affirmative Action employer, and consider qualified applicants without regard to race, color, creed, religion, ancestry, national origin, sex, sexual orientation, gender identity, age, disability, veteran status or any other protected factor under federal, state or local law. This opportunity is available through Sysco Corporation, its subsidiaries and affiliates.

Company:
US6469 Sysco Payroll, Division of Sysco Resources Services, LLC Zip Code:
77077 Minimum Level of Education:
Bachelor's Degree Minimum Years of Experience:
4 Years Employment Type:
Full Time Travel Percentage: COMPENSATION INFORMATION: The pay range provided is not indicative of Sysco's actual pay range but is merely algorithmic and provided for generalized comparison. Factors that may be used to determine rate of pay include specific skills, work location, work experience and other individualized factors JOB SUMMARY This role will apply advanced analytics to support the evaluation and development of new demand generation, assortment, costing, pricing and supply chain models. This will require expert ability in data acquisition (internal and external to Sysco), cleansing and manipulation; mathematical modeling; analytical and heuristic solution methods; and the ability to synthesize, visualize and communicate the result. This role will require close collaboration with other functions within the Enterprise Analytics and insights Team in addition to other functions within Sysco. RESPONSIBILITIES
Identify necessary data elements and their sources, leverage appropriate tools to acquire and consolidate large volumes of data from different internal and external sources, and identify and resolve any irrelevant, corrupt, missing, or incongruent data
Identify and use appropriate advanced analytic tools, technologies and platforms to execute analysis against business requirements, including the ability to scale, deploy and distribute models across the enterprise as needed.
Develop performance scorecards and dashboards to monitor the adoption, implementation, and impact of models and strategies.
Work cross-functionally with other roles within the Enterprise Analytics Team and the Sysco broadly to tune models and ensure value created from models.
Work with Business Technology resources on API, front end, and down stream integration.
Collaborate with business process owners to validate model outputs and construct an appropriate training
QUALIFICATIONS Education and / or Experience: Master's degree or PhD or Bachelor's degree + 3 years of industry experience in management consulting, strategy, analytics, at a specialized analytics company or in an analytics organization in a corporate setting.
Degree should be in mathematics, statistics or computer science or related field; preferred from a top tier University.
1-4 years of overall analytics experience, can be inclusive of post-graduate work
2+ years of experience accessing and manipulating data in SQL or NoSQL database environments
1+ years of experience with scientific scripting languages (e.g., Python) and/or object-oriented programming (e.g., C++, Java)
2+ years of experience with Bayesian statistics, regression analysis (beyond linear regression), supervised learning, unsupervised learning or time-series analysis required
Professional Skills Experience accessing and manipulating data in SQL or NoSQL database environments
Experience with scientific scripting languages (e.g., Python) and/or object-oriented programming (e.g., C++, Java)
Experience with regression analysis (beyond linear regression), supervised learning, unsupervised learning or time-series analysis required BENEFITS INFORMATION:
For information on Sysco's Benefits, please visit https://SyscoBenefits.com OVERVIEW: Sysco is the global leader in foodservice distribution. With over 71,000 colleagues and a fleet of over 13,000 vehicles, Sysco operates approximately 333 distribution facilities worldwide and serves more than 700,000 customer locations. We offer our colleagues the opportunity to grow personally and professionally, to contribute to the success of a dynamic organization, and to serve others in a manner that exceeds their expectations. We're looking for talented, hard-working individuals to join our team. Come grow with us and let us show you why Sysco is at the heart of food and service. AFFIRMATIVE ACTION STATEMENT: Applicants must be currently authorized to work in the United States. We are proud to be an Equal Opportunity and Affirmative Action employer, and consider qualified applicants without regard to race, color, creed, religion, ancestry, national origin, sex, sexual orientation, gender identity, age, disability, veteran status or any other protected factor under federal, state or local law. This opportunity is available through Sysco Corporation, its subsidiaries and affiliates.

JOB SUMMARY The Manager Performance Analytics is a key member of the team developing Syscos Analytics & Performance Intelligence capabilities. This prospective candidate will be at the forefront of Syscos customer-first evolution, which is enabled by advanced analytics and a digital transformation. They will support the design, development, and deployment of analytics use cases against one of Syscos core enterprise analytics engines. This role will require close collaboration, depending upon the use case, with functional teams (e.g., merchandising, revenue management, human resources), operating companies, specialty companies or geographies and technology teams. RESPONSIBILITIES Support the definition of the approach and guide the design of analytic models for a use case associated with one of the core enterprise analytics engines Perform data mining, cleansing, and manipulation; Identify necessary data elements and their sources, leverage appropriate tools to acquire and consolidate large volumes of data from different sources Work with Business, Data Science, and Business Technology teams to ensure that all models are effectively scaled Develop and build metrics and tracking to ensure value is captured from analytical models being developed and deployed Work with a cross-functional team of analysts, business SMEs (Subject Matter Expert) and technical resources Manage associate and business partner resources on completing Analytics & dashboarding associated with a use case QUALIFICATIONS Education Bachelors in an analytical field (e.g., Engineering, Mathematics, Business) Experience 3 years in a corporate setting or leading professional services company in an analytical or strategic role such as Strategy, Finance or Insights ? Professional Skills Familiarity with digital technologies and data elements & sources Understanding of business value drivers and corresponding business impact Ability to problem solve in a structured and logical framework that encompasses problem statement definition, data analysis, and insights and recommendations Ability to work in a collaborative work environment that enables a cross-functional team with various backgrounds and capabilities to execute at a high-level Strong verbal, written, and interpersonal skills; comfort interfacing with both technical and management teams AFFIRMATIVE ACTION STATEMENT: Applicants must be currently authorized to work in the United States. We are proud to be an Equal Opportunity and Affirmative Action employer, and consider qualified applicants without regard to race, color, creed, religion, ancestry, national origin, sex, sexual orientation, gender identity, age, disability, veteran status or any other protected factor under federal, state or local law. This opportunity is available through Sysco Corporation, its subsidiaries and affiliates.

Sysco Business Intelligence Interview Guide

Overview

Sysco Business Intelligence Salary

Sysco Business Intelligence Interview Process

Sysco Business Intelligence Interview Questions

Sysco Business Intelligence Jobs