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

Roche Business Intelligence Interview Guide

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


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

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

Overview

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

Roche 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>Write a query to show the number of users, number of transactions placed, and total order amount per month in the year 2020. Assume that we are only interested in the monthly reports for a single year (January-December).</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>products</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>

<tr>
<td><code>price</code></td>
<td>FLOAT</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>

<tr>
<td><code>sex</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>month</code></td>
<td>INTEGER</td>
</tr>

<tr>
<td><code>num_customers</code></td>
<td>INTEGER</td>
</tr>

<tr>
<td><code>num_orders</code></td>
<td>INTEGER</td>
</tr>

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


Monthly Customer Report

<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

Roche Business Intelligence Interview Questions

<p>Roche fosters diversity, equity and inclusion, representing the communities we serve. When dealing with healthcare on a global scale, diversity is an essential ingredient to success. We believe that inclusion is key to understanding people's varied healthcare needs. Together, we embrace individuality and share a passion for exceptional care. Join Roche, where every voice matters. The Position Sr. Business Intelligence Analyst A healthier future. It's what drives us to innovate. To continuously advance science and ensure everyone has access to the healthcare they need today and for generations to come.Creating a world where we all have more time with the people we love. That's what makes us Roche. The Opportunity: Do you have a knack for developing business intelligence analytics for Supply Chain? If so, join our amazing team You will upskill our analytics to ensure a robust supply chain for a global market leader. Work within a talented team to develop insight/analytics for supply chain to influence business decisions for multiple products with Diagnostics. Responsibilities: Lead the BI effort as the embedded business intelligence expert on a high-visibility supply chain team where BI and analytics are championed as the key supply chain skills of our present and our future. Collaboratively create the tools and dashboards that will unlock the team's potential to proactively manage supply and enhance the customer journey. Connect with a network of supply chain and BI professionals around the world to have real impact on our customers and patients. Provide training via 1:1 collaborations or within a larger training session to further expand the teams' skills. Build robust, reliable, professional solutions and models by being able to take the proof of concept models from fellow team members (supply and demand planners and their leaders) and coach them into fit-for-purpose solutions or bring them to the next level into scalable, user-friendly, professionalized products. Continue to self-develop and grow knowledge in Supply Chain. Who You Are Bachelor's degree in a Business, Scientific or related field such as Finance, Marketing, MIS, IT, Engineering or a related discipline. 5 years of direct related experience as a Business Analyst (reporting, analytics, visualization and data management) in regulated or policy-heavy environment (e.g. diagnostics, medical devices, pharma, biotech, healthcare, financial services, legal, consulting, etc.). Experience with SQL Server, Alteryx, Tableau, and Snowflake required. Understanding of Supply Chain processes (orders, inventory, shipments, receipts, forecasts, etc.). Preferred: Strong stakeholder management, communication and change management skills. Outstanding customer service and interpersonal skills. Advanced analytical problem solving skills, attention to details, agile with a positive mindset. The expected salary range for this position based on the primary location of Indiana state is $83,900 - $155,700. Actual pay will be determined based on experience, qualifications, geographic location, and other job-related factors permitted by law. A discretionary annual bonus may be available based on individual and Company performance. This position also qualifies for the benefits detailed at the link provided below. Benefits Relocation benefits are not available for this job posting. Who we are At Roche, more than 100,000 people across 100 countries are pushing back the frontiers of healthcare. Working together, we've become one of the world's leading research-focused healthcare groups. Our success is built on innovation, curiosity and diversity. As a global leader in healthcare, Roche Diagnostics offers a broad portfolio of products, tools and services that help in the prevention, diagnosis and management of diseases like HPV, HIV, hepatitis and diabetes as well as other medical conditions, such as fertility and blood coagulation. These products and services are used by researchers, physicians, patients, hospitals and laboratories worldwide to help improve people's lives. Roche is an equal opportunity employer and strictly prohibits unlawful discrimination based upon an individual's race, color, religion, gender, sexual orientation, gender identity/expression, national origin/ancestry, age, mental/physical disability, medical condition, marital status, veteran status, or any other characteristic protected by law. If you have a disability and need an accommodation in relation to the online application process, please contact us by completing this form Accommodations for Applicants.</p>

