Prepare for and practice interview questions from Avenu Insights & Analytics.

Avenu Insights & Analytics Interview Questions

Avenu Insights & Analytics Interview Guides

<p>Let’s say that your company is running a standard control and variant AB test on a feature to increase conversion rates on the landing page. The PM checks the results and finds a .04 p-value.</p>

<p>How would you assess the validity of the result?</p>


Experiment Validity

<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>Let’s say we have a table with an <code>id</code> and <code>name</code> fields. The table holds over 100 million rows and we want to sample a random row in the table without throttling the database.</p>

<p>Write a query to randomly sample a row from this table.</p>

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

<p><code>big_table</code> table</p>

<table>
<thead>
<tr>
<th>Columns</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>
</tbody>
</table>


Write a query to randomly sample a row from a big table.

Random SQL Sample

Avenu Insights & Analytics Salaries by Position

<h3>Job Description</h3><div>Job Description<div><div><div></div></div><div><div></div></div><div><div></div></div><div><div></div></div><div><div><div></div></div></div><div><div></div></div><div><p><strong>Job Summary:</strong></p><p>Avenu Insights & Analytics is a fast-paced software development company that provides local, state, and federal governments with solutions that offer the best services to their citizens. Our product and engineering team is looking for a senior developer to lead a development team as they modernize their application's user experience and technology. The ideal candidate is a well-rounded senior developer who has led a team, built applications hosted in Azure, has experience with modern patterns and practices, and is looking to grow an industry-leading engineering team. The team is local to the Birmingham, AL location, but works remotely. </p><p><strong>Duties and Responsibilities:</strong></p><ul><li>Design, Architect, and deliver innovative products and solutions</li><li>Write clean, scalable code using .NET and JavaScript programming languages</li><li>Continuously review and implement best practices based on corporate standards</li><li>Collaborate with UX/UI designers to implement designs</li><li>Collaborate with product leadership to understand priorities and requirements</li><li>Implement software enhancements and suggested improvements</li><li>Support delivery or support teams when delivering new software to customers</li><li>Communicating needs to leadership on behalf of the engineering team</li><li>Managing engineers aligned with the product team</li><li>Perform other duties as assigned</li></ul><p><strong>Education and Experience:</strong></p><ul><li>5+ years of experience developing .Net, JavaScript, or similar technologies</li><li>3+ years of database experience</li><li>Bachelor’s degree in computer science or related field (or industry experience)</li><li>GitHub, Azure DevOps, Azure Pipelines, Jenkins, TFS, Jira</li></ul><p><strong>Knowledge, Skills and Abilities:</strong></p><ul><li>Experience with VB.NET (existing application framework)</li><li>Experience with Typescript, Angular, and MVC (future application frameworks)</li><li>Experience working in the cloud (Azure is our cloud provider of choice)</li><li>Experience with Agile methodologies</li><li>Experience with relational or non-relational database development and standard practices, like creating database schemas, stored procedures, performance tuning</li><li>Experience use of GIT source control (we use GitHub)</li><li>Familiarity with HTML, CSS, Entity Framework, LINQ, REST, SOAP, RPC, APIs, DevExpress is helpful</li><li>Familiarity with automated testing/unit testing frameworks</li><li>Solid understanding of APIs and Web Services</li></ul><p><strong>Work Environment:</strong></p><p>The noise level in the work environment is usually moderate as the employee works in an office setting, at an individual workstation, using telephone and computer.</p><p><strong>Physical Demands:</strong></p><ul><li>Must be able to remain in a stationary position for most of the day</li><li>Constantly operates a computer and other office productivity machinery, such as a printer/copy machine</li><li>This position needs to occasionally move about inside the office</li><li>The person in this position frequently communicates via telephone</li></ul><p><strong>Avenu Summary: </strong></p><p>Avenu provides local governments with ways to achieve more predictable revenue that supports growth, fuels modernization and ensures compliance with mandated but underfunded programs. Avenu’s revenue enhancement and administrative solutions find and recover license, permit and other taxes that cities and counties struggle to collect. The insights and improved fiscal posture enables governments to deliver expected services and sustain a high quality of life for residents. </p><p><em>Avenu is an Equal Opportunity Employer. Selection for a position will be made without regard to race, religion, national origin, sex, political affiliation, marital status, non-disqualifying physical handicap, and age.</em></p></div></div></div>

Avenu Insights & Analytics Interview Questions

Avenu Insights & Analytics Interview Guides

Avenu Insights & Analytics Interview Questions

Avenu Insights & Analytics Salaries by Position

Avenu Insights & Analytics Opening Jobs