Prepare for and practice interview questions from Harris computer systems.

Harris computer systems Interview Questions

A/B Testing

Algorithms

Analytics

Machine Learning

Probability

Product Metrics

Python

Statistics

Harris computer systems Interview Guides

<p>Suppose there exists a new airline named Jetco that flies domestically across North America. Jetco recently had a study commissioned that tested the boarding time of every airline, and it came out that Jetco had the fastest average boarding times of any airline.</p>

<p>What factors could have biased this result, and what would you look into?</p>


<p>What could potentially bias the average boarding time in favor of an airline that only flies domestically?</p>

What could potentially bias the average boarding time in favor of an airline that only flies domestically?

Boarding Times Bias

A new airline came out as the fastest average boarding times compared to other airlines.  What factors could have biased this result and what would you look into?

<p>You are testing hundreds of hypotheses with many <em>t</em>-tests. What considerations should be made?</p>


<p>What is a key disadvantage of the F-test when compared to multiple t-tests?</p>

What is a key disadvantage of the F-test when compared to multiple t-tests?

Hundreds of Hypotheses

You are testing hundreds of hypotheses with many t-tests. What considerations should be made?

<p>The schema below is for a retail online shopping company consisting of two tables, <code>attribution</code> and <code>user_sessions</code>.</p>

<ul>
<li><p>The attribution table logs a session visit for each row.</p></li>

<li><p>If <code>conversion</code> is <code>true</code>, then the user converted to buying on that session.</p></li>

<li><p>The <code>channel</code> column represents which advertising platform the user was attributed to for that specific session.</p></li>

<li><p>Lastly the <code>user_sessions</code> table maps many to one session visits back to one user.</p></li>
</ul>

<p>First touch attribution is defined as the channel with which the converted user was associated when they first discovered the website.</p>

<p>Calculate the first touch attribution for each <code>user_id</code> that converted. </p>

<p><strong>Example:</strong></p>

<p><strong>Input:</strong></p>

<p><code>attribution</code> table</p>

<table>
<thead>
<tr>
<th>Column</th>
<th>Type</th>
</tr>
</thead>

<tbody>
<tr>
<td><code>session_id</code></td>
<td>INTEGER</td>
</tr>

<tr>
<td><code>channel</code></td>
<td>VARCHAR</td>
</tr>

<tr>
<td><code>conversion</code></td>
<td>BOOLEAN</td>
</tr>
</tbody>
</table>
<p><code>user_sessions</code> table</p>

<table>
<thead>
<tr>
<th>column</th>
<th>type</th>
</tr>
</thead>

<tbody>
<tr>
<td><code>session_id</code></td>
<td>INTEGER</td>
</tr>

<tr>
<td><code>created_at</code></td>
<td>DATETIME</td>
</tr>

<tr>
<td><code>user_id</code></td>
<td>INTEGER</td>
</tr>
</tbody>
</table>
<p><strong>Example output:</strong></p>

<table>
<thead>
<tr>
<th><code>user_id</code></th>
<th><code>channel</code></th>
</tr>
</thead>

<tbody>
<tr>
<td>123</td>
<td>facebook</td>
</tr>

<tr>
<td>145</td>
<td>google</td>
</tr>

<tr>
<td>153</td>
<td>facebook</td>
</tr>

<tr>
<td>172</td>
<td>organic</td>
</tr>

<tr>
<td>173</td>
<td>email</td>
</tr>
</tbody>
</table>


First Touch Attribution

Harris computer systems Salaries by Position

<div><h2>M&A Research Analyst</h2><p>At Harris we are disciplined deployers of capital and great operators of vertical market software businesses. Our companies provide mission-critical software solutions to multiple vertical markets across the globe. We are an operating group of Constellation Software Inc. (TSX: CSU), one of the world's most active acquirers of software businesses and home to a portfolio of over 500 companies in 150 countries.</p><p>As a Research Analyst you will have a critical role in supporting our M&A process. You will be successful in this role if you have a passion for research, analysis, investments, data, software, and you love to continuously learn. We are looking for someone who wants to grow their career for the long term in this role as you will become a vital component of our current and future investment strategy.</p><h3>What Will You Be Doing</h3><p>Majority (>80%)</p><ul><li>Qualifying M&A Prospects  Understand and use our investment criteria for rigorous screening of prospects</li><li>Big Data  Manage, monitor and maintain the data quality of our watch-list of M&A prospects in our CRM with reports and dashboards</li><li>Research  Perform primary research on owner-operated businesses, private equity portfolio companies, as well as potential carve outs of multinational corporations</li><li>Research  market-sizing, industry trends, and competitor analysis</li><li>Research  Software M&A advisors, brokers, and investment banks</li><li>Data sources  Identify & analyze relevant 3rd party data sources such as industry tradeshows and conferences for M&A prospects</li><li>Analysis-Prepare and report on various statistics and KPIs related to our M&A pipeline</li></ul><p>Minority (<20%)</p><ul><li>Ad Hoc Analysis & Special Projects with our senior M&A and Corporate Development leaders to support capital deployment</li></ul><h3>What We Are Looking For</h3><ul><li>2-4+ years of experience in finance, accounting, software, or data analysis</li><li>Bachelor's degree in Business, Finance, Accounting, or Economics (BBA/ BCom etc.)</li><li>Self-motivated individual with an ability to perform independently in a fast-paced environment</li><li>Excellent attention to detail, and the ability to manage multiple priorities and meet tight deadlines</li><li>Excellent organizational skills, written and verbal communication skills, and analytical ability</li><li>Proficient in Microsoft Office, particularly Excel and PowerPoint</li><li>Leverages AI for research and analysis</li><li>High degree of professionalism and integrity</li><li>Ability to work remotely in the U.S. or Canada</li></ul></div>

Question	Topic	Difficulty	Ask Chance
Boarding Times Bias	Statistics	Medium	Very High
Hundreds of Hypotheses	Statistics	Medium	Very High
First Touch Attribution	SQL	Hard	Very High

Harris computer systems Interview Questions

Harris computer systems Interview Guides

Harris computer systems Interview Questions

Harris computer systems Salaries by Position

Harris computer systems Opening Jobs