The Wp engine Business Intelligence interview guide, interview questions, salary data, and interview experiences.

Wp engine Business Intelligence Interview Guide

<p>Getting ready for an Business Intelligence interview at Wp engine? The Wp engine Business Intelligence interview span across 10 to 12 different question topics. In preparing for the interview:</p>
<ul>
<li>Know what skills are necessary for Wp engine Business Intelligence roles.</li>
<li>Gain insights into the Business Intelligence interview process at Wp engine.</li>
<li>Practice real Wp engine Business Intelligence interview questions.</li>
</ul>
<p>Interview Query regularly analyzes interview experience data, and we've used that data to produce this guide, with sample interview questions and an overview of the Wp engine Business Intelligence interview.</p>


Getting ready for an Business Intelligence interview at Wp engine? The Wp engine Business Intelligence interview span across 10 to 12 different question topics. In preparing for the interview:

- Know what skills are necessary for Wp engine Business Intelligence roles.
- Gain insights into the Business Intelligence interview process at Wp engine.
- Practice real Wp engine Business Intelligence interview questions.

Interview Query regularly analyzes interview experience data, and we've used that data to produce this guide, with sample interview questions and an overview of the Wp engine Business Intelligence interview.
        

Overview

Wp engine Business Intelligence Salary

<p>We've gathered this data from parsing thousands of interview experiences sourced from members.</p>

We've gathered this data from parsing thousands of interview experiences sourced from members.

Wp engine Business Intelligence Interview Process

<p>We’re given a table of bank transactions with three columns, <code>user_id</code>, a deposit or withdrawal value (determined if the value is positive or negative), and <code>created_at</code> time for each transaction.</p>

<p>Write a query to get the total three-day rolling average for deposits by day.</p>

<p><em>Note: Please use the format <code>&#39;%Y-%m-%d&#39;</code> for the date in the outout</em></p>

<p><strong>Example:</strong></p>

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

<p><code>bank_transactions</code> table</p>

<table>
<thead>
<tr>
<th>Column</th>
<th>Type</th>
</tr>
</thead>

<tbody>
<tr>
<td><code>user_id</code></td>
<td>INTEGER</td>
</tr>

<tr>
<td><code>created_at</code></td>
<td>DATETIME</td>
</tr>

<tr>
<td><code>transaction_value</code></td>
<td>FLOAT</td>
</tr>
</tbody>
</table>
<p><strong>Output:</strong></p>

<table>
<thead>
<tr>
<th>Column</th>
<th>Type</th>
</tr>
</thead>

<tbody>
<tr>
<td><code>dt</code></td>
<td>VARCHAR</td>
</tr>

<tr>
<td><code>rolling_three_day</code></td>
<td>FLOAT</td>
</tr>
</tbody>
</table>


Rolling Bank Transactions

<p>Write a query to identify customers who placed more than three transactions each in both 2019 and 2020.</p>

<p><strong>Example:</strong></p>

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

<p><code>transactions</code> table</p>

<table>
<thead>
<tr>
<th>Column</th>
<th>Type</th>
</tr>
</thead>

<tbody>
<tr>
<td><code>id</code></td>
<td>INTEGER</td>
</tr>

<tr>
<td><code>user_id</code></td>
<td>INTEGER</td>
</tr>

<tr>
<td><code>created_at</code></td>
<td>DATETIME</td>
</tr>

<tr>
<td><code>product_id</code></td>
<td>INTEGER</td>
</tr>

<tr>
<td><code>quantity</code></td>
<td>INTEGER</td>
</tr>
</tbody>
</table>
<p><code>users</code> table</p>

<table>
<thead>
<tr>
<th>Column</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>
<p> 
<strong>Output:</strong></p>

<table>
<thead>
<tr>
<th>Column</th>
<th>Type</th>
</tr>
</thead>

<tbody>
<tr>
<td><code>customer_name</code></td>
<td>VARCHAR</td>
</tr>
</tbody>
</table>


<p>Which of the following queries will return a list of customers and the total amount they have spent on orders?</p>


Which of the following queries will return a list of customers and the total amount they have spent on orders?

Customer Orders

<p>Write a query to identify the manager with the biggest team size.</p>

<p>You may assume there is only one manager with the largest team size.</p>

<p><strong>Example:</strong></p>

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

<p><code>employees</code> table</p>

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

<tr>
<td><code>manager_id</code></td>
<td>INTEGER</td>
</tr>
</tbody>
</table>
<p><code>managers</code> table</p>

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

<tr>
<td><code>team</code></td>
<td>VARCHAR</td>
</tr>
</tbody>
</table>
<p><strong>Output:</strong></p>

<table>
<thead>
<tr>
<th>Column</th>
<th>Type</th>
</tr>
</thead>

<tbody>
<tr>
<td><code>manager</code></td>
<td>VARCHAR</td>
</tr>

