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

Rr Donnelley Business Intelligence Interview Guide

<p>Getting ready for an Business Intelligence interview at Rr Donnelley? The Rr Donnelley 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 Rr Donnelley Business Intelligence roles.</li>
<li>Gain insights into the Business Intelligence interview process at Rr Donnelley.</li>
<li>Practice real Rr Donnelley 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 Rr Donnelley Business Intelligence interview.</p>


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

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

Overview

Rr Donnelley Business Intelligence Salary

<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.

Rr Donnelley Business Intelligence Interview Process

<p>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.</p>

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

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

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

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

<p><code>bank_transactions</code> table</p>

<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>
<p><strong>Output:</strong></p>

<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

<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>Write a query to identify customers who placed more than three transactions each in both 2019 and 2020.</p>

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

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

<p><code>transactions</code> table</p>

<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>
<p><code>users</code> table</p>

<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>
<p> 
<strong>Output:</strong></p>

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


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


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

Customer Orders

Rr Donnelley Business Intelligence Interview Questions

<strong>Company Description</strong><br><br>RRD is a leading global provider of marketing, packaging, print, and supply chain solutions that elevate engagement across the complete customer journey. The company offers the industry's most trusted portfolio of creative execution and world-wide business process consulting, with services designed to lower environmental impact. With 22,000 clients, including 93% of the Fortune 100, and 32,000 employees across 28 countries, RRD brings the expertise, execution, and scale designed to transform customer touchpoints into meaningful moments of impact.<br><br><strong>Job Description</strong><br><br>RR Donnelley is looking for an SAP FICO business analyst to work with team members in managing enhancements and new functionality projects in our established SAP ECC system.<br><br>RR Donnelley's SAP footprint is focused on core financials and utilizes interfaces with legacy systems for manufacturing and customer invoicing functionality. We are looking for candidates that have experience in accounting, extensive SAP FICO experience, and experience managing small projects.<br><br>The ideal candidate will have hands on accounting, configuration, program development, and small-project management skills focused on SAP accounting functionality.<br><br><strong>Responsibilities</strong><br><br><ul><li>Participate in project management by managing small to medium size projects from definition through implementation</li><li>Participate in project planning by providing estimated hours and target dates for all project related tasks before development begins</li><li>Define application requirements by reviewing requests from our business partners and conducting "solutioning" sessions</li><li>Work with legacy systems teams to design, build, test, and implement data exchange interfaces with legacy systems</li><li>Create design and training documentation for new functionality and projects</li><li>Lead training sessions with users on new functionality</li><li>Gain user approval by developing system prototypes to present to users for their review</li><li>Communicate project status by creating written status reports on a predetermined schedule for large development efforts</li><li>Responsible for the configuration and daily support of the SAP FI and CO modules that are already implemented with a focus on AP and related functions</li><li>Assist users in determining the best method for data reporting, either via standard reports, table downloads, ABAP query, or customer program</li><li>Troubleshoot user issues</li><li>Research in SAP OSS and implementation of OSS notes</li><li>Mentor business users and teammates on FI related to Accounts Receivable and Collections.</li></ul><br><br><strong>Qualifications</strong><br><ul><li>SAP configuration in FI (GL, AP, AR, FA) and CO (PCA, Cost Centers, IO)</li><li>Experience with MM, Purchasing, SD, or PP is a plus</li><li>Experience designing, implementing and supporting interfaces with legacy systems</li><li>Program design and testing including requirements gathering</li><li>Training development and delivery skills</li><li>Good written and verbal communication skills</li><li>Solid understanding of accounting, actual accounting experience is a plus</li><li>Strong problem solving skills, organizational skills, and communication (written and oral) skills</li></ul><br><br><strong>Required Experience</strong><br><br><ul><li>Candidate should possess a 4-year degree in accounting, business, computer science or related field</li><li>Hands on accounting experience is desired</li><li>Minimum five years of SAP R/3 Finance (FI) & Controlling (CO) configuration and implementation experience:<ol><li>SAP FI/CO configuration experience in FA, A/R, A/P, and GL</li><li>SAP FI/CO configuration experience in CCA/PCA</li><li>Knowledge of and experience with integration of FI/CO with other SAP modules</li><li>Knowledge of and experience with interface design and support</li></ol></li></ul><ul><li>Deep understanding in accounting business processes</li><li>Functional knowledge of common Financial interfaces or programs</li><li>Experience with SAP ECC 6.0 or higher is required</li><li>Experience with Ariba Procurement application would be a plus</li><li>Experience with SAP Security would be a plus</li></ul><br><br><strong>Additional Information</strong><br><br>The national pay range for this role is $74,600 to $132,500 / year. The pay range may be slightly lower or higher based on the geographic location of the hired employee. The actual pay offered may vary based upon, but not limited to: education, skills, experience, proficiency, performance, shift and location. In addition to base salary, depending on the role, the total compensation package may also include participation in a bonus, commission or incentive program. RRD offers benefits including medical, dental, and vision coverage, paid time off, disability insurance, 401(k) with match, life insurance and other voluntary supplemental insurance coverages, plus tuition assistance, maternity leave, adoption assistance, and employer/partner discounts.<br><br>#RRDCORP<br><br>#LI-RRD<br><br>#LI-Remote<br><br>#RRD-Dice<br><br>RRD is an Equal Opportunity Employer, including disability/veterans

