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

Keybank Business Intelligence Interview Guide

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


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

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

Overview

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

Keybank 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 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

<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

Keybank Business Intelligence Interview Questions

<b>Location:</b><br>4910 Tiedeman Road - Brooklyn, Ohio 44144<br><br><b>The position can be remote (preference will be in Ohio) but will have to be in a state within KeyBank's footprint.</b><br><br>The Product Manager II is responsible for the ongoing lifecycle strategies that foster revenue generation, mitigation of credit loss, and an improved client experience across multiple consumer lending portfolios (credit cards, lines of credit, term loans, auto). The Product Manager II is involved in defining the overall business strategy, including account activation, usage, balance generation, fee income creation, and various tactics to reduce the inherent credit profile of consumer assets - all with improving portfolio(s) profitability. <br><br>The Product Manager II also may consult with senior business leaders and direct allocated resources to plan, develop, execute, and measure tactical projects to increase overall product portfolio performance.<br> <br><ul><li>Knowledge of the concepts, principles, and processes of design thinking; ability to utilize the knowledge in enhancing products and services, improving customer experiences, and finding operational efficiencies.</li><li>Analytical thought process and the ability to determine paths of action, make recommendations, and remediate issues.</li><li>Thorough and inquisitive, with an ability to independently manage multiple concurrent objectives, projects, groups, and activities.</li><li>Excellent influencing, consulting, and communication (both oral and written) skills, with the ability to successfully interact with and relate complex technical information to multiple audiences in plain business terms.</li></ul><br><b>Responsibilities</b><br><ul><li>Lead business initiatives, directing a project plan, and is responsible for economic outcomes</li><li>Responsible for revenue generation (finance charge, Non-interest income) campaigns and activities</li><li>Responsible for crafting various treatments to minimize the inherent credit risk to consumer portfolios</li><li>Recommends new product and/or portfolio value propositions, along with influencing and crafting product positioning, channel content and messaging</li><li>Responsible for monitoring and reporting out daily, weekly, and monthly Account Management performance trends and results</li><li>Responsible for understanding market conditions, the regulatory landscape and making recommendations for change as appropriate to internal and external conditions</li><li>Responsible for the compliance and legality of all product portfolio offerings and effectiveness of distribution and delivery</li><li>Responsible for scanning the competitive landscape, keeping a pulse on the competition with noted gaps, strengths, weaknesses and forecasting industry trends</li><li>Builds relationships with vendors and be involved in negotiating and influencing vendor contracts</li><li>Collaborates with Marketing Consultants to manage marketing campaigns, capabilities, and measures and reports out on results</li><li>Consult with business leaders and management to obtain buy-in and input on recommended innovations and product portfolio enhancements</li><li>Performs other duties as assigned; duties, responsibilities and/or activities may change or new ones may be assigned at any time with or without notice</li><li>Complies with all KeyBank policies and procedures, including without limitation, acting professionally at all times, conducting business ethically, avoiding conflicts of interest, and acting in the best interests of Key's clients and Key.</li></ul><br><b>Education Qualifications</b><br><ul><li>Bachelor's Degree in business or related field and/or equivalent work experience (required)</li></ul><br><b>Experience Qualifications</b><br><ul><li>5+ years experience in financial services or related industry (preferred)</li><li>5+ years experience in product management (preferred)</li></ul><br><b>Tactical Skills</b><br><ul><li>Demonstrated ability to drive projects from concept to rollout in cooperation with various business units and third party partners</li><li>Team player with a structured approach to achieve tight timelines on complex deliverables</li><li>Demonstrated ability to work on multiple projects at once and prioritize delivery based on key objectives.</li><li>Strategic thinker that aligns the benefits of the product with the needs of clients and shareholders while achieving profitability</li><li>Demonstrated analytical prowess and communication skills</li><li>Strong understanding of Retail Banking products, channels and client segment needs</li><li>Strong business management, presentation and PowerPoint skills</li><li>Proficient with: <ul><li>Query writing/coding including complex joins (Saas, GCP, etc)</li><li>Analytical programming languages</li><li>Data visualization</li><li>Microsoft Excel / PowerPoint</li></ul></li></ul><br><b>Personal Skills</b><br><ul><li>Critical Thinking</li><li>Problem Solving</li><li>Collaboration</li><li>Influence</li></ul><br><b>Practical Skills</b><br><ul><li>Business Acumen</li><li>Oral & Written Communication</li><li>Risk Management</li><li>Storytelling</li></ul><br><b>Core Competencies</b><br><ul><li>All KeyBank employees are expected to demonstrate Key's Values and sustain proficiency in identified Leadership Competencies.</li></ul><br>COMPENSATION AND BENEFITS<br><br>This position is eligible to earn a base salary in the range of $77,000 to $115,000 annually depending on location and job-related factors such as level of experience. Compensation for this role also includes eligibility for short-term incentive compensation and deferred incentive compensation subject to individual and company performance.<br><br>Please click here for a list of benefits for which this position is eligible.<br><br>Key has implemented a role-based Mobile by Design approach to our employee workspaces, dedicating space to those whose roles require specific workspaces, while providing flexible options for roles which are less dependent on assigned workspaces and can be performed effectively in a mobile environment. As a result, this role may be Mobile or Home-based, which means you may work primarily either at a home office or in a Key facility to perform your job duties.<br><br>Job Posting Expiration Date: 10/25/2024<br><br>KeyCorp is an Equal Opportunity and Affirmative Action Employer committed to building a diverse, equitable and inclusive culture. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, veteran status or other protected category.<br><br>Qualified individuals with disabilities or disabled veterans who are unable or limited in their ability to apply on this site may request reasonable accommodations by emailing HR_Compliance@keybank.com.<br><br>#LI-Remote

