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

Novo Nordisk Business Intelligence Interview Guide

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


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

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

Overview

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

Novo Nordisk 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 identify the manager with the biggest team size.</p>

<p>You may assume there is only one manager with the largest team size.</p>

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

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

<p><code>employees</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>manager_id</code></td>
<td>INTEGER</td>
</tr>
</tbody>
</table>
<p><code>managers</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>team</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>manager</code></td>
<td>VARCHAR</td>
</tr>

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


Manager Team Sizes

<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

Novo Nordisk Business Intelligence Interview Questions

<p><strong>The Position</strong></p><p>As an Advanced Business Analyst I for SAP FI Solutions at Novo Nordisk, you will be anchoring below responsibilities:</p><ul><li>Manage global application expectations, support system manager along with oversee daily operation and maintenance in SAP BTP platform.</li><li>Handle incident, problem and change management using ServiceNow, monitor process effectiveness, and maintain CI-CD pipeline in Azure DevOps.</li><li>Assist in budget\SLA management, ensure compliance with internal and external requirements, and GDPR regulations.</li><li>Represent the system in audits, update project documentation, and develop test cases and reports.</li><li>Support in managing application security, vulnerability, testing IT recovery procedure for Applications.</li></ul><p><br></p><p><strong>Qualifications </strong></p><ul><li>MSC, MBA, BA, or similar graduate degree in relevant field (Software Engineering, Economics, Computer Science, Business Administration.</li><li>Should have overall 10+ year of industry experience with relevant 8+years’ experience of financial services industry.</li><li>Experience with SAP BTP in finance domain.</li><li>Ability to collaborate and communicate with external parties and end- users.</li><li>Large degree of flexibility and ability to work under strong time pressure.</li><li>Capability to understand business needs quickly.</li><li>Excellent communication skills in written and verbal English.</li></ul><p></p>

<p><strong>Department: </strong>You will be organizationally placed in HR DD&IT in GBS, and you will report to the local Head of HR IT Business Solutions. The internal IT systems in Novo Nordisk support our 55,000 colleagues globally and our 5,000 managers. Our goal is to create intuitive user experience and business value for our colleagues using these systems. We are anchored in DD&IT Staffs in the global Digital, Data & IT organization.</p><p><br></p><p><strong>The Position</strong></p><ul><li>Responsible for the operation & maintenance support that includes roll-over cycles, new compensation projects, change management and compliance of SuccessFactors Compensation system while adapting the feasible changes requested by stakeholders in the system.</li><li>Performing configuration and testing tasks to deliver fixes, changes, improvements, and compliance.</li><li>Provide solutions and suggestions to cater the need of the business without compromising system functionalities or performance.</li><li>Responsible for configuration management and testing the system and updating the change requests on a regular basis.</li><li>Be in touch with SAP to understand the changes in the system and act as a bridge between business and the implementation vendor to ensure the processes are in place for any new implementation and align with other module team members to understand the implications that can occur from other module implementations.</li></ul><p><br></p><p><strong>Qualifications</strong></p><ul><li>MSC, MBA, bachelor’s or similar graduate degree in relevant field (Software Engineering, Economics, Computer Science, Business Administration).</li><li>6+ years of experience with IT with relevant 4+ years of experience in SuccessFactors Compensation.</li><li>Should have 2+ years of experience configuring/implementing SAP.</li><li>Experience in vendors management with strong stakeholder management.</li><li>Experience of Pharmaceutical industry experience (working with GxP system) is a value add. Knowledge on Agile, Scrum, Safe would be an add-on. Knowledge on ServiceNow would be a value add.</li></ul><p><br></p><p><strong>Working at Novo Nordisk</strong></p><p>Novo Nordisk is a leading global healthcare company with a 100-year legacy of driving change to defeat serious chronic diseases. Building on our strong legacy within diabetes, we are growing massively and expanding our commitment, reaching millions around the world and impacting more than 40 million patient lives daily. All of this has made us one of the 20 most valuable companies in the world by market cap. Our success relies on the joint potential and collaboration of our more than 63,000 employees around the world. We recognize the importance of the unique skills and perspectives our people bring to the table, and we work continuously to bring out the best in them. Working at Novo Nordisk, we’re working toward something bigger than ourselves, and it’s a collective effort. Join us! Together, we go further. Together, we’re life changing.</p><p></p>

Novo Nordisk Business Intelligence Interview Guide

Overview

Novo Nordisk Business Intelligence Salary

Novo Nordisk Business Intelligence Interview Process

Novo Nordisk Business Intelligence Interview Questions

Novo Nordisk Business Intelligence Jobs