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

Endpoint Business Intelligence Interview Guide

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


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

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

Overview

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

Endpoint 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 show the number of users, number of transactions placed, and total order amount per month in the year 2020. Assume that we are only interested in the monthly reports for a single year (January-December).</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>products</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>price</code></td>
<td>FLOAT</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>

<tr>
<td><code>sex</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>month</code></td>
<td>INTEGER</td>
</tr>

<tr>
<td><code>num_customers</code></td>
<td>INTEGER</td>
</tr>

<tr>
<td><code>num_orders</code></td>
<td>INTEGER</td>
</tr>

<tr>
<td><code>order_amt</code></td>
<td>INTEGER</td>
</tr>
</tbody>
</table>


Monthly Customer Report

<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

Endpoint Business Intelligence Interview Questions

<strong><b>Who We Are</b></strong><br>Endpoint is a digital title and settlement company built from the ground up to make closing real estate transactions easy for all. Founded in 2018 with a diverse group of tech and real estate veterans, Endpoint develops technology that streamlines the closing process for real estate agents, buyers and sellers, and empowers proptech companies and investors looking to scale their closing operations. Through the combination of people, process and technology, Endpoint delivers a closing experience that is simple, secure and consistent at scale. Backed by First American Financial Corporation, Endpoint has secured $220 million in funding and has operations across the U.S.<br><br><strong><b>What We Do</b></strong><br><br>Endpoint is a digital title and settlement company built from the ground up to make home closing easy for all. For many, buying or selling a home is one of life's biggest transactions. At Endpoint, we help our customers close every deal so they can start their next chapter with confidence. Whether it's a first-time homebuyer choosing a place to start a family, a real estate agent securing a record-breaking deal, or a proptech company scaling its services, we believe that closing on a home is a milestone worth celebrating and a process that should be easy for all parties involved.<br><br>Founded in 2018 by a diverse group of tech and real estate veterans, Endpoint develops technology that streamlines home closing for real estate agents, buyers and sellers, and empowers proptech companies and investors looking to scale their closing operations. Backed by First American Financial Corporation, a Fortune 500 company, Endpoint has secured $220 million in funding and has operations across the US.<br><br>We are looking for a Senior Software Engineer (5+ years) to build services and functionality for our client applications.<br><br>*We are open to remote candidates for this role<br><br><b>As a Senior Software Engineer, you will use your skills to:</b><br><ul><li>Work with a cross-functional team to deliver timely, high quality, and well-tested code.</li><li>Author TDDs, provide feedback, and partner with the team to address requirements of one or more projects.</li><li>Collaborate with the team on technical decision making and software architecture.</li><li>Define and enforce standards regarding code quality and test coverage.</li><li>Mentor other team members, share your learnings and ideas within department.</li><li>Help continue to build the engineering culture at Endpoint.</li></ul><br><br><b>You'll come to Endpoint with:</b><br><ul><li>5+ years of experience building web services using modern frameworks.</li><li>Experience developing in a microservices architecture, and following domain-driven design principles. </li><li>Solid coding practices including writing technical specifications, peer code review, and unit & integration testing.</li><li>Experience designing and building complex products or major features from concept to launch.</li><li>Experience with Node.js, React, Typescript and DynamoDB is a plus.</li></ul><br><br><b>Why work at Endpoint:</b><br><ul><li>You'll join a fast-growing company where you can make an impact.</li><li>You'll work alongside industry experts and the brightest minds in tech to transform an industry.</li><li>We foster a vibrant, welcoming, and inclusive company culture.</li><li>You'll be entrusted with responsibility and autonomy in your day-to-day work.</li><li>You'll have opportunities to advance your career from within, or for internal mobility.</li><li>Customizable benefits including Health, Dental, Vision, and 401K Match.</li><li>Flexible work options for certain roles.</li><li>Virtual and in-person team events</li><li>We offer competitive compensation; Base pay is one part of your total compensation package in addition to annual bonus. This role pays between $145,000 and $205,000 and your actual base pay will depend on your skills, qualifications and experience. We also offer a long-term incentive plan.</li></ul><br><br>This hiring range is a good faith and reasonable estimate of the salary range of possible compensation at the time of posting and is subject to change. The actual compensation offered will be determined by various factors, which may include a candidate's education, training and experience.<br><br>Endpoint is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, age, religion, sex, national origin, disability, protected veteran status, or any other characteristic protected under federal, state or local law.<br><br><strong><b>What We Offer</b></strong><br>By choice, we don't simply accept individuality - we embrace it, we support it, and we thrive on it! Our People First Culture celebrates diversity, equity and inclusion not simply because it's the right thing to do, but also because it's the key to our success. We are proud to foster an authentic and inclusive workplace For All. You are free and encouraged to bring your entire, unique self to work. First American is an equal opportunity employer in every sense of the term.<br><br>Based on eligibility, First American offers a comprehensive benefits package including medical, dental, vision, 401k, PTO/paid sick leave and other great benefits like an employee stock purchase plan.

Endpoint Business Intelligence Interview Guide

Overview

Endpoint Business Intelligence Salary

Endpoint Business Intelligence Interview Process

Endpoint Business Intelligence Interview Questions

Endpoint Business Intelligence Jobs