<b>Location:</b><br>4910 Tiedeman Road - Brooklyn, Ohio 44144<br><br><b>Job Brief:</b><br><br>Influences a cross-functional team in optimization of application capabilities & business processes. Provide Business Analysis and Project/Product support for the development, enhancement, quality assessment, and on-going support of the relevant lines of business (LOBs). The role will utilize industry trends to influence requirements for new application features and enhancements that are consistent with strategic priorities. Capture requirements for a highly complex system and/or multiple systems across multiple stakeholders; understands and applies the SDLC to the execution of deliverables. Advises on security, risk management, and IT process principles and escalate to appropriate team(s) as needed. Partners effectively with security and risk teams to ensure tech portfolio changes adhere to standards.<br><br><b>Job Responsibilities:</b><br><ul><li>Understand and document complex workflows.</li><li>Effectively communicate with their Business and Technology Peers.</li><li>Facilitate and drive meetings across various levels of technology and business.</li><li>Explain technology functionality/limitations to LOB during sessions ensuring the LOB is in step with what is possible.</li><li>Decompose high level business functional, and non-functional requirements into detailed technical requirements and update during all phase of application life cycle.</li><li>Document traceability between requirements testing and LOB sign off.</li><li>Understand how requirements will impact the applications that supported.</li><li>Able to understand, at a high level, network infrastructure and various integration points for supported applications.</li><li>Learn quickly and become a subject matter expert on assigned applications.</li><li>Understand how the requirements will be tested and review test cases.</li><li>Work in a fast-paced environment with continuously shifting priorities.</li><li>Focus on prioritized work without being distracted.</li><li>Adhere to deadlines.</li><li>Support off-hours testing and releases when required.</li><li>Drive assigned work to completion.</li><li>Identify and escalate risks.</li><li>Work collaboratively as part of a self-managed team.</li></ul><br><br><b>Required Qualifications:</b><br><ul><li>Bachelor's Degree with 5+ years in Business Analyst role or equivalent experience.</li><li>Excellent written and verbal communication skills. </li><li>Advance level knowledge with Microsoft Office Suite and Jira/Confluence/Kanban.</li><li>Knowledge of tools, methods, and techniques of requirement analysis.</li><li>Ability to elicit, analyze and record required business functionality and non-functionality requirements to ensure the success of a system or software development project.</li></ul><br><br><b>Preferred Qualifications:</b><br><ul><li>Experience working as part of an Agile/Scrum Team.</li><li>Familiarity with Key's Community Bank Technology Stack.</li><li>Experience working in heavily integrated environments.</li><li>Hands-on technical experience working with coding, scripting, database queries etc.</li></ul><br><br>Key has implemented a role-based Mobile by Design approach to our employee workspaces, dedicating space to those whose roles require specific workspaces, while providing flexible options for roles which are less dependent on assigned workspaces and can be performed effectively in a mobile environment. As a result, this role may be mobile or home based, which means you may work either at a home office or in a Key facility to perform your job duties<br><br>COMPENSATION AND BENEFITS<br><br>This position is eligible to earn a base salary in the range of $90,000.00 to $120,000.00 annually depending on job-related factors such as level of experience. Compensation for this role also includes eligibility for short-term incentive compensation and deferred incentive compensation subject to individual and company performance.<br><br>Please click here for a list of benefits for which this position is eligible.<br><br>Job Posting Expiration Date: 10/25/2024<br><br>KeyCorp is an Equal Opportunity and Affirmative Action Employer committed to building a diverse, equitable and inclusive culture. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, veteran status or other protected category.<br><br>Qualified individuals with disabilities or disabled veterans who are unable or limited in their ability to apply on this site may request reasonable accommodations by emailing HR_Compliance@keybank.com.

