Prepare for and practice interview questions from Zayo Group.

Zayo Group Interview Questions

Zayo Group Interview Guides

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.

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

Input:

<code>big_table</code> table

<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

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.

How would you assess the validity of the result?

Experiment Validity

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

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

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?

Zayo Group Salaries by Position

Company Description Zayo provides mission-critical bandwidth to the world's most impactful companies, fueling the innovations that are transforming our society. Zayo's 141,000-mile network in North America and Europe includes extensive metro connectivity to thousands of buildings and data centers. Zayo's communications infrastructure solutions include dark fiber, private data networks, wavelengths, Ethernet, and dedicated Internet access. Zayo serves wireless and wireline carriers, media, tech, content, finance, healthcare and other large enterprises. A successful Product Manager will be responsible for conducting product level analysis, providing direct commercial sales support, and developing overall product positioning and growth strategy. This includes management of the existing service portfolio as well as assessment and implementation of new products, internal processes, sales tools and/or market expansions. Through direct customer interaction and an understanding of the marketplace, the Product Manager will provide recommendations and sponsor initiatives to grow the bandwidth infrastructure business. The ability to develop business metrics, clearly communicate and present findings and recommend action to senior leadership is essential. This position requires a firm grasp of Zayo's product portfolio, network footprint, competitive position and industry market dynamics. Prior sales support experience and knowledge of industry technology and terminology, as well as proficiency in MS Excel and PowerPoint, is required. Additionally, the ability to integrate quickly into Zayo's CRM software and manage workload in a dynamic, entrepreneurial environment is also critical. Responsibilities <ul> <li>Responsible for business analysis and recommendations resulting from such analysis. </li><li>Ownership of business cases for product enhancements / developments. </li><li>Ownership of product definitions, positioning and value proposition development, pricing and guidelines, </li><li>competitive analysis. </li><li>Responsibility for project managing product initiatives across stakeholder organizations. </li><li>Responsibility for product segmentation, targeting and positioning. </li><li>Proactive and regular interaction with key customers to ensure products meet the needs of the market. </li></ul>Qualifications <ul> <li>Minimum 3-5 years of commercial product management experience in the telecommunications industry. </li><li>Prior experience with network development or other network construction/planning is beneficial </li><li>Undergraduate B.A. or B.S. degree. Focused area of study in Engineering, Business, Finance or Economics preferred. </li><li>MBA and/or equivalent work experience with proven ability to work across functional boundaries preferred. </li><li>Well-developed financial skills including business case development, cost management, budgeting and financial analysis. </li><li>Excellent written and verbal communications skills. Ability to write reports, business correspondence, procedure manuals, and prepare presentations and proposals. Must possess ability to effectively present information and respond to questions from groups of managers, employees and customers. </li><li>Prior product, sales and/or sales engineering experience with Layer 1 services (dark fiber and/or transport) a plus. </li><li>Proficiency in the MS Office suite with emphasis on Excel, Word and PowerPoint is required. Knowledge of Salesforce.com platform is a plus. </li><li>Requires an individual who is detailed oriented with superb organizational skills and the ability to multi-task and prioritize. Requires an ability to be flexible in work schedule and to work and meet strict deadlines with limited supervision. </li></ul>The Base Pay Range: $87,500 - $130,000, commensurate with experience. Benefits, Rewards & Wellness <ul> <li>Excellent Health, Dental & Vision Insurance </li><li>Retirement 401(k) Savings Plan </li><li>Fitness membership discounts </li><li>Generous paid time off policy including paid parental leave </li></ul> Zayo provides equal employment opportunities to all employees and applicants for employment and prohibits discrimination and harassment of any type without regard to race, color, religion, age, sex, national origin, disability status, genetics, protected veteran status, sexual orientation, gender identity or expression, or any other characteristic protected by federal, state, provincial or local laws. This policy applies to all terms and conditions of employment, including recruiting, hiring, placement, promotion, termination, layoff, recall, transfer, leaves of absence, compensation and training.

Zayo Group Interview Questions

Zayo Group Interview Guides

Zayo Group Interview Questions

Zayo Group Salaries by Position

Zayo Group Opening Jobs