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

Axos Bank Business Intelligence Interview Guide

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


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

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

Overview

Axos Bank 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.

Axos Bank 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>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

Axos Bank Business Intelligence Interview Questions

Actual starting pay will vary based on factors including, but not limited to, geographic location, experience, skills, specialty, and education.
Eligible for an Annual Discretionary Cash Bonus Target: 10%
Eligible for an Annual Discretionary Restricted Stock Units Bonus Target: 10%
Target Range:  $85,000.00/Yr. - $105,000.00/Yr.
These discretionary target bonuses may be awarded semi-annually based upon your achievement of performance goals and targets.
About This Job
Analyzes business data to identify trends and insights, and provides recommendations to improve business performance. Develops and maintains dashboards and reports to communicate findings to stakeholders. Collaborates with cross-functional teams to drive data-driven decision making.
Responsibilities:
Analyze and identify business challenges and opportunities and apply modeling/statistics to make strategic and tactical recommendations
Consult with business partners to develop strategy to address and influence business problems
Analyze data, build BI tools, and develop financial models
Support customer acquisition strategies by vetting information from public sources and lead providers then aggregating content from data provider to stimulate development of telemarketing and email marketing campaigns
Consolidate available information to develop forecasts for products while also discovering strategic opportunities
Communicate results and recommendation to senior management and business partners
Identify opportunities to apply quantitative methods to improve business performance
Voice technical subject matter clearly and concisely to individuals from various backgrounds
Develop quantitative modeling competencies of others within the same line of business
Collaborate and mentor teammates
Requirements:
Bachelor's degree in Economics, Finance, Statistics, or similar quantitative field of study (Math, Economics, Financial Engineering, Physics, Industrial Engineering, Operations Research, etc.)
5+ years of data analytics experience
Expertise in two or more of the following:
SQL
Tableau
Excel
Decisions Engine
Python
Demonstrated leadership ability
Strong communication skills
Ability to successfully manage multiple projects on tight deadlines
Track record of delivering accurate results
Axos Employee Benefits May Include:
Medical, Dental, Vision, and Life Insurance
Paid Sick Leave, 3 weeks’ Vacation, and Holidays (about 11 a year)
HSA or FSA account and other voluntary benefits
401(k) Retirement Saving Plan with Employer Match Program and 529 Savings Plan
Employee Mortgage Loan Program and free access to an Axos Bank Account with Self-Directed Trading
About Axos
Born digital-first, Axos delivers financial tools and services that allow individuals, small businesses, and companies to access and manage their money how, when, and where they want. We’re a diverse team of dynamic, insightful, and independent innovators who are excited to provide technology-driven solutions that offer unbeatable value to our customers.
Axos Financial is our holding company and is publicly traded on the New York Stock Exchange under the symbol "AX" (NYSE: AX).
Pre-Employment Background Check and Drug Test:
All offers are contingent upon the candidate successfully passing a credit check, criminal background check, and pre-employment drug screening, which includes screening for marijuana. Axos Bank is a federally regulated banking institution. At the federal level, marijuana is an illegal schedule 1 drug; therefore, we will not employ any person who tests positive for marijuana, regardless of state legalization.
Equal Employment Opportunity:
Axos is an Equal Opportunity employer. We are committed to providing equal employment opportunities to all employees and applicants without regard to race, religious creed, color, sex (including pregnancy, breast feeding and related medical conditions), gender, gender identity, gender expression, sexual orientation, national origin, ancestry, citizenship status, military and veteran status, marital status, age, protected medical condition, genetic information, physical disability, mental disability, or any other protected status in accordance with all applicable federal, state, and local laws.
Job Functions and Work Environment:
While performing the duties of this position, the employee is required to sit for extended periods of time. Manual dexterity and coordination are required while operating standard office equipment such as computer keyboard and mouse, calculator, telephone, copiers, etc.
The work environment characteristics described here are representative of those an employee may encounter while performing the essential functions of this position. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions of this position.
About Us!  We’re a team of relentless innovators that are challenging the status quo through smart, pro-consumer financial products and services. We got our start in 2000, as an online bank – when the idea of banking online was almost unthinkable. Since then, we’ve evolved to add commercial banking, commercial lending, investment, clearing, and fiduciary services to our toolbox. As modern life continues to present new challenges for clients, we step up and find creative ways to solve them.