<b>Location:</b><br>4910 Tiedeman Road - Brooklyn, Ohio 44144<br><br><b>JOB TITLE: Commercial Credit Product Manager<br><br>Location: </b>Cleveland Tiedeman Campus or Remote<br><br><b>ABOUT THE JOB (JOB BRIEF)</b><br><br>The Commercial Credit Product Manager will be responsible for the end-to-end client and employee experience with a focus on the digital platforms that support Key's Commercial Clients. In this role, they will partner with stakeholders from multiple lines of business to ensure we are meeting our clients and business partner's rapidly evolving needs. Some of these items include, but are not limited to, developing a credit product roadmap and backlog in partnership with business development, portfolio management, loan operations, technology, and other partners across the bank. This role will also be critical in supporting the current and future commercial loan conversions. The Credit Product Manager will be responsible for monitoring operational performance and supporting cross functional partners to resolve challenges and enhance the end-to-end risk/control environment.<br><br><b>ESSENTIAL JOB FUNCTIONS</b><br><br><ul><li>Work with technology and operations teams to enhance platform capabilities and implement scalable procedures</li><li>Work in a matrixed organization with colleagues across various reporting structureslead, influence and align teams without direct managerial responsibility</li><li>Effectively work with internal teams and external partners to drive enhanced capabilities, product roadmap alignment, and project execution</li><li>Document requirements across organizations and drive successful outcomes in accordance with agreed upon project plans</li><li>Ability to understand, develop, and execute business performance analysis, tracking initiatives and reporting to leadership</li><li>Maintain awareness of evolving market trends to bring a forward-looking perspective in modifying our client and employee experience</li></ul><br><br><b>REQUIRED QUALIFICATIONS</b><br><ul><li>Bachelor's degree or higher required or equivalent experience</li><li>5+ years of financial services experience and/or product management</li></ul><br><b>PREFERRED QUALIFICATIONS</b><br><br><ul><li>Experience with commercial credit products or related credit responsibility (Ie. loan servicing, underwriting, etc.)</li><li>Deep knowledge of the end-to-end client and employee credit lifecycle</li><li>Problem solving and critical thinking, with the ability to identify root cause and proper solution. </li><li>Ability to independently manage multiple concurrent objectives, projects, groups, or activities - including in an agile framework</li><li>Data driven mentality</li><li>Excellent influencing, consulting and communication (both oral and written) skills, with the ability to successfully interact with and relate complex technical information to multiples audiences in business terms.</li><li>Knowledge, insight, and understanding of business concepts, tools, and processes that are needed for making sound decisions in the context of the company's business; ability to apply this knowledge appropriately to diverse situations.</li><li>Knowledge of the concepts, principles, and processes of design thinking; ability to utilize the knowledge in designing new products and services and even improving organizational operation.</li><li>Strong research and analytical skills with an ability to innovate (ie. Think outside of the box) to come up with optimal solutions.</li><li>Ability to communicate with all levels of management.</li><li>Acute attention to detail with an ability to identify or discover trends or themes.</li><li>Ability to clearly articulate methodology for issue resolution of complex problems.</li><li>Previous success in implementing simple and efficient product development or project management programs and processes.</li><li>Proven ability to champion change, influence others, and foster teamwork.</li><li>Proficiency with Microsoft Office, data query tools and management reporting techniques.</li></ul><br><b>Location: </b>Cleveland, OH or Remote<br><br>Cleveland Tiedeman Campus (4910 Tiedeman Road, Brooklyn, OH) Preferred <br><br>Key has implemented a role-based Mobile by Design approach to our employee workspaces, dedicating space to those whose roles require specific workspaces, while providing flexible options for roles which are less dependent on assigned workspaces and can be performed effectively in a mobile environment. As a result, this role may be mobile or home based, which means you may work either at a home office or in a Key facility to perform your job duties.<br><br>COMPENSATION AND BENEFITS<br><br>This position is eligible to earn a base salary in the range of $95,000 to $105,000.00 annually depending on location and job-related factors such as level of experience. Compensation for this role also includes eligibility for short-term incentive compensation and deferred incentive compensation subject to individual and company performance.<br><br>Please click here for a list of benefits for which this position is eligible.<br><br>Key has implemented a role-based Mobile by Design approach to our employee workspaces, dedicating space to those whose roles require specific workspaces, while providing flexible options for roles which are less dependent on assigned workspaces and can be performed effectively in a mobile environment. As a result, this role may be Mobile or Home-based, which means you may work primarily either at a home office or in a Key facility to perform your job duties.<br><br>Job Posting Expiration Date: 10/10/2024<br><br>KeyCorp is an Equal Opportunity and Affirmative Action Employer committed to building a diverse, equitable and inclusive culture. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, veteran status or other protected category.<br><br>Qualified individuals with disabilities or disabled veterans who are unable or limited in their ability to apply on this site may request reasonable accommodations by emailing HR_Compliance@keybank.com.<br><br>#LI-Remote

