Old National Bank has been serving clients and communities since 1834. With $50 billion in total assets, we are a regional powerhouse deeply rooted in the communities we serve. As a trusted partner, we thrive on helping our clients achieve their goals and dreams and are committed to social responsibility, investing in our communities through volunteering and charitable giving.

For the Business Analyst position, we are looking for highly skilled individuals to lead the discovery and implementation of multiple projects, collaborating with business lines, internal resources, and vendors to develop business and technology solutions. This role requires a strong ability to communicate business requirements, manage project timelines, and foster relationships with stakeholders. The position is available in several locations, including Chicago and Evansville.

In this guide, we’ll walk you through the interview process, some commonly asked Old National Bank Business Analyst interview questions, and provide some valuable tips. Let’s get started!

Submitting Your Application

The first step in joining Old National Bank as a Business Analyst is to submit a compelling application that reflects your technical skills and interest in the banking sector. Whether you were contacted by an Old National Bank recruiter or have taken the initiative yourself, carefully review the job description and tailor your CV according to the prerequisites.

Tailoring your CV may include identifying specific keywords that the hiring manager might use to filter resumes and crafting a targeted cover letter. Furthermore, don’t forget to highlight relevant skills and mention your work experiences.

Recruiter/Hiring Manager Call Screening

If your CV happens to be among the shortlisted few, a recruiter from the Old National Bank Talent Acquisition Team will make contact and verify key details like your experiences and skill level. Behavioral questions may also be a part of the screening process.

In some cases, the Old National Bank Business Analyst hiring manager stays present during the screening round to answer your queries about the role and the company itself. They may also indulge in surface-level technical and behavioral discussions.

The whole recruiter call should take about 30 minutes.

Technical Virtual Interview

Successfully navigating the recruiter round will present you with an invitation for the technical screening round. Technical screening for the Old National Bank Business Analyst role usually is conducted through virtual means, including video conference and screen sharing. Questions in this 1-hour long interview stage may revolve around Old National Bank’s data systems, ETL pipelines, and SQL queries.

In the case of business analyst roles, take-home assignments regarding product metrics, analytics, and data visualization are incorporated. Apart from these, your proficiency against hypothesis testing, probability distributions, and machine learning fundamentals may also be assessed during the round.

Depending on the seniority of the position, case studies, and similar real-scenario problems may also be assigned.

Onsite Interview Rounds

Followed by a second recruiter call outlining the next stage, you’ll be invited to attend the onsite interview loop. Multiple interview rounds, varying with the role, will be conducted during your day at the Old National Bank office. Your technical prowess, including programming and ML modeling capabilities, will be evaluated against the finalized candidates throughout these interviews.

If you were assigned take-home exercises, a presentation round may also await you during the onsite interview for the Business Analyst role at Old National Bank.

Quick Tips For Old National Bank Business Analyst Interviews

• Domain Expertise: Old National Bank looks for candidates with strong knowledge in commercial lending, small business banking, and financial services. Brush up on your industry-specific knowledge to stand out.
• Technical Skills: Proficiency with data flow diagrams, storyboards, and familiar banking systems like Abrigo or Salesforce are highly valued. Ensure you demonstrate these capabilities clearly.
• Behavioral Insights: Old National Bank places a high emphasis on their core values. Be prepared to discuss how your personal values align with their culture and how you've embodied these values in past work experiences.

Typically, interviews at Old National Bank vary by role and team, but commonly Business Analyst interviews follow a fairly standardized process across these question topics.

• Write a function to merge two sorted lists into one sorted list. Given two sorted lists, write a function to merge them into one sorted list. Bonus: What's the time complexity?

• Write a function to find the maximum number in a list of integers. Given a list of integers, write a function that returns the maximum number in the list. If the list is empty, return None.

• Write a query to get the top 3 highest employee salaries by department. Given the employees and departments table, write a query to get the top 3 highest employee salaries by department. The output should include the full name of the employee in one column, the department name, and the salary. The output should be sorted by department name in ascending order and salary in descending order.

• Write a function to combine sorted integer lists into one sorted list. Given a list of sorted integer lists, write a function sort_lists to create a combined list while maintaining sorted order without importing any libraries or using the 'sort' or 'sorted' functions in Python.

• Write a function to swap nodes in a singly linked list. Given the head of a singly linked list represented as a ListNode, and two zero-indexed positions x and y, write a function swap_node which swaps the positions of nodes x and y and returns the new head. Note that you cannot simply swap the values of these nodes; you must swap these two using pointer manipulation.

• How would you investigate a decrease in credit card payment amounts per transaction? You work for a financial company and notice that the credit card payment amount per transaction has decreased. How would you investigate the cause of this change?

• How would you build a strategy to find the best small businesses to partner with? You are a credit card company looking to partner with more merchants. You have 100K small businesses to reach out to but can only contact 1000. How would you strategize to identify the best businesses to approach?

• What features would you include in a model to predict a no-show for pizza orders? Imagine you run a pizza franchise and face a problem with many no-shows after customers place their orders. What features would you include in a model to predict a no-show?

• How does random forest generate the forest and why use it over logistic regression? Explain how random forest generates the forest. Additionally, why would we use random forest over other algorithms such as logistic regression?

• How would you build a fraud detection model with a text messaging service for a bank? You work at a bank that wants to build a model to detect fraud on the platform. The bank also wants to implement a text messaging service that will text customers when the model detects a fraudulent transaction, allowing the customer to approve or deny the transaction with a text response. How would you build this model?

• What is the relationship between PCA and K-means clustering? Explain the relationship between Principal Component Analysis (PCA) and K-means clustering.

Old National Bank has been serving clients and communities since 1834, standing as a regional powerhouse deeply rooted in the communities it serves. With a steadfast commitment to social responsibility and investing in the community through volunteering and charitable giving, Old National Bank places great importance on both client success and community well-being. The Bank values its team members as its greatest asset, consistently investing in their growth and development through various engagement and inclusion initiatives.

As a Business Analyst, you’ll lead pivotal projects, working closely with business lines, internal resources, and vendors to implement high-impact business and technology solutions. Your role will encompass creating data flow diagrams, storyboards for new products, and detailed analysis to guide application development and ensure business goals are met. With several office locations, including Chicago, Tinley Park, and Evansville, Old National Bank offers a collaborative and inclusive work environment, competitive compensation, and comprehensive benefits from day one.

If you want more insights about the company, check out our main Old National Bank Interview Guide, where we have covered many interview questions that could be asked. For more detailed preparation, visit Interview Query where we provide the knowledge, confidence, and strategic guidance to excel in your interviews.

Good luck with your interview!