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

Abrigo Business Intelligence Interview Guide

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


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

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

Overview

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

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

<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

Abrigo Business Intelligence Interview Questions

<strong>Description</strong> <br><br>We provide technology that community financial institutions use to manage risk and drive growth. Our solutions automate key processes - from anti-money laundering to fraud detection to CECL readiness to lending workflows - empowering our customers by addressing their Enterprise Risk Management needs. This is an exciting opportunity for someone wishing to grow their analytical and technical ability in the FinTech space. <br> <br>In this role, you will harness your technical expertise to support clients in meeting their reporting requirements while curating valuable insights through our business intelligence products. You will become proficient in our loan review, business intelligence, and our core products, enabling you to assist clients in creating customized reports, and maintaining and improving our report catalog. Collaborating closely with the Product Team, you'll enhance the performance and usability of our reporting solution. Our team's performance-driven culture and collaborative approach offer an excellent environment for launching or advancing your career. This position offers the flexibility of working remotely or from our offices in Raleigh, NC or Austin, TX <br> <br>What You'll Do: <br><ul> <li>Understand Loan Review end-to-end process for financial institutions. </li><li>Inventory customer's reporting requirements. </li><li>Develop and Maintain reports using DevExpress Reports Suite (or equivalent). </li><li>Develop SQL queries, stored procedures, and functions as required for each report. </li><li>Repair and update existing reports, as needed. </li><li>Review and provide accurate time-estimates for custom report requests. </li><li>Continuously document and effectively communicate progress, issues, and resolutions. </li><li>Other duties may be assigned, as necessary. </li><li>Develop and maintain a library of available reports for client use </li> <li>As an Analyst, you will be the primary escalation path for clients needing assistance with reports </li> <li>Work with clients and internal stakeholders to identify areas of need for CFIs and solve problems with data analysis. </li> <li>As your skills develop, take more responsibility for the architecture and maintenance of our reporting database and solution </li> <li>Develop subject-matter expertise in our lending, credit, financial crimes, and portfolio risk management solutions </li> <li>Provide excellent customer service through technical support and client follow-up as an Analyst, you should expect a dynamic environment with clear, specific tasks and goals in support of our client-facing projects and internal research and development </li><li>A quantitative, inquiring mindset with exemplary written communication skills are critical, as are the willingness and ability to learn new technical skills </li><li>Manipulate, analyze, and interpret complex data sets, draw business relevant conclusions, and present them successfully in useful business reports </li><li>Engage and participate in regular internal and external project meetings to fully understand data content </li><li>Partner with and advise internal team members on data-collection needs, trends, and focus areas </li><li>Identify areas for innovation in monitoring, discover issues and collection approaches to improve analytic efficiencies to deliver better value to customers </li><li>Gather, understand, and document detailed business requirements using appropriate tools and techniques </li></ul>What You'll Need: <ul><li>BA/BS degree or equivalent years of experience. </li> <li>1+ years' experience analyzing, designing, developing, and implementing reporting solutions. </li><li>Experience writing SQL queries, stored procedures, and functions. </li><li>Ability to communicate effectively in and across teams; must possess strong verbal, written, and interpersonal communication skills. Conveying technical concepts to non-technical users comes with the territory. </li> <li>Successful applicants have exposure to financial principles and should be comfortable interpreting the results of various mathematical models </li><li>Strong analytical and quantitative skills, with the ability to collect, organize, analyze, and disseminate significant amounts of information with attention to detail and accuracy </li><li>As you grow and demonstrate expertise as well as the ability to lead project workstreams and communicate effectively directly with clients, there will be opportunities for promotion to the Consultant role </li><li>Ability to accomplish tasks on time and a track record of results-oriented achievements </li><li>Ability to learn, understand, and apply new technologies both independently and with training. </li><li>Strong emphasis on robust documentation of all work completed </li></ul>Preferences: <ul> <li>DevExpress Web Reporting Tool experience preferred, but not required. </li><li>Financial/Accounting experience is a plus. </li></ul>What You'll Get: <ul><li>Market competitive total rewards package </li> <li>To be part of the Heart & SOUL of a winning company with an inspiring mission </li> <li>The opportunity to Make Big Things Happen </li> <li>Competitive salary along with full health benefits with an HSA option </li> <li>Flexible PTO and bank holidays </li> <li>401(k) plan and company match </li> </ul><br> <br>We are an equal opportunity employer and all qualified applicants will receive consideration for employment without regard to race, color, religion, sex, gender identity, age, genetic trait, sexual orientation, national origin, disability status, or any other characteristic protected by law. <br><br>Abrigo is committed to providing reasonable accommodations for qualified individuals with disabilities and disabled veterans in our job application procedures. If you need assistance or an accommodation due to a disability, you may contact us at [email protected] with the subject line accommodation.

Abrigo Business Intelligence Interview Guide

Overview

Abrigo Business Intelligence Salary

Abrigo Business Intelligence Interview Process

Abrigo Business Intelligence Interview Questions

Abrigo Business Intelligence Jobs