<p>RRD is a leading global provider of marketing, packaging, print, and supply chain solutions that elevate engagement across the complete customer journey. The company offers the industry’s most trusted portfolio of creative execution and world-wide business process consulting, with services designed to lower environmental impact. With 22,000 clients, including 93% of the Fortune 100, and 32,000 employees across 28 countries, RRD brings the expertise, execution, and scale designed to transform customer touchpoints into meaningful moments of impact. </p><h3>Job Description </h3><p><strong>Overview: </strong> </p><p>Estimate total costs of printing and/or binding magazines, pamphlets, periodicals, books, and other variable printed matter based on job specifications that are primarily unique/moderately complex and occasionally may be routine/repeat opportunities. Prepare competitive pricing estimates for Sales to close new/existing business opportunities and retain existing customer base. Work with Customers, Sales, and Legal on the preparation of Contracts for work. Apply knowledge of print manufacturing to make determinations on the best manufacturing methods to produce customer products efficiently while maintaining high-quality standards and meeting revenue forecasts for work. </p><p><strong>Responsibilities: </strong> </p><ul><li>Prepare comprehensive pricing models for a mix of moderately complex and occasionally complex bid proposals. </li><li>Examine customer specifications, sketches, and/or sample layouts, and calculates unit and production costs considering factors such as size and the number of sheets or pages, paper stock requirements, binding operations, halftones, number and units of colors, and quality of finished product, labor, and material pricing, so as to determine a cost-effective and competitive price. </li><li>Prepares timely, accurate, and detailed cost estimates for printing jobs by determining the most economical method of manufacturing while considering production capacity and equipment across platforms. </li><li>Routinely provide multiple pricing options and scenarios to Sales by comparing different methods of manufacturing, materials, materials sizes, etc to deliver pricing options to Sales. </li><li>Work with Sales and operations to develop a competitive price strategy to win prospective and ongoing deals from customers. </li><li>Confer with Sales and Operations on long-term work/multi-year deals to build pricing models/forecasts. </li><li>Work with operations on new or unique opportunities to ensure projects can be produced in-house. </li><li>Provide recommendations from a pricing perspective to how a product can be created or manufactured. </li><li>Performs financial analyses, including forecasts, projections, and historical assessments on multi-year deals. </li><li>Facilitates the management approvals required for price levels and contract terms. </li><li>Facilitates communication among management, sales, and plant staff regarding contract and price. </li><li>May be responsible for compiling and preparing customer contracts working with legal and updating and appending price schedules and contract terms. </li><li>In consultation with sales, may leverage the use of incentives to close competitive deals. </li><li>Maintain knowledge of market competitive pricing and factor in the market when developing pricing strategy and recommendations. </li><li>Functions as plant and management resource on general pricing and contract issues. </li><li>Determine the need to engage outside vendors to produce work and work with external vendors to negotiate pricing and/or timelines. </li><li>Performs other related duties and participates in special projects as assigned. </li> </ul><h3>Qualifications </h3><ul><li>Bachelor's degree in a discipline related to functional work preferred. </li><li>3+ years of relevant work experience minimum. </li><li>Able to demonstrate the ability to solve somewhat more complex problems by analyzing variables and applying appropriate solutions learned through experience and proficiency in understanding the job. </li><li>Must be able to recognize anomalies and critical situations and respond appropriately. </li><li>Must be able to communicate and interact with a variety of internal/external customers and/or co-workers at the level of detail required to resolve issues of moderate complexity. </li><li>Able to apply strong functional computer knowledge in utilizing Microsoft Windows, MAC, or other technical tools in completing assignments. </li><li>May require knowledge of or the ability to quickly learn specialized software to complete work assignments. </li><li>Able to demonstrate continued expertise in the primary tools or applications used in completing daily work assignments. </li><li>Requires very good communication skills with the ability to state messages in a clear manner by using language that is easy for others to understand. </li><li>Must be able to proactively listen to others to understand issues and situations. </li><li>Must be able to clearly articulate business needs to both internal and external customers. </li> </ul><h3>Additional Information </h3><p>The national pay range for this role is $48,400 - $79,500 / year. The pay range may be slightly lower or higher based on the geographic location of the hired employee. The actual pay offered may vary based upon, but not limited to: education, skills, experience, proficiency, performance, shift and location. In addition to base salary, depending on the role, the total compensation package may also include participation in a bonus, commission or incentive program. RRD offers benefits including medical, dental, and vision coverage, paid time off, disability insurance, 401(k) with match, life insurance and other voluntary supplemental insurance coverages, plus tuition assistance, maternity leave, adoption assistance, and employer/partner discounts. </p>#J-18808-Ljbffr

