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

Lending Club Business Intelligence Interview Guide

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


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

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

Overview

Lending Club 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.

Lending Club 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>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

<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

Lending Club Business Intelligence Interview Questions

<p>Personal Loan Analytics Manager</p><p>Apply locations: San Francisco, CA</p><p>Time type: Full time</p><p>Posted on: Posted 9 Days Ago</p><p>Job requisition id: R0006792</p><h3><u>Current Employees of LendingClub: Please apply via your internal Workday Account</u></h3><p>LendingClub Corporation (NYSE: LC) is the parent company of LendingClub Bank, National Association, Member FDIC. We are the leading digital marketplace bank in the U.S., having helped our nearly 5 million members secure over $90 billion in loans to refinance high-cost debt and achieve their financial goals. Members today have mobile-first access to a growing range of products and services designed to work seamlessly together to deliver value in new ways. Everyone deserves a better financial future, and our team is committed to making that a reality. Join the Club!</p><h3>About the Role</h3><p>As the Personal Loan Analytics Manager, you will be instrumental in building new Personal Loan products and leading cross-functional efforts across Marketing, Product, Engineering, Risk and Finance to drive growth for our personal loan products. This role requires a deep understanding of the digital lending or banking space, a solid grasp of various business functions (Marketing, Product, Engineering, Analytics, and Finance), and a strong ability to develop and implement data-driven initiatives from start to finish. Your analytical prowess, problem-solving skills, product sense, and ability to work effectively cross-functionally will be key to your success.</p><h3>What You'll Do</h3><ul><li><b>Develop Growth Strategies:</b> Create new offerings or optimize existing product sets to drive growth through a data-driven and customer-centric approach.</li><li><b>Lead End-to-End Execution:</b> Manage the full lifecycle of strategic initiatives, including building business cases, securing stakeholder buy-ins, defining and documenting business requirements, and crafting go-to-market plans.</li><li><b>Optimize Post-Launch:</b> Analyze and optimize new strategies post-launch to ensure KPI metrics are met and business benefits are realized.</li><li><b>Quarterly Planning:</b> Develop a roadmap of key initiatives for quarterly planning to drive continuous growth.</li><li><b>Stakeholder Collaboration:</b> Collaborate with and drive alignment among various stakeholders across the organization.</li><li><b>Champion Data-Driven Decisions:</b> Promote a culture of data-driven decision-making, analytics, and experimentation throughout the organization.</li><li><b>Manage Offshore Contractors:</b> Lead and coordinate with offshore contractors for analytical support and to ensure seamless execution.</li></ul><h3>About You</h3><ul><li>You have 4+ years of experience driving strategy and growth in Financial Services or the digital product space.</li><li>Bachelor's or Master’s degree in business or quantitative fields (e.g., Economics, Engineering); equivalent work experience.</li><li><b>Problem-Solving:</b> You possess strong problem-solving skills and a proactive mindset.</li><li><b>Analytical Skills:</b> You have strong analytical and data-driven skills to identify opportunities and develop strategies through data insights.</li><li><b>Stakeholder Management:</b> You excel at coordinating with a diverse group of stakeholders, both internal and external, to ensure successful strategic initiatives.</li><li><b>Communication Skills:</b> You have excellent written and verbal communication skills, with the ability to clearly articulate project scope in both documentation and presentation formats.</li><li><b>Technical Skills:</b> Proficiency in SQL and Python is a plus.</li><li><b>Industry Experience:</b> Previous experience in the Financial/FinTech industry is a plus.</li></ul><p><b>Work Location:</b> San Francisco</p><p>We are currently working a hybrid schedule and our teams are in-office Tuesdays, Wednesdays, and Thursdays.</p><p><b>Time Zone Requirements:</b> Primarily PT</p><p><b>Travel Requirements:</b> If you need to travel for work, LendingClub will cover your travel-related expenses.</p><p><b>Compensation:</b> The target base salary range for this position is $135,000-$159,000. The position is also eligible to receive a bonus (which is based on company performance, employee performance, and eligible earnings), equity, and benefits. Our salary ranges, other compensation, and benefits offered are determined by role, experience level, and location.</p><p>We’re creating new financial services solutions for our members based on fairness, simplicity, and heart, and we treat our employees the same way. We offer a competitive benefits package that includes medical, dental and vision plans for employees and their families, 401(k) match, health and wellness programs, flexible time off policies for salaried employees, up to 16 weeks paid parental leave and more.</p><p>#LI-Hybrid</p><p>#LI-AW1</p><p>LendingClub is an equal opportunity employer and dedicated to diversity, equity, and inclusion in the workplace. We do not discriminate on the basis of race, religion, color, national origin, sex (including pregnancy, childbirth, reproductive health decisions, or related medical conditions), gender, gender identity, gender expression, sexual orientation, age, marital status, veteran status, disability status, political views or activity, or other applicable legally protected characteristics. We believe that a variety of perspectives will make our teams and business stronger as we work together to transform the traditional banking system.</p><p>We are committed to providing reasonable accommodations for qualified individuals with disabilities in our job application process. If you need assistance or an accommodation due to a disability, please contact us at interviewaccommodations@lendingclub.com.</p>
#J-18808-Ljbffr

