Prepare for and practice interview questions from Zayo Group.

Zayo Group Interview Questions

Zayo Group 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>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

Zayo Group Salaries by Position

<p>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.

The Business Analyst Specialist, GNOC is a strategic position that plays a pivotal role in the data integrity of Key Zayo functions. The position is responsible for assisting the Business Operations team and Strategic Operation Organization build, maintain and enhance dashboards, data models and data pipelines. The right candidate will possess advanced analytical and decision-making skills.

The role requires someone who is passionate about data quality, data analytics and automation in order to drive business strategy. An ability to be an expert in problem solving, critical thinking, and an understanding of complex system dependencies are essential in enabling the Business Analyst to show where Zayo processes are broken and how those processes are affecting key data points. An individual with a strong passion to solve problems and improve data integrity will excel in this position. In addition, this individual has to have a knowledge of pulling unique datasets across different objects within Salesforce. This will help with the additional responsibility of maintaining databases that feed into objects in Salesforce and dashboards in Analytics.

The Business Analyst Specialist must be an effective communicator, a good listener, and have strong interpersonal skills that will assist in cross team collaboration.

Responsibilities

Work with other areas of the business to drive enhanced data, operational reporting and analytics platform
Build, maintain and enhance dashboards, data models and data pipelines
Use SQL or other query languages to create complex datasets across multiple tables in Zayo’s Salesforce warehouse
Identify and automate inefficiencies in the methods the organization currently uses to gather important business data by developing a systemic framework as well as improve data flows
Provides governance on data accuracy and ensures integrity of data components in key analysis projects and playbooks
Run processes that use data to identify market and business trends to increase profits and efficiency
Implement and maintain methodologies for tracking and reporting on key business operational and financial metrics
Understand, utilize, and maximize our data, in Salesforce.com and other databases to optimize business insights

Qualifications

2+ years of data analysis experience
Bachelor’s Degree in Information Systems, Analytics, Operations Management, Data Science, or other Quantitative Field
Ability to understand and create charts, graphs, and data visualization models
Advanced skillset in Microsoft Excel and G-Suite applications
Aptitude for learning new/different processes within the company to better understand other data architectures and workflows
Knowledge of Salesforce.com
Intermediate experience with Einstein Analytics, Tableau or other data visualization software
Ability to create reports and dashboards within Salesforce.com
Passion for creating a data driven culture and delivering value
Ability to coordinate across teams and disciplines to drive process improvements and automation
Self-starter who is able to tackle work in an unstructured environment, comfortable with ambiguity
Strong desire for teamwork and working in group settings
Ability to adapt to change quickly, as well as manage a high-volume workload efficiently and effectively
A team player who can collaborate naturally on high priority projects and initiatives
Strong attention to detail and ability to multi-task and prioritize
Strong financial acumen and a passion for data
Must be highly organized and a strong communicator both written and verbal
A general understanding of telecom is preferred

Base pay range: $64,700 - $86,300 , commensurate with experience.

Benefits, Rewards & Wellness

Excellent Health, Dental & Vision Insurance
Retirement 401(k) Savings Plan
Fitness membership discounts
Generous paid time off policy including paid parental leave

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.
#J-18808-Ljbffr</p>

Zayo Group Interview Questions

Zayo Group Interview Guides

Zayo Group Interview Questions

Zayo Group Salaries by Position

Zayo Group Opening Jobs