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

Bechtel Corporation Business Intelligence Interview Guide

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


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

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

Overview

Bechtel Corporation 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.

Bechtel Corporation 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>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

Bechtel Corporation Business Intelligence Interview Questions

<p><p>**Requisition ID: 272651**</p><br><p>+  **Relocation Authorized: National - Family**</p><br><p>+  **Telework Type: Full-Time Office/Project**</p><br><p>+  **Work Location: Reston, VA**</p><br><p>Since 1898, we have helped customers complete more than 25,000 projects in 160 countries on all seven continents that have created jobs, grown economies, improved the resiliency of the worlds infrastructure, increased access to energy, resources, and vital services, and made the world a safer, cleaner place. Differentiated by the quality of our people and our relentless drive to deliver the most successful outcomes, we align our capabilities to our customers objectives to create a lasting positive impact.</p><br><p>We serve the infrastructure, Nuclear, Security & Environmental; Energy; Mining and Metals; and Manufacturing and Technology markets. Our services span from initial planning and investment, through start-up and operations.</p><br><p>Core to Bechtel are our values-ethics, safety, quality, people, culture, relationships, innovation and sustainability, and our covenants-integrity, respect, collaboration, trust, and delivery. They are what we believe, what customers expect, and how we deliver.</p><br><p># Position Summary</p><br><p>The growth in renewables and energy wider transition requires flexible generation and long duration energy storage. The Bechtel Heavy Civil Infrastructure business is responding to this global challenge and growing its capability in the development and construction of Hydropower and Pumped Storage projects globally.</p><br><p>Bechtel is engaging in several pumped storage development s around the world, including in North America where we are seeking an experienced Project Engineering Manager to lead the technical development and delivery of major projects.</p><br><p>In support of our plans to further develop this project, the Project Engineering Manager will participate in all stages of the project lifecycle, including conceptual design, FEED, detailed design, and project execution.  The Project Engineering Manager will contribute to technical feasibility studies, value engineering, cost development and strategic planning for the project. Reports to the Project Manager and/or the Functional Manager of Engineering.</p><br><p># Responsibilities</p><br><p>+ Provides technical insight and value engineering during development of engineering designs.</p><br><p>+ Coordinates technical scope with Construction and Procurement Functions.</p><br><p>+ Provides support to Business Development, securing new work and external engagement.</p><br><p>+ Manages multi-discipline team executing conceptual design, FEED and project execution.</p><br><p>+ Provides leadership and inspires performance of the project team.</p><br><p># Qualifications and Skills</p><br><p>**Basic Qualifications:**</p><br><p>+ BS/MS Degree in Geotechnical, Civil, Hydraulic, Mechanical or Electrical Engineering with 10+ years of relevant experience.</p><br><p># Additional Qualifications:</p><br><p>+ Professional Engineering License preferred.</p><br><p>+ Experience of design development, feasibility studies, detailed design and/or owner's engineering work (technical specifications, tenders evaluations, design review, construction supervision).</p><br><p>+ Sufficient demonstrable professional experience in the hydropower and pumped storage industry, ideally with an international developer, consultant or contractor.</p><br><p>+ Demonstrable engineering skills and experience including civil structures, dams, tunnels, generation plant and powerhouse complexes.</p><br><p>+ Specific areas of technical expertise would be viewed positively:</p><br><p>+ Large hydropower or pumped storage design and construction.</p><br><p>+ Experience of dams and large hydraulic structures.</p><br><p>+ Knowledge of geology and geotechnics.</p><br><p>+ Tunnelling and underground works experience.</p><br><p>+ Experience with design and integration of M&E equipment.</p><br><p>+ Experience with layout and construction planning of major hydropower or pumped storage projects.</p><br><p>+ Management of multidisciplinary teams, including engineering, procurement, construction.</p><br><p>**#LI-JL1**</p><br><p>**_Shaping tomorrow together_**</p><br><p>**_Bechtel is one of the most respected global engineering, construction, and project management companies. Together with our customers, we deliver landmark projects that foster long-term progress and economic growth. Since 1898, weve completed more than 25,000 extraordinary projects across 160 countries on all seven continents. We operate through four global businesses: Infrastructure; Nuclear, Security & Environmental; Energy; and Mining & Metals. Our company and our culture are built on more than a century of leadership and a relentless adherence to our values, the core of which are safety, quality, ethics, and integrity. These values are what we believe, what we expect, what we deliver, and what we live._**</p><br><p>**_www.bechtel.com_**</p><br><p>**_Bechtel is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity and expression, age, national origin, disability, citizenship status (except as authorized by law), protected veteran status, genetic information, and any other characteristic protected by federal, state or local law._** </p><br><p>**Bechtel employees are required to be vaccinated for COVID-19 or show proof of a negative test result prior to accessing Bechtel sites/facilities to the extent required by applicable law or by customer requirements.** </p><br></p>

Bechtel Corporation Business Intelligence Interview Guide

Overview

Bechtel Corporation Business Intelligence Salary

Bechtel Corporation Business Intelligence Interview Process

Bechtel Corporation Business Intelligence Interview Questions

Bechtel Corporation Business Intelligence Jobs