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

Scotiabank Business Intelligence Interview Guide

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


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

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

Overview

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

Scotiabank 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

Scotiabank Business Intelligence Interview Questions

<h3>Title: Senior Product Manager, Commercialization - US Business Deposit Products, Global Transaction Banking</h3><p><b>Requisition ID:</b> 202026</p><p><b>Salary Range:</b> 110,700.00-211,800.00</p><p><em>Please note that the Salary Range shown is a guideline only. Salary offered may vary based on factors, including, but not limited to, the successful candidate’s relevant knowledge, skills, and experience.</em></p><p>Join a purpose driven winning team, committed to results, in an inclusive and high-performing culture.</p><p><b>Purpose:</b></p><p>Contributes to the overall success of Global Transaction Banking (GTB) in North America by ensuring specific individual goals, plans, initiatives are executed and delivered in support of the team’s business strategies and objectives. Ensures all activities conducted are in compliance with governing regulations, internal policies and procedures.</p><p>The Sr. Product Manager, Commercialization - US Business Deposit Products, is responsible for the P&L growth of the portfolio and driving growth across multiple business KPIs (including but not limited to: deposit volumes, transactions, product penetration, customer primacy, NIR, NII, profitability etc.). This role involves end-to-end product commercialization management, such as: evaluating commercial potential, supporting the sales partners and other stakeholder teams in developing and executing on the end-to-end commercialization plans.</p><p>This individual must have a well-rounded business skill set to plan and direct commercialization initiatives across different deposit product categories over the next several years and maintain a keen insight to the USMCA corridor and the global transaction banking market, at large.</p><p><b>Accountabilities:</b></p><ul><li>Leads and drives a customer-first culture to be able to bring in new clients to the Bank, deepen existing client relationships and improve client experience.</li><li>Conceptualizes, develops, leads and implements the end-to-end commercialization strategies for US Business Deposit Products, including but not limited to the following:<ul><li>Identify short/medium/long-term opportunities and define strategic roadmaps.</li><li>Performance forecasting.</li><li>Establishing, executing and supporting (where needed) on tactical plans.</li><li>Identifying opportunities and driving initiatives to establish, maintain and/or enhance our competitive position in the US and with the global market.</li></ul></li><li>Support the Director – US Business Deposit Products, the Product Owner(s), Sales teams, partner teams and the leadership team by –<ul><li>Leading (and supporting, where required) all commercialization initiatives targeted towards new and existing clients - for all in-flight and future initiatives.</li><li>Delivering on assigned and/or ad hoc mandates, key strategic initiatives and priorities.</li><li>Contributing to the overall development of the strategic direction of the business.</li></ul></li><li>Responsible for managing the commercialization of the new US-domiciled deposit products and related solutions by:<ul><li>Supporting development, planning and implementation of forward-looking strategic commercialization plans, business line plans, and product category specific business plans to support sales and drive business growth.</li><li>Proactively identifying and executing on strategic and tactical opportunities to increase market share, customer primacy and customer wallet share.</li><li>Bringing in feedback and insights from the market/industry, front-end teams and customers to continuously improve the commercial viability of the US Business Deposit Products.</li><li>Identifying product education and training needs, across the enterprise, to accelerate sales growth.</li><li>Educating/Training sales, internal stakeholders and customers on emerging trends and how solutions are applied to maximize benefit.</li><li>Analyzing the portfolio with a focus on long-term growth, competitive positioning and commercialization opportunities.</li></ul></li><li>Accountable for P&L growth and growth across key KPIs – such as: deposit volumes, transactions, product penetration, customer primacy, NIR, NII, profitability etc.</li><li>Responsible for the US business customer portfolio, P&L, forecasting and driving growth across business KPIs (including but not limited to: business deposit volumes, transactions, product penetration, etc.).</li><li>Responsible for monitoring and tracking KPI performance for business line and GTB-level reviews.</li><li>Relationship Management, Collaboration and Communication<ul><li>Managing partner, business line, sales etc. relationships for the portfolio.</li><li>Participate in RFIs/RFPs and support stakeholders for one-off programs and initiatives, as required.</li><li>Collaborating with the Product Owners, Product Managers, Cross-team partners, Sales, Sales Effectiveness, Pricing and other support functions to articulate the customer impacts and business/stakeholder value.</li><li>Supporting senior leadership team and our partners as a point person on all commercialization initiatives/plans for the US Deposit Products.</li><li>Ensuring all commercialization initiatives are performing as expected and resolving issues that arise in a timely manner with updates to partners and escalations to management as required.</li><li>Effectively communicating commercialization plans, proposals, updates, progress updates, gaps, risks etc. to the sales teams and all stakeholder teams.</li><li>Overseeing the commercialization-related product marketing and communications for customers and staff.</li><li>Providing subject matter expertise and thought leadership to partners as required.</li></ul></li><li>Builds a high-performance environment and implements a people strategy that attracts, retains, develops and motivates their team by fostering an inclusive work environment and using a coaching mindset and behaviors; communicating vision/values/business strategy; and, managing succession and development planning for the team.</li><li>Creates an environment in which his/her team pursues effective and efficient operations of his/her respective areas, while ensuring the adequacy, adherence to and effectiveness of day-to-day business controls to meet obligations with respect to operational risk, regulatory compliance risk, AML/ATF risk and conduct risk, including but not limited to responsibilities under the Operational Risk Management Framework, Regulatory Compliance Risk Management Framework, AML/ATF Global Handbook and the Guidelines for Business Conduct.</li></ul><p><b>What You'll Bring:</b></p><ul><li>7+ years of experience with managing Commercialization initiatives or 7+ years of Sales experience for global transaction banking products, specifically business banking products.</li><li>Knowledge of business deposit products, industry trends, sales practices, policies and procedures is important.</li><li>Product management (from a business standpoint, and not technology) experience is an asset.</li><li>A positive attitude combined with confidence to drive team priorities.</li><li>Knowledge of the Bank's application systems and their relationships within the Bank is an asset.</li><li>Self-starter possessing confidence and initiative; able to cope with changing and evolving priorities while identifying new opportunities.</li><li>Excellent communication, interpersonal, and strategic negotiating skills.</li><li>University Degree in business or economics (MBA an asset).</li></ul><p><b>Working Conditions:</b></p><ul><li>Located at our New York office.</li><li>Hybrid work environment with the expectation to be in office 3-4 times a week or as needed.</li><li>Work in a standard office-based environment; non-standard hours are a common occurrence.</li><li>Limited travel domestically and to Canada.</li></ul><p>Interested? At Scotiabank, every employee is empowered to reach their fullest potential, respected for who they are and embraced for their differences. That is why we work to grow and diversify talent and engage employees in a performance-oriented culture.</p><p>What's in it for you? Scotiabank wants you to be able to bring your best self to work – and life, every day. With a focus on holistic well-being, our many flexible benefit programs are designed to help support your unique family, financial, physical, mental, and social health needs.</p><p>Location(s): United States : New York : New York City</p><p>Scotiabank is a leading bank in the Americas. Guided by our purpose: "for every future", we help our customers, their families and their communities achieve success through a broad range of advice, products and services, including personal and commercial banking, wealth management and private banking, corporate and investment banking, and capital markets.</p><p>At Scotiabank, we value the unique skills and experiences each individual brings to the Bank, and are committed to creating and maintaining an inclusive and accessible environment for everyone. If you require accommodation (including, but not limited to, an accessible interview site, alternate format documents, ASL Interpreter, or Assistive Technology) during the recruitment and selection process, please let our Recruitment team know. Candidates must apply directly online to be considered for this role. We thank all applicants for their interest in a career at Scotiabank; however, only those candidates who are selected for an interview will be contacted.</p>
#J-18808-Ljbffr

Scotiabank Business Intelligence Interview Guide

Overview

Scotiabank Business Intelligence Salary

Scotiabank Business Intelligence Interview Process

Scotiabank Business Intelligence Interview Questions

Scotiabank Business Intelligence Jobs