<p>RRD is a leading global provider of marketing, packaging, print, and supply chain solutions that elevate engagement across the complete customer journey. The company offers the industry’s most trusted portfolio of creative execution and world-wide business process consulting, with services designed to lower environmental impact. With 22,000 clients, including 93% of the Fortune 100, and 32,000 employees across 28 countries, RRD brings the expertise, execution, and scale designed to transform customer touchpoints into meaningful moments of impact.</p><h3>Job Description</h3><p><strong>Overview:</strong></p><p>Estimate total costs of printing and/or binding magazines, pamphlets, periodicals, books, and other variable printed matter based on job specifications that are primarily unique/moderately complex and occasionally may be routine/repeat opportunities. Prepare competitive pricing estimates for Sales to close new/existing business opportunities and retain existing customer base. Work with Customers, Sales, and Legal on the preparation of Contracts for work. Apply knowledge of print manufacturing to make determinations on the best manufacturing methods to produce customer products efficiently while maintaining high-quality standards and meeting revenue forecasts for work.</p><p><strong>Responsibilities:</strong></p><ul><li>Prepare comprehensive pricing models for a mix of moderately complex and occasionally complex bid proposals.</li><li>Examine customer specifications, sketches, and/or sample layouts, and calculates unit and production costs considering factors such as size and the number of sheets or pages, paper stock requirements, binding operations, halftones, number and units of colors, and quality of finished product, labor, and material pricing, so as to determine a cost-effective and competitive price.</li><li>Prepares timely, accurate, and detailed cost estimates for printing jobs by determining the most economical method of manufacturing while considering production capacity and equipment across platforms.</li><li>Routinely provide multiple pricing options and scenarios to Sales by comparing different methods of manufacturing, materials, materials sizes, etc to deliver pricing options to Sales.</li><li>Work with Sales and operations to develop a competitive price strategy to win prospective and ongoing deals from customers.</li><li>Confer with Sales and Operations on long-term work/multi-year deals to build pricing models/forecasts.</li><li>Work with operations on new or unique opportunities to ensure projects can be produced in-house.</li><li>Provide recommendations from a pricing perspective to how a product can be created or manufactured.</li><li>Performs financial analyses, including forecasts, projections, and historical assessments on multi-year deals.</li><li>Facilitates the management approvals required for price levels and contract terms.</li><li>Facilitates communication among management, sales, and plant staff regarding contract and price.</li><li>May be responsible for compiling and preparing customer contracts working with legal and updating and appending price schedules and contract terms.</li><li>In consultation with sales, may leverage the use of incentives to close competitive deals.</li><li>Maintain knowledge of market competitive pricing and factor in the market when developing pricing strategy and recommendations.</li><li>Functions as plant and management resource on general pricing and contract issues.</li><li>Determine the need to engage outside vendors to produce work and work with external vendors to negotiate pricing and/or timelines.</li><li>Performs other related duties and participates in special projects as assigned.</li></ul><h3>Qualifications</h3><ul><li>Bachelor's degree in a discipline related to functional work preferred.</li><li>3+ years of relevant work experience minimum.</li><li>Able to demonstrate the ability to solve somewhat more complex problems by analyzing variables and applying appropriate solutions learned through experience and proficiency in understanding the job.</li><li>Must be able to recognize anomalies and critical situations and respond appropriately.</li><li>Must be able to communicate and interact with a variety of internal/external customers and/or co-workers at the level of detail required to resolve issues of moderate complexity.</li><li>Able to apply strong functional computer knowledge in utilizing Microsoft Windows, MAC, or other technical tools in completing assignments.</li><li>May require knowledge of or the ability to quickly learn specialized software to complete work assignments.</li><li>Able to demonstrate continued expertise in the primary tools or applications used in completing daily work assignments.</li><li>Requires very good communication skills with the ability to state messages in a clear manner by using language that is easy for others to understand.</li><li>Must be able to proactively listen to others to understand issues and situations.</li><li>Must be able to clearly articulate business needs to both internal and external customers.</li></ul><h3>Additional Information</h3><p>The national pay range for this role is $48,400 - $79,500 / year. The pay range may be slightly lower or higher based on the geographic location of the hired employee. The actual pay offered may vary based upon, but not limited to: education, skills, experience, proficiency, performance, shift and location. In addition to base salary, depending on the role, the total compensation package may also include participation in a bonus, commission or incentive program. RRD offers benefits including medical, dental, and vision coverage, paid time off, disability insurance, 401(k) with match, life insurance and other voluntary supplemental insurance coverages, plus tuition assistance, maternity leave, adoption assistance, and employer/partner discounts.</p>
#J-18808-Ljbffr

