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

Guy Carpenter Business Intelligence Interview Guide

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


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

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

Overview

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

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

<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

Guy Carpenter Business Intelligence Interview Questions

<p>Guy Carpenter is seeking candidates for the following position based in the Mumbai office.</p><p><br></p><p><strong>What can you expect? </strong></p><p>• We are seeking a highly skilled and motivated Power BI Specialist to join our team as a key member of the Management Information department As a Power BI Specialist, you will be responsible for developing and maintaining interactive dashboards, reports, and visualizations using Power BI to support data-driven decision-making and provide valuable insights to stakeholders. Additionally, proficiency in Excel, SQL and Access database, VBA development, Power Apps, and Power Automate will be essential for this role.</p><p><strong>What is in it for you?</strong></p><p>• Opportunity to enhance your knowledge in Insurance/Reinsurance broking</p><p>• As a Specialist, you will have the opportunity to analyze and interpret data to provide valuable insights and recommendations to key stakeholders</p><p>• Exposure to different business functions and departments, which can broaden your understanding of the organization as a whole</p><p>• Opportunity to work with global leads on various initiatives (process improvement, automation)</p><p><br></p><p><strong>We will count on you for: </strong></p><p>• Collaborate with business stakeholders to understand their reporting and analytics requirements and translate them into effective Power BI solutions.</p><p>• Design, develop, and maintain interactive dashboards, reports, and visualizations using Power BI to provide actionable insights and support data-driven decision-making.</p><p>• Utilize Excel, SQL, and Access database skills to extract, transform, and load data from various sources into Power BI for analysis and visualization.</p><p>• Develop VBA macros and automation solutions to enhance data processing and reporting capabilities.</p><p>• Leverage Power Apps and Power Automate to create custom applications and automate workflows for data collection, analysis, and reporting.</p><p>• Create and optimize data models, data connections, and data transformations to ensure accurate and efficient data analysis.</p><p>• Perform data analysis and data profiling using SQL to identify data quality issues and recommend solutions for data cleansing and data governance.</p><p>• Collaborate with data engineers and data architects to ensure the availability, reliability, and security of data sources and data pipelines.</p><p>• Stay up to date with the latest Power BI features, Excel functions, SQL queries, and industry trends to continuously improve the reporting and analytics capabilities.</p><p><br></p><p><strong>What you need to have: </strong></p><p>• This role requires proficiency in Microsoft Excel, SQL, and Power BI</p><p>• Skills such as data modeling, statistical analysis, data mining, and data visualization</p><p>• Collaborative (good at working in a team)</p><p>• Effective communicator</p><p>• Attention to detail</p><p>• Analytical ability and Decision making</p><p>• Influencing and Negotiation skills</p><p><br></p><p><strong>What makes you stand out?</strong></p><p>• Strong problem-solving and analytical skills and ability to work with large quantities of data</p><p>• Good communication, collaboration and people skills</p><p>• Strong ability to plan and manage numerous processes, people and priorities simultaneously</p><p>• Experience in statutory audits and dealing with auditors.</p><p><br></p><p><strong>Guy Carpenter & Company</strong>, LLC is a leading global risk and reinsurance specialist with more than 3,500 professionals in over 60 offices around the world. Guy Carpenter delivers a powerful combination of broking expertise, trusted strategic advisory services and industry-leading analytics to help clients adapt to emerging opportunities and achieve profitable growth. Guy Carpenter is a business of Marsh McLennan (NYSE: MMC), the world’s leading professional services firm in the areas of risk, strategy and people. The company’s 85,000 colleagues advise clients in over 130 countries. With annualized revenue of over $23 billion, Marsh McLennan helps clients navigate an increasingly dynamic and complex environment through four market-leading companies including Marsh, Mercer and Oliver Wyman. For more information, visit www.guycarp.com and follow us on LinkedIn and X.</p><p><strong>Marsh McLennan</strong> is committed to embracing a diverse, inclusive and flexible work environment. We aim to attract and retain the best people and embrace diversity of age, background, caste, disability, ethnic origin, family duties, gender orientation or expression, gender reassignment, marital status, nationality, parental status, personal or social status, political affiliation, race, religion and beliefs, sex/gender, sexual orientation or expression, skin color, or any other characteristic protected by applicable law.</p><p><strong>Marsh McLennan</strong> is committed to hybrid work, which includes the flexibility of working remotely and the collaboration, connections and professional development benefits of working together in the office. All Marsh McLennan colleagues are expected to be in their local office or working onsite with clients at least three days per week. Office-based teams will identify at least one “anchor day” per week on which their full team will be together in person</p>

Guy Carpenter Business Intelligence Interview Guide

Overview

Guy Carpenter Business Intelligence Salary

Guy Carpenter Business Intelligence Interview Process

Guy Carpenter Business Intelligence Interview Questions

Guy Carpenter Business Intelligence Jobs