Personal Loan Analytics Manager
Apply locations: San Francisco, CA
Time type: Full time
Posted on: Posted 9 Days Ago
Job requisition id: R0006792
Current Employees of LendingClub: Please apply via your internal Workday Account   LendingClub Corporation (NYSE: LC) is the parent company of LendingClub Bank, National Association, Member FDIC. We are the leading digital marketplace bank in the U.S., having helped our nearly 5 million members secure over $90 billion in loans to refinance high-cost debt and achieve their financial goals. Members today have mobile-first access to a growing range of products and services designed to work seamlessly together to deliver value in new ways. Everyone deserves a better financial future, and our team is committed to making that a reality. Join the Club!
About the Role  As the Personal Loan Analytics Manager, you will be instrumental in building new Personal Loan products and leading cross-functional efforts across Marketing, Product, Engineering, Risk and Finance to drive growth for our personal loan products. This role requires a deep understanding of the digital lending or banking space, a solid grasp of various business functions (Marketing, Product, Engineering, Analytics, and Finance), and a strong ability to develop and implement data-driven initiatives from start to finish. Your analytical prowess, problem-solving skills, product sense, and ability to work effectively cross-functionally will be key to your success.
What You'll Do    Develop Growth Strategies:  Create new offerings or optimize existing product sets to drive growth through a data-driven and customer-centric approach.
Lead End-to-End Execution:  Manage the full lifecycle of strategic initiatives, including building business cases, securing stakeholder buy-ins, defining and documenting business requirements, and crafting go-to-market plans.
Optimize Post-Launch:  Analyze and optimize new strategies post-launch to ensure KPI metrics are met and business benefits are realized.
Quarterly Planning:  Develop a roadmap of key initiatives for quarterly planning to drive continuous growth.
Stakeholder Collaboration:  Collaborate with and drive alignment among various stakeholders across the organization.
Champion Data-Driven Decisions:  Promote a culture of data-driven decision-making, analytics, and experimentation throughout the organization.
Manage Offshore Contractors:  Lead and coordinate with offshore contractors for analytical support and to ensure seamless execution.
About You   You have 4+ years of experience driving strategy and growth in Financial Services or the digital product space.
Bachelor's or Master’s degree in business or quantitative fields (e.g., Economics, Engineering); equivalent work experience.
Problem-Solving:  You possess strong problem-solving skills and a proactive mindset.
Analytical Skills:  You have strong analytical and data-driven skills to identify opportunities and develop strategies through data insights.
Stakeholder Management:  You excel at coordinating with a diverse group of stakeholders, both internal and external, to ensure successful strategic initiatives.
Communication Skills:  You have excellent written and verbal communication skills, with the ability to clearly articulate project scope in both documentation and presentation formats.
Technical Skills:  Proficiency in SQL and Python is a plus.
Industry Experience:  Previous experience in the Financial/FinTech industry is a plus.
Work Location:  San Francisco
We are currently working a hybrid schedule and our teams are in-office Tuesdays, Wednesdays, and Thursdays.
Time Zone Requirements:  Primarily PT
Travel Requirements:  If you need to travel for work, LendingClub will cover your travel-related expenses.
Compensation:  The target base salary range for this position is $135,000-$159,000. The position is also eligible to receive a bonus (which is based on company performance, employee performance, and eligible earnings), equity, and benefits. Our salary ranges, other compensation, and benefits offered are determined by role, experience level, and location.
We’re creating new financial services solutions for our members based on fairness, simplicity, and heart, and we treat our employees the same way. We offer a competitive benefits package that includes medical, dental and vision plans for employees and their families, 401(k) match, health and wellness programs, flexible time off policies for salaried employees, up to 16 weeks paid parental leave and more.
#LI-Hybrid
#LI-AW1
LendingClub is an equal opportunity employer and dedicated to diversity, equity, and inclusion in the workplace. We do not discriminate on the basis of race, religion, color, national origin, sex (including pregnancy, childbirth, reproductive health decisions, or related medical conditions), gender, gender identity, gender expression, sexual orientation, age, marital status, veteran status, disability status, political views or activity, or other applicable legally protected characteristics. We believe that a variety of perspectives will make our teams and business stronger as we work together to transform the traditional banking system.
We are committed to providing reasonable accommodations for qualified individuals with disabilities in our job application process. If you need assistance or an accommodation due to a disability, please contact us at interviewaccommodations@lendingclub.com.

#J-18808-Ljbffr

Lending Club Business Intelligence Interview Guide

Overview

Lending Club Business Intelligence Salary

Lending Club Business Intelligence Interview Process

Lending Club Business Intelligence Interview Questions

Lending Club Business Intelligence Jobs