#J-18808-Ljbffr

<h3>Business Analyst, Internal Consulting </h3><p>Apply remote type Onsite locations HQ - San Diego, CA time type Full time posted on Posted 4 Days Ago job requisition id JR1588 Axos Bank </p><p><b>Target Range: </b> $70,000.00 /Yr. - $75,000.00 /Yr. </p><p>Actual starting pay will vary based on factors including, but not limited to, geographic location, experience, skills, specialty, and education. Eligible for an Annual Discretionary Cash Bonus Target: 10%. Eligible for an Annual Discretionary Restricted Stock Units Bonus Target: 10%. </p><p><i>These discretionary target bonuses may be awarded semi-annually based upon your achievement of performance goals and targets. </i> </p><p><b>About This Job </b> </p><p>Axos is looking for a Business Analyst that has excellent problem-solving skills, an analytical way of thinking, and strong experience in reporting to join our team supporting the office of the CEO. This Business Analyst will provide data analysis, dashboards, and reports for key enterprise initiatives using SQL, Tableau, and other analytical tools. This position is on-site at our HQ in San Diego, CA. </p><p><b>Responsibilities: </b> </p><ul><li>Provide analytical and reporting support for the business unit and conduct data mining using SQL and other analytical tools. </li><li>Support internal consulting and process improvement initiatives by analyzing business functions, gathering information, and evaluating system capabilities. </li><li>Develop technical requirements documents, working with business and technical stakeholders, to support technical projects. </li><li>Conduct market research to support system selection initiatives considering business and customer requirements, technical capabilities, regulatory requirements, and existing tech stacks. </li><li>Prepare process map and procedure documentation to support changes in existing processes. </li><li>Provide administrative support for key business systems in the OCEO. </li><li>Perform other projects, support, and duties as assigned by management. </li> </ul><p><b>Qualifications: </b> </p><ul><li>Bachelor's degree in Business Administration, Accounting, Finance, Economics, Mathematics, Statistics, Computer Science, or other related field. </li><li>2+ years' experience, preferably in business analyst role, data analytics, or role with directly transferable skills. </li><li>Competent in writing SQL queries - Excel skills (pivot tables, compound formulas, arrays). </li><li>Experience designing reports in BI tools, preferably Tableau, SSRS, or PowerBI. </li><li>Strong computer skills including all Microsoft Office applications. </li><li>Project management skills with ability to manage multiple and/or shifting priorities while producing professional quality and accurate deliverables. </li> </ul><p><b>Axos Employee Benefits May Include: </b> </p><ul><li>Medical, Dental, Vision, and Life Insurance. </li><li>Paid Sick Leave, 3 weeks’ Vacation, and Holidays (about 11 a year). </li><li>HSA or FSA account and other voluntary benefits. </li><li>401(k) Retirement Saving Plan with Employer Match Program and 529 Savings Plan. </li><li>Employee Mortgage Loan Program and free access to an Axos Bank Account with Self-Directed Trading. </li> </ul><p><b>About Axos </b> </p><p>Born digital-first, Axos delivers financial tools and services that allow individuals, small businesses, and companies to access and manage their money how, when, and where they want. We’re a diverse team of dynamic, insightful, and independent innovators who are excited to provide technology-driven solutions that offer unbeatable value to our customers. </p><p>Axos Financial is our holding company and is publicly traded on the New York Stock Exchange under the symbol "AX" (NYSE: AX). </p><p><b>Pre-Employment Background Check and Drug Test: </b> </p><p>All offers are contingent upon the candidate successfully passing a credit check, criminal background check, and pre-employment drug screening, which includes screening for marijuana. Axos Bank is a federally regulated banking institution. At the federal level, marijuana is an illegal schedule 1 drug; therefore, we will not employ any person who tests positive for marijuana, regardless of state legalization. </p><p><b>Equal Employment Opportunity: </b> </p><p>Axos is an Equal Opportunity employer. We are committed to providing equal employment opportunities to all employees and applicants without regard to race, religious creed, color, sex (including pregnancy, breast feeding and related medical conditions), gender, gender identity, gender expression, sexual orientation, national origin, ancestry, citizenship status, military and veteran status, marital status, age, protected medical condition, genetic information, physical disability, mental disability, or any other protected status in accordance with all applicable federal, state, and local laws. </p><p><b>Job Functions and Work Environment: </b> </p><p>While performing the duties of this position, the employee is required to sit for extended periods of time. Manual dexterity and coordination are required while operating standard office equipment such as computer keyboard and mouse, calculator, telephone, copiers, etc. </p><p>The work environment characteristics described here are representative of those an employee may encounter while performing the essential functions of this position. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions of this position. </p>#J-18808-Ljbffr

