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

Becu Business Intelligence Interview Guide

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


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

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

Overview

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

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

<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

Becu Business Intelligence Interview Questions

<p><p>As the nation's largest community credit union, we begin every day focused on delivering superior financial products and services for our 1.3 million members and more than $30 billion in managed assets. Our work has an economic impact as we support our members' financial goals. We are unapologetic about being devoted to our members and the communities we serve. Our business is guided by our people helping people philosophy  which includes our team members.</p><br><p>BECU has been in business for more than 85 years, driven by unwavering core values and a dedication to improving the communities we serve. While we have a rich history, the future of our company, accelerated by business and technology transformation, is even brighter. There's never been a better time to work for BECU.</p><br><p>To learn more visit becu.org/careers.</p><br><p>**PAY RANGE**</p><br><p>The Target Pay Range for this position is $100,900.00-$123,200.00 annually. The full Pay Range is $78,400.00 - $145,800.00 annually. At BECU, compensation decisions are determined using factors such as relevant job-related skills, experience, and education or training. Should an offer for employment be made, we will consider individual qualifications.  In addition to your salary, compensation incentives are available for the hired applicant. Incentives are performance based and targets vary by role.</p><br><p>**BENEFITS**</p><br><p>Employees and their eligible family members have access to a wide array of employee benefits, such as medical, dental, vision and life insurance coverage.  Employees have access to disability and AD&D insurance.  We also offer health care and dependent care flexible spending accounts, as well as health savings accounts, to eligible employees.  Employees are able to enroll in our companys 401k plan and employer-funded retirement plan.  Newly hired employees accrue 6.16 hours of paid time off (PTO) on a per pay period basis based on hours worked (up to a maximum of 160 PTO hours per year) and receive ten paid holidays throughout the calendar year. Additional details regarding BECU Benefits can be found  here .</p><br><p>**IMPACT YOU'LL MAKE:**</p><br><p>As the Sr Credit Risk Analyst, Unsecured at BECU, you'll play a vital role in analyzing and monitoring the credit risk across our portfolios. Your insights will help shape our risk management strategies by ensuring adherence to governance standards and lending policies. You'll be instrumental in developing and maintaining reporting and analytic frameworks that provide clear insights into portfolio health and performance. By collaborating with various stakeholders, you'll support the discovery and measurement of risks, identify potential threats and opportunities, and influence decision-making processes. Your expertise will not only enhance our credit risk management practices but also contribute to the overall financial well-being of our members.</p><br><p>**WHAT YOU'LL DO:**</p><br><p>+  **Data Analysis & Discovery:**  Conduct data discovery and aggregation across multiple large databases, identifying trends and developing actionable insights.</p><br><p>+  **Reporting & Monitoring:**  Develop and maintain recurring and ad-hoc reporting suites for monitoring the unsecured portfolios (card, personal loan, line of credit), including portfolio risk ratings and health assessments.</p><br><p>+  **Risk Investigation:**  Investigate and validate risk management processes through data review and engagement with business unit personnel.</p><br><p>+  **Credit Risk Analysis:**  Perform in-depth analysis of loan portfolios or subpopulations to identify potential risks and opportunities, including evaluating origination decision logic and credit profiles.</p><br><p>+  **Statistical Evaluation:**  Utilize statistical modeling techniques to predict outcomes of credit programs and strategies.</p><br><p>+  **Strategic Collaboration:**  Partner with Senior Leadership to develop and support credit risk initiatives, adjusting portfolio management strategies as needed.</p><br><p>+  **Leadership & Mentorship:**  Mentor junior staff, fostering their development and performance.</p><br><p>+  **Regulatory Compliance:**  Ensure compliance with federal and state regulations related to credit risk management.</p><br><p>+  **Documentation & Reporting:**  Maintain and update written procedures and management information reporting, ensuring operational efficiency.</p><br><p>This isnt just about ticking off tasks on a list. It's about making a significant, positive change in BECUs journey, where your contributions are valued, and your growth is continually fostered.</p><br><p>**WHAT YOULL GAIN:**</p><br><p>+ Deepen your knowledge in credit risk analytics and portfolio management.</p><br><p>+ Mentor junior analysts and influence cross-functional teams.</p><br><p>+ Contribute to the development and execution of risk management strategies.</p><br><p>+ Access to continuous learning opportunities in data analysis and risk management.</p><br><p>**QUALIFICATIONS:**</p><br><p>**Minimum Qualifications:**</p><br><p>+ Bachelor's degree in a quantitative or business field, or equivalent experience.</p><br><p>+ Minimum 5 years of related functional experience in credit risk analytics, with a preference for experience in the financial services industry.</p><br><p>**Desired Qualifications:**</p><br><p>+ Advanced degree preferred.</p><br><p>+ Previous experience in managing projects is preferred.</p><br><p>+ Proficient in PC skills, including Microsoft Office (Excel, Word), with the ability to quickly learn new software.</p><br><p>+ Advanced experience with quantitative software and database querying tools (e.g., SAS, SQL, Python) and presentation development software (e.g., Tableau, PowerBI, PowerPoint).</p><br><p>+ Demonstrated experience in analyzing portfolio performance and articulating results from a risk management perspective. Ability to collect data, establish facts, and draw valid conclusions.</p><br><p>+ Experience in building cohesive cross-functional teams and facilitating collaborative decision-making.</p><br><p>**JOIN THE JOURNEY**</p><br><p>Ready to make an indelible impact? Eager to be a part of a collaborative and innovative team where your ideas and contributions dont just fill a role, but fuel the growth and success of BECU? This is more than a job  its a chance to elevate your career, skills, and future, all while contributing to the robust technological landscape of BECU.</p><br><p>Embrace the opportunity to grow with us. Apply now, bring your expertise to the table, and lets achieve excellence together at BECU. Your journey of influence, innovation, and impactful contribution starts now. #BECU #YourGrowth #BECUJourney</p><br><p>**EEO Statement:**</p><br><p>BECU is an equal opportunity employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, national origin, veteran status, disability, sexual orientation, gender identity, or any other protected status.</p><br><p>**Job Alerts:**  If you would like to be kept informed of new potential opportunities, click here (https://becu.wd1.myworkdayjobs.com/en-US/External/jobAlerts) . You will be asked to create an account if you do not already have one.</p><br><p>From our very beginning, BECU has been about people helping people. As a financial services cooperative, our purpose has and always will be the same: we work together to best serve our members and improve the financial well-being of our community. More than 80 years and one million members later, we're still rooted in our values, practices and mission - and even more passionate about our future.</p><br><p>As one of the nation's leading credit unions, we're not driven by profit. We're owned by our members and their interests are at the core of everything we do. Now we're growing faster than ever before--but we'll never forget our roots. To continue doing right by our members, we believe we must first do right by our people. Here, you'll receive the resources and support you need to learn, grow and build a meaningful career. Because we know it's our people who make us special. </p><br></p>

Becu Business Intelligence Interview Guide

Overview

Becu Business Intelligence Salary

Becu Business Intelligence Interview Process

Becu Business Intelligence Interview Questions

Becu Business Intelligence Jobs