<b>Location:</b><br>4910 Tiedeman Road - Brooklyn, Ohio 44144<br><br>Responsibilities<br><ul><li>Design and develop the organization's overall data architecture strategy to support business objectives and long-term goals.</li><li>Collaborate with business stakeholders and data analysts to understand data requirements and translate them into technical specifications.</li><li>Evaluate and select appropriate data management technologies and tools to support data architecture goals, such as data warehouses, data lakes, and ETL processes.</li><li>Communicate effectively with technical and non-technical stakeholders to present data architecture designs, proposals, and recommendations.</li><li>Help to define and implement data governance policies and procedures to ensure data quality, security, and compliance with regulatory requirements.</li><li>Provide guidance and support to development teams during the implementation of data-related projects, including database design, data migration, and performance optimization</li><li>Stay current with emerging trends and technologies in data management and recommend innovative solutions to enhance the organization's data architecture capabilities.</li><li>Be an influencer with other resources in KTOS including Data Architects, Developers, and Enterprise Testers to help drive design, develop, and test based on the requirements given.</li><li>Be an influencer with the Line of Business including Business Analysts and Business Subject Matter Experts (SMEs) to make sure business requirements are clear, concise and meet the need of the business.</li><li>Be and influencer of programming concepts including program design, performance and execution and utilize this information as part of the mapping design process. Give into efficient programming design. </li></ul><br><br>Criteria<br><ul><li>Industry experience with demonstrated success in Cloud implementation </li><li>Knowledge depth spans data ingestion to consumption</li><li>Ability to communicate at senior levels - simplify complex concepts</li><li>Demonstrated execution vs just theory</li></ul><br><br>COMPENSATION AND BENEFITS<br><br>This position is eligible to earn a base salary in the range of $92,000 to $172,000 annually depending on location and job-related factors such as level of experience. Compensation for this role also includes eligibility for short-term incentive compensation and deferred incentive compensation subject to individual and company performance. <br><br>Please click here for a list of benefits for which this position is eligible.<br><br>Job Posting Expiration Date: 10/08/2024<br><br>KeyCorp is an Equal Opportunity and Affirmative Action Employer committed to building a diverse, equitable and inclusive culture. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, veteran status or other protected category.<br><br>Qualified individuals with disabilities or disabled veterans who are unable or limited in their ability to apply on this site may request reasonable accommodations by emailing HR_Compliance@keybank.com.

Keybank Business Intelligence Interview Guide

Overview

Keybank Business Intelligence Salary

Keybank Business Intelligence Interview Process

Keybank Business Intelligence Interview Questions

Keybank Business Intelligence Jobs