Axos Bank
Target Range:
$70,000.00 /Yr. - $75,000.00 /Yr.
Actual starting pay will vary based on factors including, but not limited to, geographic location, experience, skills, specialty, and education.
Eligible for an Annual Discretionary Cash Bonus Target: 10%
Eligible for an Annual Discretionary Restricted Stock Units Bonus Target: 10%
These discretionary target bonuses may be awarded semi-annually based upon your achievement of performance goals and targets.
About This Job
Axos is looking for a Business Analyst that has excellent problem-solving skills, an analytical way of thinking, and strong experience in reporting to join our team supporting the office of the CEO. This Business Analyst will provide data analysis, dashboards, and reports for key enterprise initiatives using SQL, Tableau, and other analytical tools. This position is on-site at our HQ in San Diego, CA.
Responsibilities:
Provide analytical and reporting support for the business unit and conduct data mining using SQL and other analytical tools.
Support internal consulting and process improvement initiatives by analyzing business functions, gathering information, and evaluating system capabilities.
Develop technical requirements documents, working with business and technical stakeholders, to support technical projects.
Conduct market research to support system selection initiatives considering business and customer requirements, technical capabilities, regulatory requirements, and existing tech stacks.
Prepare process map and procedure documentation to support changes in existing processes.
Provide administrative support for key business systems in the OCEO.
Perform other projects, support, and duties as assigned by management.
Qualifications:
Bachelor's degree in Business Administration, Accounting, Finance, Economics, Mathematics, Statistics, Computer Science, or other related field.
2+ years' experience, preferably in business analyst role, data analytics, or role with directly transferable skills.
Competent in writing SQL queries - Excel skills (pivot tables, compound formulas, arrays).
Experience designing reports in BI tools, preferably Tableau, SSRS, or PowerBI.
Strong computer skills including all Microsoft Office applications.
Project management skills with ability to manage multiple and/or shifting priorities while producing professional quality and accurate deliverables.
Axos Employee Benefits May Include:
Medical, Dental, Vision, and Life Insurance.
Paid Sick Leave, 3 weeks’ Vacation, and Holidays (about 11 a year).
HSA or FSA account and other voluntary benefits.
401(k) Retirement Saving Plan with Employer Match Program and 529 Savings Plan.
Employee Mortgage Loan Program and free access to an Axos Bank Account with Self-Directed Trading.
About Axos
Born digital-first, Axos delivers financial tools and services that allow individuals, small businesses, and companies to access and manage their money how, when, and where they want. We’re a diverse team of dynamic, insightful, and independent innovators who are excited to provide technology-driven solutions that offer unbeatable value to our customers.
Axos Financial is our holding company and is publicly traded on the New York Stock Exchange under the symbol "AX" (NYSE: AX).
Pre-Employment Background Check and Drug Test:
All offers are contingent upon the candidate successfully passing a credit check, criminal background check, and pre-employment drug screening, which includes screening for marijuana. Axos Bank is a federally regulated banking institution. At the federal level, marijuana is an illegal schedule 1 drug; therefore, we will not employ any person who tests positive for marijuana, regardless of state legalization.
Equal Employment Opportunity:
Axos is an Equal Opportunity employer. We are committed to providing equal employment opportunities to all employees and applicants without regard to race, religious creed, color, sex (including pregnancy, breast feeding and related medical conditions), gender, gender identity, gender expression, sexual orientation, national origin, ancestry, citizenship status, military and veteran status, marital status, age, protected medical condition, genetic information, physical disability, mental disability, or any other protected status in accordance with all applicable federal, state, and local laws.
Job Functions and Work Environment:
While performing the duties of this position, the employee is required to sit for extended periods of time. Manual dexterity and coordination are required while operating standard office equipment such as computer keyboard and mouse, calculator, telephone, copiers, etc.
The work environment characteristics described here are representative of those an employee may encounter while performing the essential functions of this position. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions of this position.

#J-18808-Ljbffr