RRD is a leading global provider of marketing, packaging, print, and supply chain solutions that elevate engagement across the complete customer journey. The company offers the industry’s most trusted portfolio of creative execution and world-wide business process consulting, with services designed to lower environmental impact. With 22,000 clients, including 93% of the Fortune 100, and 32,000 employees across 28 countries, RRD brings the expertise, execution, and scale designed to transform customer touchpoints into meaningful moments of impact.
Job Description  RR Donnelley is looking for an SAP FICO business analyst to work with team members in managing enhancements and new functionality projects in our established SAP ECC system.
RR Donnelley’s SAP footprint is focused on core financials and utilizes interfaces with legacy systems for manufacturing and customer invoicing functionality. We are looking for candidates that have experience in accounting, extensive SAP FICO experience, and experience managing small projects.
The ideal candidate will have hands-on accounting, configuration, program development, and small-project management skills focused on SAP accounting functionality.
Responsibilities
Participate in project management by managing small to medium size projects from definition through implementation.
Participate in project planning by providing estimated hours and target dates for all project-related tasks before development begins.
Define application requirements by reviewing requests from our business partners and conducting “solutioning” sessions.
Work with legacy systems teams to design, build, test, and implement data exchange interfaces with legacy systems.
Create design and training documentation for new functionality and projects.
Lead training sessions with users on new functionality.
Gain user approval by developing system prototypes to present to users for their review.
Communicate project status by creating written status reports on a predetermined schedule for large development efforts.
Responsible for the configuration and daily support of the SAP FI and CO modules that are already implemented with a focus on AP and related functions.
Assist users in determining the best method for data reporting, either via standard reports, table downloads, ABAP query, or customer program.
Troubleshoot user issues.
Research in SAP OSS and implementation of OSS notes.
Mentor business users and teammates on FI related to Accounts Receivable and Collections.
Qualifications   SAP configuration in FI (GL, AP, AR, FA) and CO (PCA, Cost Centers, IO).
Experience with MM, Purchasing, SD, or PP is a plus.
Experience designing, implementing and supporting interfaces with legacy systems.
Program design and testing including requirements gathering.
Training development and delivery skills.
Good written and verbal communication skills.
Solid understanding of accounting, actual accounting experience is a plus.
Strong problem-solving skills, organizational skills, and communication (written and oral) skills.
Required Experience
Candidate should possess a 4-year degree in accounting, business, computer science or related field.
Hands-on accounting experience is desired.
Minimum five years of SAP R/3 Finance (FI) & Controlling (CO) configuration and implementation experience.
SAP FI/CO configuration experience in FA, A/R, A/P, and GL.
SAP FI/CO configuration experience in CCA/PCA.
Knowledge of and experience with integration of FI/CO with other SAP modules.
Knowledge of and experience with interface design and support.
Deep understanding in accounting business processes.
Functional knowledge of common Financial interfaces or programs.
Experience with SAP ECC 6.0 or higher is required.
Experience with Ariba Procurement application would be a plus.
Experience with SAP Security would be a plus.
Additional Information  The national pay range for this role is $74,600 to $132,500 / year. The pay range may be slightly lower or higher based on the geographic location of the hired employee. The actual pay offered may vary based upon, but not limited to: education, skills, experience, proficiency, performance, shift and location. In addition to base salary, depending on the role, the total compensation package may also include participation in a bonus, commission or incentive program. RRD offers benefits including medical, dental, and vision coverage, paid time off, disability insurance, 401(k) with match, life insurance and other voluntary supplemental insurance coverages, plus tuition assistance, maternity leave, adoption assistance, and employer/partner discounts.

#J-18808-Ljbffr

Rr Donnelley Business Intelligence Interview Guide

Overview

Rr Donnelley Business Intelligence Salary

Rr Donnelley Business Intelligence Interview Process

Rr Donnelley Business Intelligence Interview Questions

Rr Donnelley Business Intelligence Jobs