Prepare for and practice interview questions from Hampton Roads Transit.

Hampton Roads Transit Interview Questions

Hampton Roads Transit 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>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

<p>Let’s say you work for a social media company that has just done a launch in a new city. Looking at weekly metrics, you see a slow decrease in the average number of comments per user from January to March in this city.</p>

<p>The company has been consistently growing new users in the city from January to March.</p>

<p>What are some reasons why the average number of comments per user would be decreasing and what metrics would you look into?</p>


<p>What metric could be used to measure if active users are still engaging on the platform despite an overall decrease in the average number of comments per user?</p>

What metric could be used to measure if active users are still engaging on the platform despite an overall decrease in the average number of comments per user?

Decreasing Comments

How would you investigate a decline in the average number of comments per user?

Hampton Roads Transit Salaries by Position

<p>Hiring Salary Range: $53,018- $67,597 Responsible for the accounting and reporting of daily revenue data to ensure the integrity and accuracy of all fare media sales and point of service sales; the revenue reported from all sales, actual revenue received, and actual revenue deposited. Essential Job Functions: (Duties listed are not intended to be all inclusive nor to limit duties that might reasonably be assigned.) Assist with the maintenance and administration of the GFI software. Provide detailed analysis of revenue and ridership from GFI Software. Maintain revenue records, files and supporting documentation. Research accounts, reports, and records for accuracy and make necessary corrections. Compile information for statistical reports. Perform a variety of accounting duties involved in maintaining cash collection, fare media inventory and revenue data, including the input of transactions into the computer. Manage records created and received in compliance with the Hampton Roads Transit Records Management Policies and Procedures. Responsible for coordinating the records management effort within the department. Performs other duties as required. Required Knowledge, Abilities and Skills essential to Job Functions: Individual must have thorough knowledge of the principles, practices, theories of accounting and financial reporting. Strong analytical, planning, and organizational skills are required. Exceptional communication and customer service skills, plus a demonstrated ability to perform in a team environment are necessary. Thorough knowledge of spreadsheet and word processing software applications is a must. Must demonstrate the ability to draw conclusions and report results from an analysis of complex financial and operational data. Records Coordinator: Serve as the Departmental Records Coordinator with responsibility for organizing and maintaining departmental files in accordance with all of HRT's Records Management Policies and Procedures; preparing documents for imaging by designating file code information and forwarding to Records Management; maintaining (archiving/storage) and disposing of records in accordance with the approved HRT Records Retention and Disposition Schedules; attending regular information and training meetings; and providing information to the department Chief Officer and all department members on records management including paper, electronic records, photos, news articles, and other items. Required Software Knowledge and Skills essential to Job Functions: Proficiency in using computer systems and the listed software applications associated with performance of assigned work is essential. Basic problem-solving skills associated with software applications used is expected. Software usage relevant to job duties will be evaluated. Software applications: Email, Internet, Microsoft Office Suite, PeopleSoft Finance, GFI, Sybase Safety Responsibility: Perform all job duties and responsibilities in a safe manner to protect one's self, fellow employees, and the public from injury or harm. Promote safety awareness and follow safety procedures and policies. Take an active part in reporting unsafe conditions and any hazards within the workplace to their Supervisor, Manager and/or the Safety Department. Training and/or Education: Minimum of a bachelor's degree from an accredited four-year college or university in Accounting, Finance, Business Administration, Statistics, or other related field. Required Experience: Minimum of two years' work experience in accounting or any equivalent combination of training and experience is required. Experience in cash handling and/or management preferred. Licenses or Certificates: Possess a valid Driver's License. Acquire a Virginia Driver's License within 60 days after the date of hire (in instances when an out of state license is not the applicant's current state of residence). Special Requirements: This position is classified as non-essential personnel. FLSA Status: Exempt Physical Demands: 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. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions. Unusual Demands: The work environment characteristics described here are representative of those an employee encounters while performing the essential functions of this job. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions. Work involves meeting multiple demands on a timely basis. Duties may require some seasonal overtime. Accessibility: If you need an accommodation as part of the employment process please contact Human Resources at Phone: 757-222-6000 Email: careershrtransit.org Equal Opportunity Employer, including disabled and veterans. If you want to view the Know Your Rights: Workplace Discrimination is Illegal poster, please choose your language: English - Spanish - Arabic - Chinese English - Spanish - Chinese</p>

Hampton Roads Transit Interview Questions

Hampton Roads Transit Interview Guides

Hampton Roads Transit Interview Questions

Hampton Roads Transit Salaries by Position

Hampton Roads Transit Opening Jobs