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

Tricon residential Business Intelligence Interview Guide

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


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

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

Overview

Tricon residential 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.

Tricon residential 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

Tricon residential Business Intelligence Interview Questions

<p>Tricon Residential is anownerand operatorofa growing portfolioof morethan 38,000 single-family rental homes in the U.S.Sun Beltand multi-familyapartmentsin Canada.Our commitment to enriching the lives of our employees, residents and local communities underpins Tricon's culture and business philosophy.We provide high-quality rental housing options for families across the United States and Canada through our technology-enabled operating platform and dedicated on-the-ground operating teams.Our development programs are also delivering thousands of new rental homes and apartments as part of our commitment to help solve the housing supply shortage. At Tricon, we imagine a world where housing unlocks life's potential. For more information, visitTricon Residential. </p><p><b>Job Description</b> </p>The Product Manager has an entrepreneurial mindset and is a goal achiever who thrives in a fast-paced environment and is passionate about delivering innovative solutions to enrich the lives of our residents. The Product Manager plays a pivotal role in driving the development and enhancement of our rental management system, takes ownership of key initiatives and inspires excellence in everything we do to enrich the lives of our residents. <p><b>Essential Duties and Responsibilities</b> include the following but are not limited to the job specifications contained herein. Additional duties or job functions that can be performed safely may be required as deemed necessary by supervisory personnel. </p> <ul><li> <p>Gather and document business and functional requirements, including creating process flowcharts and diagrams. </p></li> <li><p>Collaborate with stakeholders to validate requirements, address business needs, and design solutions that enhance user experiences. </p></li> <li><p>Assess and document current processes, identifying gaps and opportunities for improvement through detailed user stories and acceptance criteria. </p></li> <li><p>Lead the prioritization, estimation, and implementation of user stories, ensuring timely updates to stakeholders. </p></li> <li><p>Perform user acceptance testing (UAT) and troubleshoot system issues, providing resolutions. </p></li> <li><p>Analyze and report on trends, insights, and data to support decision-making. </p></li> <li><p>Develop and maintain comprehensive product documentation, including user guides, SOPs, FAQs, workflow diagrams, and training materials; deliver training sessions to internal and external users. </p></li> <li><p>Draft and distribute release notes following product launches or updates. </p></li> <li><p>Act as the main point of contact for third-party developers, managing timelines and addressing queries. </p></li> <li><p>Write SQL queries for data validation, troubleshooting, and testing purposes. </p></li> <li><p>Conduct user research and interviews to gather insights and refine product requirements. </p></li> <li><p>Understand data and APIs well enough to participate in and guide discussions with developers and other PMs for projects involving data and system integrations. </p></li> <li><p>Understand and communicate the impact of design decisions on business outcomes and user experience. </p></li> </ul><p><b>Qualifications:</b> </p><ul> <li><p>Exposure to custom systems and agile development methodology. </p></li> <li><p>Highly organized with great attention to detail. </p></li> <li><p>Proven experience in gathering requirements and testing. </p></li> <li><p>Intermediate experience writing and reading SQL database queries. </p></li> <li><p>Experienced and knowledgeable with relational database design and navigation. </p></li> <li><p>Ability to communicate effectively, both written and verbal. </p></li> <li><p>Strong analytical and problem-solving skills, with the ability to think logically and strategically. </p></li> <li><p>Self-starter with a strong work ethic and the ability to work independently as well as in a team environment. </p></li> <li><p>Motivated and proactive in setting up meetings and getting the answers needed. </p></li> <li><p>Technically savvy with an understanding of how software works and specifically how the product functions. </p></li> <li><p>Passionate about documentation and workflow diagrams. </p></li> <li><p>Strong technical knowledge </p></li> <li><p>Good understanding of project and time management principles </p></li> <li><p>Passionate about technology and creating business efficiencies </p></li> </ul><p><b>Minimum Requirements:</b> </p><ul> <li><p>BA/BS or combination of industry certifications and equivalent related work experience of 5 years or more </p></li> </ul> <p><b>Physical Demands:</b> </p><p>The physical demands described here are representative of those that must be met by an employee to successfully perform the essential functions of this job, including: </p><ul> <li><p>Frequently required to sit, talk, and hear. </p></li> <li><p>Frequently required to stand and move; use hands to grasp, squeeze, finger, handle, and feel; reach, push, and pull with hands and arms; occasionally required to twist; reach overhead; stoop, kneel, squat, bend, and crouch. </p></li> <li><p>Occasionally lift, carry, and move up to 10 pounds. </p></li> <li><p>Vision abilities required by this job include close vision, distance vision, and depth perception. </p></li> </ul> <p>At Tricon, we are committed to creating a workplace where every individual is valued for their unique contributions, experiences, voices, and backgrounds. By embracing these principles, we aim to positively impact our business and the communities we serve, creating a lasting legacy where everyone can thrive. </p><p>Salary Range </p><p>Placement within this compensation range will be determined by the candidate's knowledge, experience and skills. </p>$74,930.00 - $124,890.00

Tricon residential Business Intelligence Interview Guide

Overview

Tricon residential Business Intelligence Salary

Tricon residential Business Intelligence Interview Process

Tricon residential Business Intelligence Interview Questions

Tricon residential Business Intelligence Jobs