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

International Sos Business Intelligence Interview Guide

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


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

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

Overview

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

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

International Sos Business Intelligence Interview Questions

<strong><b>Join Our Team as a Jr. Business Analyst at MedAire!</b></strong><br><br>Are you passionate about leveraging data to drive business success? Do you thrive in a dynamic, fast-paced environment? MedAire is looking for a Jr. Business Analyst to join our team and make a significant impact on our sales processes and overall business efficiency.<br><br><strong><b>As a Jr. Business Analyst, you will:</b></strong><br><br><ul> <li>Analyze and Understand Business Challenges: Identify bottlenecks in the sales process and design new or improve existing processes.</li> <li>Document Processes: Develop and maintain documents detailing process flows, best practices, and task execution.</li> <li>Support Sales Community: Prepare and maintain records, documents, files, and reports.</li> <li>Manage Requests: Collaborate with the global Commercial Services team to manage and resolve requests from the sales team.</li> <li>Integrate AI Solutions: Develop and implement generative AI models to enhance workflow efficiencies.</li> <li>Advise on Pricing: Serve as an advisor on pricing-related questions and concerns.</li> <li>Stay Updated: Keep abreast of the latest sales trends and best practices.</li> <li>Utilize Salesforce: Ensure real-time updates of all client-related activities in Salesforce.com.</li> <li>Perform Other Duties: Take on additional relevant tasks as assigned.</li></ul><br><strong><b>Key Responsibilities:</b></strong><br><br><ul> <li>Monitor Sales Performance: Work with regional sales teams to track pipeline progress, lead generation, and KPIs.</li> <li>Project Management: Oversee the implementation of new sales tools and processes, including user testing and rollout.</li> <li>Salesforce Support: Animate a community of 150+ Salesforce users, supporting adoption and effective use.</li> <li>Power BI Reporting: Maintain and produce reports using Power BI tools to support regional decision-making.</li> <li>Pricing Management: Review and manage price indexation, exception pricing, and sales quotes to ensure compliance with guidelines.</li></ul><br><strong>Skills and Knowledge:</strong><br><br><ul> <li>Advanced use of Microsoft Excel and Power BI.</li> <li>Strong commercial awareness and numerical literacy.</li> <li>Excellent presentation and communication skills.</li> <li>Strong analytical and conceptual skills.</li> <li>Knowledge of Salesforce.com, Generative AI tools, Power Automate, SQL, and DAX is desirable.</li></ul><br><b>Competencies:</b><br><br><ul> <li>Establishes effective relationships within the organization.</li> <li>Rapidly learns new tasks and technical skills.</li> <li>Autonomous and self-driven with the ability to manage projects with limited supervision.</li></ul><br><strong>Experience and Qualifications:</strong><br><br><ul> <li>2 years of experience in a sales support role or as a business analyst in a large, global organization.</li> <li>Bachelor's degree in business management or an IT-related field.</li> <li>Proficiency in English is essential; knowledge of other languages is a plus.</li> <li>Willingness to travel regularly for internal meetings.</li></ul><br><b>Why Join MedAire?</b><br><br><ul> <li>At MedAire, we value innovation, collaboration, and continuous learning. Join us to be part of a team that is dedicated to making a difference in the world of business analytics and sales support.</li> <li>Apply Now and take the next step in your career with MedAire!</li></ul><br>International SOS is an equal opportunity employer and does not discriminate against employees or job applicants on the basis of race, color, religion, gender, sexual orientation, gender identity, national origin, age, disability, genetic information, marital status, amnesty or status as a covered veteran in accordance with applicable federal, state and local laws.

International Sos Business Intelligence Interview Guide

Overview

International Sos Business Intelligence Salary

International Sos Business Intelligence Interview Process

International Sos Business Intelligence Interview Questions

International Sos Business Intelligence Jobs