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

ExxonMobil Business Intelligence Interview Guide

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


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

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

Overview

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

A/B Testing

Algorithms

Analytics

Machine Learning

Probability

Product Metrics

Python

Statistics

ExxonMobil 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>Let’s say you’re working for a social media company trying to grow your user base. You know that people tend to use the same social network as their peers, so you want to target all your growth and marketing efforts on specific age groups so as to take advantage of network effects.</p>

<p>You wish to begin with the age group that is currently generating the most connections (fastest growing).</p>

<p>Write a SQL query to find the average number of accepted friend requests for each age group and order the results in descending order.</p>

<p><em>Note: The average number of accepted friend requests is calculated as the total number of friend requests sent by an age group that was accepted divided by the number of members in said age group.</em></p>

<p><em>We can assume the tables hold valid data in that there are no duplicate friend requests, friend requests are only accepted once, and user A can only accept a friend request from User B after B sends A a friend request.</em></p>

<p><em>The result should be rounded to two decimal places.</em></p>

<h3>Example:</h3>

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

<p><strong><code>friend_requests</code></strong></p>

<table>
<thead>
<tr>
<th>Column</th>
<th>Type</th>
</tr>
</thead>

<tbody>
<tr>
<td>requester_id</td>
<td>INTEGER</td>
</tr>

<tr>
<td>receiver_id</td>
<td>INTEGER</td>
</tr>

<tr>
<td>sent_at</td>
<td>DATETIME</td>
</tr>
</tbody>
</table>
<p><strong><code>requests_accepted</code></strong></p>

<table>
<thead>
<tr>
<th>Column</th>
<th>Type</th>
</tr>
</thead>

<tbody>
<tr>
<td>accepter_id</td>
<td>INTEGER</td>
</tr>

<tr>
<td>requester_id</td>
<td>INTEGER</td>
</tr>

<tr>
<td>accepted_at</td>
<td>DATETIME</td>
</tr>
</tbody>
</table>
<p><strong><code>age_groups</code></strong></p>

<table>
<thead>
<tr>
<th>Column</th>
<th>Type</th>
</tr>
</thead>

<tbody>
<tr>
<td>user_id</td>
<td>INTEGER</td>
</tr>

<tr>
<td>age_group</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>age_group</td>
<td>VARCHAR</td>
</tr>

<tr>
<td>average_acceptance</td>
<td>FLOAT</td>
</tr>
</tbody>
</table>


Find the average number of accepted friend requests for each age group that sent the requests.

Avg Friend Requests By Age Group

ExxonMobil Business Intelligence Interview Questions

