The East West Bank Business Intelligence interview guide, interview questions, salary data, and interview experiences.

East West Bank Business Intelligence Interview Guide

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


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

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

Overview

East West Bank 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.

East West Bank 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>What are the logistic and softmax functions? What is the difference between the two?</p>

<p>What makes them useful for use in logistic regression?</p>


<p>In logistic regression, how is the predicted class determined based on the logistic function?</p>


In logistic regression, how is the predicted class determined based on the logistic function?

Softmax vs Logistic II

<p>What is the key characteristic of the logistic function that makes it useful for mapping continuous values to a probability?</p>


What is the key characteristic of the logistic function that makes it useful for mapping continuous values to a probability?

Softmax vs Logistic I

What are the logistic and softmax functions? What is the difference between the two?

Softmax vs Logistic

East West Bank Business Intelligence Interview Questions

Introduction:<br/><div><span style="font-size: 10pt; font-family: arial, helvetica, sans-serif;">Since 1973, East West Bank has served as a pathway to success. With over 120 locations across the U.S. and Asia, we are the premier financial bridge between the East and West. Our teams of experienced, multi-cultural professionals help guide businesses and community members on both sides of the Pacific looking to explore new markets and create new opportunities, and our sustained growth and expertise in industries like real estate, entertainment and media, private equity and venture capital, and high-tech help build sustainable businesses and expand our associates potential for career advancement. </span></div><div><span style="font-size: 10pt; font-family: arial, helvetica, sans-serif;"> </span></div><div><span style="font-size: 10pt; font-family: arial, helvetica, sans-serif;">Headquartered in California, East West Bank (Nasdaq: EWBC) is a top performing commercial bank with an exclusive focus on the U.S. and Greater China markets. With a strong foundation, and enterprising spirit and a commitment to absolute integrity, East West Bank gives people the confidence to reach further.</span></div><div> </div><br/><br/>Overview:<br/><p style="margin: 0px;"><span style="font-size: 10.0pt; font-family: 'Arial',sans-serif;">We are seeking a motivated Accounting Analysis and Reporting (AAR) Analyst to join our team. As part of the AAR team, you will be closely involved with month-end activities, perform reconciliations of general ledger accounts, analyze financial data, assist with preparing financial and regulatory reports and board materials, analyze monthly fluctuations, and record journal entries. The ideal candidate will have knowledge of accounting or prior experience in an accounting role, preferably at a bank or financial institution (but not required).</span></p><br/><br/>Responsibilities:<br/><ul><li><span style="font-size: 10.0pt; font-family: 'Arial',sans-serif;">Supports the Accounting Analysis and Reporting (AAR) team in the delivery of operational agenda in various areas, including but not limited to investments (securities, tax credit investments, other equity investments), consolidation, deposits, and subsidiary entities</span></li><li><span style="font-size: 10.0pt; font-family: 'Arial',sans-serif;">Participate in the month end close process, including the reconciliation and certification of general ledger account balances and the preparation/review of journal entries</span></li><li><span style="font-size: 10.0pt; font-family: 'Arial',sans-serif;">Perform analysis on monthly and quarterly general ledger accounts and financial statements</span></li><li><span style="font-size: 10.0pt; font-family: 'Arial',sans-serif;">Support the preparation/review of financial statements and various supporting schedules for 10-Q, 10-K, or other regulatory filings</span></li><li><span style="font-size: 10.0pt; font-family: 'Arial',sans-serif;">Prepare monthly Board materials, including schedules that support the monthly Board package</span></li><li><span style="font-size: 10.0pt; font-family: 'Arial',sans-serif;">Prepare various banking regulatory reports, such as the quarterly Call and FRY Report schedules</span></li><li><span style="font-size: 10.0pt; font-family: 'Arial',sans-serif;">Prepare various schedules and reports for internal users and external auditors, and assist in the audit process including updating SOX control narratives for relevant processes</span></li><li><span style="font-size: 10.0pt; font-family: 'Arial',sans-serif;">Assist with analyzing draft/newly-released regulations and accounting pronouncements to assess accounting impact, as well as collaborate with treasury, financial reporting, operations or other teams to support effective transition to new regulation/standards</span></li><li><span style="font-size: 10.0pt; font-family: 'Arial',sans-serif;">Perform enhancement projects or ad-hoc analysis as needed</span></li></ul><br/><br/>Qualifications:<br/><ul><li><span style="font-size: 10.0pt; font-family: 'Arial',sans-serif;">Solid knowledge of generally accepted accounting principles and concepts</span></li><li><span style="font-size: 10.0pt; font-family: 'Arial',sans-serif;">Public company accounting experience or banking/financial institution experience preferred</span></li><li><span style="font-size: 10.0pt; font-family: 'Arial',sans-serif;">CPA candidate/license or MBA preferred</span></li><li><span style="font-size: 10.0pt; font-family: 'Arial',sans-serif;">Bachelors degree (B.A.) from four-year college or university</span></li><li><span style="font-size: 10.0pt; font-family: 'Arial',sans-serif;">Strong analytical, technical, organizational and problem-solving skills</span></li><li><span style="font-size: 10.0pt; font-family: 'Arial',sans-serif;">Strong attention to detail and accuracy</span></li><li><span style="font-size: 10.0pt; font-family: 'Arial',sans-serif;">Advanced Microsoft Excel and Word skills</span></li><li><span style="font-size: 10.0pt; font-family: 'Arial',sans-serif;">Ability to work well independently and in a team</span></li><li><span style="font-size: 10.0pt; font-family: 'Arial',sans-serif;">Ability to navigate complex problems in non-standardized situations</span></li><li><span style="font-size: 10.0pt; font-family: 'Arial',sans-serif;">Working knowledge of PeopleSoft preferred</span></li></ul><br/><br/>Compensation:<br/>The base pay range for this position is USD $80,000.00/Yr. - USD $90,000.00/Yr. Exact offers will be determined based on job-related knowledge, skills, experience, and location.

East West Bank Business Intelligence Interview Guide

Overview

East West Bank Business Intelligence Salary

East West Bank Business Intelligence Interview Process

East West Bank Business Intelligence Interview Questions

East West Bank Business Intelligence Jobs