<p>Roche fosters diversity, equity and inclusion, representing the communities we serve. When dealing with healthcare on a global scale, diversity is an essential ingredient to success. We believe that inclusion is key to understanding people's varied healthcare needs. Together, we embrace individuality and share a passion for exceptional care. Join Roche, where every voice matters. The Position A healthier future. It's what drives us to innovate. To continuously advance science and ensure everyone has access to the healthcare they need today and for generations to come. Creating a world where we all have more time with the people we love. That's what makes us Roche. The Opportunity Do you have a knack for developing business intelligence analytics for Supply Chain? If so, join our amazing team You will upskill our analytics to ensure a robust supply chain for a global market leader. Work within a talented team to develop insight/analytics for supply chain to influence business decisions for multiple products with Diagnostics. Responsibilities: Lead the BI effort as the embedded business intelligence expert on a high-visibility supply chain team where BI and analytics are championed as the key supply chain skills of our present and our future. Collaboratively create the tools and dashboards that will unlock the team's potential to proactively manage supply and enhance the customer journey. Connect with a network of supply chain and BI professionals around the world to have real impact on our customers and patients. Provide training via 1:1 collaborations or within a larger training session to further expand the teams' skills. Build robust, reliable, professional solutions and models by being able to take the proof of concept models from fellow team members (supply and demand planners and their leaders) and coach them into fit-for-purpose solutions or bring them to the next level into scalable, user-friendly, professionalized products. Continue to self-develop and grow knowledge in Supply Chain. Who You Are Bachelor's degree in a Business, Scientific or related field such as Finance, Marketing, MIS, IT, Engineering or a related discipline. 3-5 years of direct related experience as a Business Analyst (reporting, analytics, visualization and data management) in regulated or policy-heavy environment (e.g. diagnostics, medical devices, pharma, biotech, healthcare, financial services, legal, consulting, etc.). Experience with SQL Server, Alteryx, Tableau, and Snowflake required. Understanding of Supply Chain processes (orders, inventory, shipments, receipts, forecasts, etc.). Preferred Strong stakeholder management, communication and change management skills. Outstanding customer service and interpersonal skills. Advanced analytical problem solving skills, attention to details, agile with a positive mindset. The expected salary range for this position based on the primary location of Indiana Base Pay Range $77,800 - $144,600 Annual. Actual pay will be determined based on experience, qualifications and other job-related factors permitted by law. A discretionary annual bonus may be available based on individual and Company performance, as well as participation in a long-term incentive program. This position also qualifies for the benefits detailed at the link provided below. Benefits Location: This position is based in Indianapolis, IN Relocation: Relocation benefits are not available for this posting Who we are At Roche, more than 100,000 people across 100 countries are pushing back the frontiers of healthcare. Working together, we've become one of the world's leading research-focused healthcare groups. Our success is built on innovation, curiosity and diversity. As a global leader in healthcare, Roche Diagnostics offers a broad portfolio of products, tools and services that help in the prevention, diagnosis and management of diseases like HPV, HIV, hepatitis and diabetes as well as other medical conditions, such as fertility and blood coagulation. These products and services are used by researchers, physicians, patients, hospitals and laboratories worldwide to help improve people's lives. Roche is an equal opportunity employer and strictly prohibits unlawful discrimination based upon an individual's race, color, religion, gender, sexual orientation, gender identity/expression, national origin/ancestry, age, mental/physical disability, medical condition, marital status, veteran status, or any other characteristic protected by law. If you have a disability and need an accommodation in relation to the online application process, please contact us by completing this form Accommodations for Applicants.</p>

Roche Business Intelligence Interview Guide

Overview

Roche Business Intelligence Salary

Roche Business Intelligence Interview Process

Roche Business Intelligence Interview Questions

Roche Business Intelligence Jobs