Prepare for and practice interview questions from G2O.

G2O Interview Questions

G2O Interview Guides

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

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.

What factors could have biased this result, and what would you look into?

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

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?

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

G2O Salaries by Position

We’re passionate about designing and delivering top-notch digital experiences for our clients — and their customers — and helping them create efficiencies using data and technology. But what’s most important about us is that we have a diverse team of experts all dedicated to getting clients from goals to outcomes — and that’s where you come in. Candidates MUST be located or willing to relocate to Columbus, OH. This is a hybrid position, in the office 3 days/week. G2O is seeking an individual with a Business Analysis and Data Analysis background that can assist with building an integrated reference data management system. The team will be standardizing metrics and KPIs across multiple Warehouse Management system implementations. Exposure to logistics, supply chain management, or 3PL (third party logistics) related projects is a bonus. Responsibilities: <ul> <li>Responsible for developing and maintaining requirements traceability and facilitating refinement sessions. </li> <li>Responsible for eliciting high level requirements and Acceptance Criteria provided by the business team, creating and refining epics and stories to Dev Ready. </li> <li>Manages ongoing relationship with business partner to drive satisfaction. </li> <li>Coordinates project delivery by facilitating design reviews and walk-throughs to communicate systems designs and validate proposed solutions. </li> <li>Obtains key inputs from enterprise architecture team and identifies solution interdependencies. </li> <li>Serve as a key liaison to Product and other departments that have specific business functions. </li> <li>Collaborate with multiple Product, Shared Services and Backend Data teams to identify, document and communicate business needs and provide technology solutions. </li> <li>Responsible for eliciting high level requirements and Acceptance Criteria provided by the Product team, creating and refining epics and stories to Dev Ready. </li> <li>Answer questions and clarify requirements for projects and enhancements during the estimation, refinement, development and QA process. </li> <li>Works independently and proactively to meet Refinement deadlines, i.e., ensuring the backlog is always adequately filled with fully refined stories. </li> </ul> Knowledge, Skills & Abilities: <ul> <li>Ability to manage multiple, concurrent projects, activities and tasks under time constraints. </li> <li>Be an independent problem solver with the ability to creatively translate business data/requirements into technical solutions. </li> <li>Have outstanding written and verbal communication skills. Have strong interpersonal skills and the ability to work effectively with a wide variety of technical and non-technical stakeholders </li> <li>Anticipate change and quickly prioritize accordingly. </li> <li>Strong analytical and problem-solving skills. </li> <li>Excellent facilitation and organizational skills. </li> </ul> Qualifications: <ul> <li>Bachelors degree in computer science or related technical discipline. </li> <li>4+ years’ experience as a Business Analyst or other related field. </li> <li>8+ years of overall IT experience with significant experience in software development. </li> <li>Experience planning, facilitating, eliciting, documenting and managing business, functional and technical requirements. </li> <li>Experience with both traditional Waterfall SDLC and Agile / Lean methodologies. </li> <li>Experience with Microsoft Products; Excel, Word and Visio. </li> <li>Experience with project tools such as JIRA and Confluence (or other Agile tools). </li> </ul> More about G2O: We’re different than other companies at G2O. We blend the research and design, technology, and data expertise to deliver the solutions our clients crave — and we do all of this as one in-house team, from vision to execution. We’re also the largest company of our kind based in Ohio to do this — and have been evolving how we do it for 40 years. Individually, we bring a wealth of experience from diverse backgrounds — personally and in business. We’re a diverse and passionate team of leaders and experts in technology, data, analytics, design, content, and more. But we think we’re best when we put our minds together. Each person brings something distinct to our team — some unique flavor to their background or their experience. That makes for stronger collaboration — and elevates the outcomes for our clients. Are you ready to collaborate to greatness with us? Learn more at g2o.com/careers

We’re passionate about designing and delivering top-notch digital experiences for our clients — and their customers — and helping them create efficiencies using data and technology. But what’s most important about us is that we have a diverse team of experts all dedicated to getting clients from goals to outcomes — and that’s where you come in. Candidates MUST be located or willing to relocate to Columbus, OH. This is a hybrid position, in the office 3 days/week. G2O is seeking an individual with a Business Analysis and Data Analysis background that can assist with building an integrated reference data management system. The team will be standardizing metrics and KPI's across multiple Warehouse Management system implementations. Exposure to logistics, supply chain management, or 3PL (third party logistics) related projects is a bonus. Responsibilities: <ul><li>Responsible for developing and maintaining requirements traceability and facilitating refinement sessions. </li><li>Responsible for eliciting high level requirements and Acceptance Criteria provided by the business team, creating and refining epics and stories to Dev Ready. </li><li>Manages ongoing relationship with business partner to drive satisfaction. </li><li>Coordinates project delivery by facilitating design reviews and walk-throughs to communicate systems designs and validate proposed solutions. </li><li>Obtains key inputs from enterprise architecture team and identifies solution interdependencies. </li><li>Serve as a key liaison to Product and other departments that have specific business functions. </li><li>Collaborate with multiple Product, Shared Services and Backend Data teams to identify, document and communicate business needs and provide technology solutions. </li><li>Responsible for eliciting high level requirements and Acceptance Criteria provided by the Product team, creating and refining epics and stories to Dev Ready. </li><li>Answer questions and clarify requirements for projects and enhancements during the estimation, refinement, development and QA process. </li><li>Works independently and proactively to meet Refinement deadlines, i.e., ensuring the backlog is always adequately filled with fully refined stories. </li></ul> Knowledge, Skills & Abilities: <ul><li>Ability to manage multiple, concurrent projects, activities and tasks under time constraints. </li><li>Be an independent problem solver with the ability to creatively translate business data/requirements into technical solutions. </li><li>Have outstanding written and verbal communication skills. Have strong interpersonal skills and the ability to work effectively with a wide variety of technical and non-technical stakeholders </li><li>Anticipate change and quickly prioritize accordingly. </li><li>Strong analytical and problem-solving skills. </li><li>Excellent facilitation and organizational skills. </li></ul> Qualifications: <ul><li>Bachelor's degree in computer science or related technical discipline. </li><li>4+ years’ experience as a Business Analyst or other related field. </li><li>8+ years of overall IT experience with significant experience in software development. </li><li>Experience planning, facilitating, eliciting, documenting and managing business, functional and technical requirements. </li><li>Experience with both traditional Waterfall SDLC and Agile / Lean methodologies. </li><li>Experience with Microsoft Products; Excel, Word and Visio. </li><li>Experience with project tools such as JIRA and Confluence (or other Agile tools). </li></ul> More about G2O:We’re different than other companies at G2O. We blend the research and design, technology, and data expertise to deliver the solutions our clients crave — and we do all of this as one in-houseteam, from vision to execution. We’re also the largest company of our kind based in Ohio to do this — and have been evolving how we do it for 40 years. Individually, we bring a wealth of experience from diverse backgrounds — personally and in business. We’re a diverse and passionate team of leaders and experts in technology, data,analytics, design, content, and more. But we think we’re best when we put our minds together.Each person brings something distinct to our team — some unique flavor to their background or their experience. That makes for stronger collaboration — and elevates the outcomes for our clients. Are you ready to collaborate to greatness with us? Learn more at g2o.com/careers

G2O Interview Questions

G2O Interview Guides

G2O Interview Questions

G2O Salaries by Position

G2O Opening Jobs