<b>About us</b><br><br>At ExxonMobil, our vision is to lead in energy innovations that advance modern living and a net-zero future. As one of the world's largest publicly traded energy and chemical companies, we are powered by a unique and diverse workforce fueled by the pride in what we do and what we stand for. ExxonMobil is a place where we believe people should think independently, take initiative, grow to their full potential and help shape the future of energy. Diversity drives innovation and we are committed to providing inclusive workplaces where everyone can thrive, regardless of their background. The safety and wellbeing of our employees is at the heart of everything we do. We build skills and competencies through training and work experiences in a wide range of assignments. With a long history of industry leadership and cutting edge innovation, we are committed to addressing the dual challenge facing society today: to meet the world's growing demand for energy while reducing environmental impacts, including the risk of climate change. Learn more about our What and our Why and how we can work together.<br><br>We are expanding our trading business, transitioning to a global trading organization. To further capitalize on commercial insights, we are rapidly building our trading, origination, risk management & analytical capabilities to capture new assets and enter new market areas. We are looking for passionate individuals with an entrepreneurial mind-set to drive change in our business.<br><br><strong>About Houston</strong><br><br>ExxonMobil's state-of-the-art campus north of Houston was opened in 2014.<br><br>By bringing many global functional groups together, the campus provides employees with the tools and capabilities needed today, and in the future, to achieve business objectives and accelerate the discovery of new resources, technologies and products. It was designed to foster improved collaboration, creativity and innovation and enhance the company's ability to attract, develop and retain the top talent in the industry. The campus is located in Spring, Texas, on 385 wooded acres immediately to the west of Interstate Highway 45 (I-45), at the intersection of I-45 and the Hardy Toll Road, approximately 25 miles from the cultural vibrancy of downtown Houston. <br><br><strong>Job Role Summary</strong><br><br>The current opportunity is for a Business Analyst to join our Crude, Products, & Feedstock Trading Team, based in Houston, Texas. If successful you will be an integral part of our Trading Enablement team, specifically focused on Crude & Products Trading, supporting our ETRM system (Endur) in the execution of day-to-day activities and multiple major enhancement projects we currently have underway.<br><br><strong>Job Role Responsibilities</strong><br>•Member of cross-discipline team with strong business knowledge and systems understanding, partnering with the Trading business & IT to effectively utilize systems & data to deliver value.<br>•Focal point for ETRM system support for hydrocarbon trading.<br>•SME or Advisor in system projects and enhancement initiatives, across the globe. Recognized as an expert in business process knowledge, process/controls requirements, systems usage.<br>•Focal point for master data maintenance in Endur ETRM and related systems.<br>•Aware of upcoming business, process and system changes and identifies implementation needs. Proactively looks for ways to increase effectiveness and efficiency in our systems (eliminate, simplify, automate, standardize).<br>•Testing of new system functionality as part of regular system upgrades and for new functionality releases.<br>•Mentor's and coach's others, including preparing and delivering training to the broader Trading team and IT.<br><br><strong>About You</strong><br>•Degree in a STEM subject from a recognized university.<br>•An effective team player with strong analytical, communication and interpersonal skills.<br>•A strong functional and technical resource with Experienced Professional in Endur implementation and support for hydrocarbon trading.<br>•In-depth knowledge of trade lifecycle including Deal Entry, Positions Reporting, Exposures, Mark to Market, P&L, Accounting, Logistics, Settlement, Valuation & Operations.<br>•Strong issue diagnosis and resolution skills, with proactive attitude to take ownership of tasks. Strong collaboration skills. Good communication skills, including fluent English.<br><br><strong>Benefits</strong><br><br>An ExxonMobil career is one designed to last. Our commitment to you runs deep: our employees grow personally and professionally, with benefits built on our core categories of health, security, finance, and life. We offer you a wide range of benefits including:<br>•Competitive pay<br>•Pension Plan: Enrollment is automatic and at no cost to you. The basic benefit is a monthly annuity to be paid to you in retirement for the rest of your life<br>•Savings Plan: If you contribute at least 6% to your savings plan, the Company will contribute a 7% match<br>•Workplace Flexibility: We have several programs such as "Flex your Day", providing ad-hoc flexibility around when and where you work, as well as longer-term programs such as leaves of absence and part-time work<br>•Comprehensive medical, dental, and vision plans<br>•Culture of Health: Programs and resources to support your wellbeing<br>•Employee Health Advisory Program: Provides confidential professional counseling for you and your family, including tools and resources promoting mental health and resiliency at no additional cost to you<br>•Disability Plan: Income replacement for when you cannot work due to illness or injury occurring on or off the job. Enrollment is automatic and at no cost to you.<br><br>You will be part of a team that supports and inspires you, the flexibility to explore multiple challenges and roles. Your development never stops. A variety of job roles and access to cutting-edge training let you expand your potential throughout an entire career. At ExxonMobil we have your back. We want you to enjoy a career with us.<br><br>More information on ExxonMobil benefits can be found at www.exxonmobilfamily.com. <br> <br>Please note benefits may change without notice, subject to applicable law.<br><br>Stay connected with us<br> <br>Learn more at our website<br>Follow us on LinkedIn and Instagram<br>Like us on Facebook <br>Subscribe to our channel at YouTube<br><br>Employee Equal Opportunity<br> <br>ExxonMobil is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, age, sexual orientation, gender identity, national origin, citizenship status, protected veteran status, genetic information, or physical or mental disability.<br><br>Nothing herein is intended to override the corporate separateness of local entities. Working relationships discussed herein do not necessarily represent a reporting connection, but may reflect a functional guidance, stewardship, or service relationship. <br><br>Exxon Mobil Corporation has numerous affiliates, many with names that include ExxonMobil, Exxon, Esso and Mobil. For convenience and simplicity, those terms and terms like corporation, company, our, we and its are sometimes used as abbreviated references to specific affiliates or affiliate groups. Abbreviated references describing global or regional operational organizations and global or regional business lines are also sometimes used for convenience and simplicity. Similarly, ExxonMobil has business relationships with thousands of customers, suppliers, governments, and others. For convenience and simplicity, words like venture, joint venture, partnership, co-venturer, and partner are used to indicate business relationships involving common activities and interests, and those words may not indicate precise legal relationships.

ExxonMobil Business Intelligence Interview Guide

Overview

ExxonMobil Business Intelligence Salary

ExxonMobil Business Intelligence Interview Process

ExxonMobil Business Intelligence Interview Questions

ExxonMobil Business Intelligence Jobs