<tr>
<td><code>team_size</code></td>
<td>INTEGER</td>
</tr>
</tbody>
</table>


Manager Team Sizes

Wp engine Business Intelligence Interview Questions

<p>We engage the most inspired minds to do their best work wherever they work best-powering the freedom to create worldwide. <br><br>WP Engine empowers companies and agencies of all sizes to build, power, manage, and optimize their WordPress websites and applications with confidence. Serving 1.5 million customers across 150+ countries, the global technology company provides premium, enterprise-grade solutions, tools, and services, including specialized platforms for WordPress, industry-tailored eCommerce and agency solution suites, and developer-centric tools like Local, Advanced Custom Fields, and more. WP Engine's innovative technology and industry-leading expertise are why 8% of the web visits a WP Engine-powered site daily. Learn more at wpengine.com. <br><br><strong><b>What's cool about this job.</b></strong> <br><br>At WP Engine, engineers help shape our future teams and technology vision in order to build meaningful products that improve the lives of our customers. <br><br>WP Engine is looking for a NetSuite Engineering Manager who wants to make an impact at a mission-driven company. You love enabling engineers to move quickly and with confidence, and are passionate about helping others grow. You thrive on a high level of autonomy and responsibility and sleep well at night because you ensure systems are stable and automated.<br> <br><strong><b>The day to day.</b></strong> <br></p><ul> <li>Curating an engineering culture that is biased toward being built for growth. </li><li>Recruiting new WP Engine engineers from all backgrounds and establishing WP Engine as THE place to be if you're an exceptional engineer interested in solving our most challenging mission critical problems! </li><li>Working in partnership with different departments to ensure we're building the right things, in the right way, in the right priority </li><li>Leading all aspects of a team of engineers and helping ensure their productivity, happiness, and personal growth at WP Engine. </li><li>Being an advocate for the team while balancing objectives set by management. </li></ul><strong><b>Your skills and expertise.</b></strong><br><br><strong><b>Minimum qualifications:</b></strong> <br><ul> <li>Several years of demonstrable experience leading productive and high-functioning engineering teams through the changes associated with a fast paced company. </li><li>You love helping engineers develop new skills and advance in their careers. </li><li>Adopt and be a strong advocate for CI/CD practices across the team. </li><li>Experience as a software engineer and can understand the details of the team's work. </li><li>You have experience developing and deploying NetSuite SuiteScripts (1.0/2.X). </li><li>Strong background in OOP and SOLID principles, especially as applied to modern Javascript </li><li>You are a lifelong learner, particularly as it relates to building a remarkable and enviable engineering team and processes. </li></ul><strong><b>The Perks and Benefits.</b></strong> <br><ul> <li>Company Stock Options (Every employee is an owner in the company) </li><li>Great Health Benefits (Medical, Dental, Vision, Life Insurance) </li><li>Fertility Benefits (IVF/Fertility drug coverage) </li><li>HSA Company contribution $500 for employee / $1000 for family </li><li>401(k) with a 4% match </li><li>Disability Insurance </li><li>Paid Family and Caregiver's Leave </li><li>Employee Assistance Program </li><li>Generous Vacation Time (Who doesn't like time off) </li><li>One-time $500 payment to set up your home office </li><li>4 Company Wellness Days a year </li><li>1 floating holiday </li><li>$100 monthly wellness allowance to spend on what you want </li><li>Access to free on-demand fitness classes </li><li>Free subscription to Calm </li><li>Pet Insurance </li><li>On-going education through LinkedIn Learning, Workday Learning and our Career Growth Portal </li></ul> <br><br><b>#remote</b> <br><br>At WP Engine, we strive to have the broadest possible view of diversity, going beyond visible differences to include the background, experiences, skills, and perspectives that make each person unique. WP Engine is proud to be an equal opportunity workplace and is committed to equal employment opportunity regardless of race, color, ancestry, religion, sex, national origin, sexual orientation, age, citizenship, marital status, disability, gender identity, Veteran status, or any other basis protected by federal, state, or local law. <br> <br><b><b>Base Salary Range</b></b> <br><br>$156,000.00 - $234,000.00 <br><br>We believe that compensation should be reflective of the impact you have within the organization relative to the market value of your role. The estimated base salary range for this position is as listed above. Some roles may also be eligible for overtime pay. Our salary ranges are determined by job role and responsibilities and level. The range displayed on each job posting reflects the minimum and maximum target for salaries for the position nationwide. The actual base pay will vary based on various factors including job-related skills and individual qualifications objectively assessed during the interview process. Your talent acquisition partner can share more about the total rewards package at WP Engine including any additional total rewards components such as equity, variable pay plans (if applicable), and benefits during the hiring process.

Wp engine Business Intelligence Interview Guide

Overview

Wp engine Business Intelligence Salary

Wp engine Business Intelligence Interview Process

Wp engine Business Intelligence Interview Questions

Wp engine Business Intelligence Jobs