Business Analyst, Internal Consulting  Apply remote type Onsite locations HQ - San Diego, CA time type Full time posted on Posted 4 Days Ago job requisition id JR1588 Axos Bank
Target Range:  $70,000.00 /Yr. - $75,000.00 /Yr.
Actual starting pay will vary based on factors including, but not limited to, geographic location, experience, skills, specialty, and education. Eligible for an Annual Discretionary Cash Bonus Target: 10%. Eligible for an Annual Discretionary Restricted Stock Units Bonus Target: 10%.
These discretionary target bonuses may be awarded semi-annually based upon your achievement of performance goals and targets.
About This Job
Axos is looking for a Business Analyst that has excellent problem-solving skills, an analytical way of thinking, and strong experience in reporting to join our team supporting the office of the CEO. This Business Analyst will provide data analysis, dashboards, and reports for key enterprise initiatives using SQL, Tableau, and other analytical tools. This position is on-site at our HQ in San Diego, CA.
Responsibilities:
Provide analytical and reporting support for the business unit and conduct data mining using SQL and other analytical tools.
Support internal consulting and process improvement initiatives by analyzing business functions, gathering information, and evaluating system capabilities.
Develop technical requirements documents, working with business and technical stakeholders, to support technical projects.
Conduct market research to support system selection initiatives considering business and customer requirements, technical capabilities, regulatory requirements, and existing tech stacks.
Prepare process map and procedure documentation to support changes in existing processes.
Provide administrative support for key business systems in the OCEO.
Perform other projects, support, and duties as assigned by management.
Qualifications:
Bachelor's degree in Business Administration, Accounting, Finance, Economics, Mathematics, Statistics, Computer Science, or other related field.
2+ years' experience, preferably in business analyst role, data analytics, or role with directly transferable skills.
Competent in writing SQL queries - Excel skills (pivot tables, compound formulas, arrays).
Experience designing reports in BI tools, preferably Tableau, SSRS, or PowerBI.
Strong computer skills including all Microsoft Office applications.
Project management skills with ability to manage multiple and/or shifting priorities while producing professional quality and accurate deliverables.
Axos Employee Benefits May Include:
Medical, Dental, Vision, and Life Insurance.
Paid Sick Leave, 3 weeks’ Vacation, and Holidays (about 11 a year).
HSA or FSA account and other voluntary benefits.
401(k) Retirement Saving Plan with Employer Match Program and 529 Savings Plan.
Employee Mortgage Loan Program and free access to an Axos Bank Account with Self-Directed Trading.
About Axos
Born digital-first, Axos delivers financial tools and services that allow individuals, small businesses, and companies to access and manage their money how, when, and where they want. We’re a diverse team of dynamic, insightful, and independent innovators who are excited to provide technology-driven solutions that offer unbeatable value to our customers.
Axos Financial is our holding company and is publicly traded on the New York Stock Exchange under the symbol "AX" (NYSE: AX).
Pre-Employment Background Check and Drug Test:
All offers are contingent upon the candidate successfully passing a credit check, criminal background check, and pre-employment drug screening, which includes screening for marijuana. Axos Bank is a federally regulated banking institution. At the federal level, marijuana is an illegal schedule 1 drug; therefore, we will not employ any person who tests positive for marijuana, regardless of state legalization.
Equal Employment Opportunity:
Axos is an Equal Opportunity employer. We are committed to providing equal employment opportunities to all employees and applicants without regard to race, religious creed, color, sex (including pregnancy, breast feeding and related medical conditions), gender, gender identity, gender expression, sexual orientation, national origin, ancestry, citizenship status, military and veteran status, marital status, age, protected medical condition, genetic information, physical disability, mental disability, or any other protected status in accordance with all applicable federal, state, and local laws.
Job Functions and Work Environment:
While performing the duties of this position, the employee is required to sit for extended periods of time. Manual dexterity and coordination are required while operating standard office equipment such as computer keyboard and mouse, calculator, telephone, copiers, etc.
The work environment characteristics described here are representative of those an employee may encounter while performing the essential functions of this position. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions of this position.

#J-18808-Ljbffr

Axos Bank Business Intelligence Interview Guide

Overview

Axos Bank Business Intelligence Salary

Axos Bank Business Intelligence Interview Process

Axos Bank Business Intelligence Interview Questions

Axos Bank Business Intelligence Jobs