The Stand Together Business Intelligence interview guide, interview questions, salary data, and interview experiences.

Stand Together Business Intelligence Interview Guide

<p>Getting ready for an Business Intelligence interview at Stand Together? The Stand Together 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 Stand Together Business Intelligence roles.</li>
<li>Gain insights into the Business Intelligence interview process at Stand Together.</li>
<li>Practice real Stand Together 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 Stand Together Business Intelligence interview.</p>


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

- Know what skills are necessary for Stand Together Business Intelligence roles.
- Gain insights into the Business Intelligence interview process at Stand Together.
- Practice real Stand Together 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 Stand Together Business Intelligence interview.
        

Overview

Stand Together 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.

Stand Together 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

Stand Together Business Intelligence Interview Questions

<p>Stand Together is a dynamic and mission-driven organization committed to driving positive social change and empowering individuals to overcome barriers. Join our team and be part of a collaborative community that values innovation, personal responsibility, and the power of bottom-up solutions. Together, we will create a society that fosters opportunity, dignity, and well-being for all. <br> <br>Stand Together is looking for a motivated and enthusiastic Senior Software Engineer to join our team! As a Software Engineer, you will be responsible for supporting our software development team in all aspects of the development, testing, and implementation of our products. You will train, mentor, and work with other software engineers in the Drupal content management system (CMS). In addition, you will work with data engineers, architects, cloud engineers, marketing teams, and stakeholders on solutions that help some of our society's biggest challenges! We are looking for someone who is comfortable architecting solutions and working in the full Drupal development stack. This position can be fully remote. <br><br><strong>Your Responsibilities Include</strong> <br></p><ul> <ul><li>Serve as the primary maintainer of some of our MarTech systems </li><li>Mentor and train other software engineers on best practices in Drupal </li><li>Creating custom modules and designing custom layouts using Drupal </li><li>Writing and debugging PHP / HTML / CSS / JavaScript code </li><li>Design software solutions that meet the requirements </li><li>Troubleshooting general software issues </li><li>Working closely with other engineers to improve product's functionality </li> <li>Work with marketing team leads on finding solutions to improve outreach </li><li>Participating in estimation discussions with the team </li> <li>Continually improving coding and other technical skills </li></ul> </ul><strong>Skills you bring to the Organization</strong> <ul> <ul><li>At least six years of professional software development experience </li><li>Experience in designing and architecting software solutions from scratch </li><li>Experience leading software engineers or other technical practitioners </li><li>Experience with requirements gathering and refinement in an Agile environment </li><li>Experience working directly with internal and external project stakeholders </li><li>Experience writing PHP code using the Symfony framework </li><li>Experience with Drupal, Wordpress or other CMS systems that support headless / hybrid mode </li><li>Experience with SQL a must; NoSQL preferred but not required </li><li>Experience with front-end and backend JavaScript frameworks (e.g. Vue, NodeJS, React) </li><li>Experience and general knowledge of SSL certificates and web protocols </li><li>Acquia and AWS experience preferred </li><li>Digital Asset Management (DAM) tool experience such as Widen, ZDam, Canto preferred </li> <li>Content Delivery Network experience preferred </li><li>Experience working with marketing teams preferred </li></ul> </ul><strong>What We Offer</strong> <ul> <ul><li>A meaningful career where your work will improve the lives of millions of Americans - especially the least fortunate. </li><li>A vision-driven community of over 1,000 employees across the country who are dedicated to improving the lives of others. </li><li>Competitive salaries and bonuses. Our salary and bonus strategies are aligned to the value you create, not a standardized bell curve. </li><li>Generous 401K match - 6% match with immediate vesting. </li><li>Competitive health and wellness benefits </li><li>Our flexible time-off policy allows all employees to take leave as needed. </li><li>A purchasing credit card to use for business expenses. </li><li>Mileage reimbursement for business travel separate from your commute. </li><li>Commuter assistance plans to offset the cost of commuting into our headquarters (on-site parking or metro) </li><li>Opportunities for professional development and mentorship that can strengthen your effectiveness through Principle Based Management and other industry specific programs. </li></ul> </ul><br> <br>Stand Together helps social entrepreneurs supercharge their efforts to help people improve their lives. We connect them with passionate partners and the resources necessary to make a greater difference. Through our philanthropic community, we tackle some of the nation's biggest challenges so that every person has the opportunity to realize their extraordinary potential. Stand Together partners with people from diverse perspectives and backgrounds-including people in education, business, community non-profits, and public policy-to accomplish more together than any of us could on our own. <br> <br><b>Our Values</b> Working at Stand Together is different from many other organizations. We have a relentless commitment to a culture based on a business philosophy called Principle Based Management® (PBM®). Informed by the principles that allow a free and open society to flourish, PBM® prepares individuals to innovate, improve, and transform while fostering a healthy, growing organization that creates long-term value for its clients and supporters and fulfillment for its employees. <br> <br>We believe that diversity in experiences, perspectives, knowledge and ideas fuels creativity, broadens knowledge, and helps drive success. That's why we're proud to be an equal opportunity employer and strive to treat all employees and applicants with honesty, dignity, respect and sensitivity. We welcome all qualified applicants regardless of color,race, religion, religious creed, sex, gender or gender identity, gender expression, sexual orientation, national origin, citizenship, ethnicity, ancestry, age, physical disability, mental disability, medical condition, pregnancy (including medical needs which may arise from pregnancy, childbirth, or related medical conditions), military and veteran status, genetic information, marital or familial status, political affiliation, or any other legally recognized protected basis under federal, state or local laws, regulations or ordinances.

Stand Together Business Intelligence Interview Guide

Overview

Stand Together Business Intelligence Salary

Stand Together Business Intelligence Interview Process

Stand Together Business Intelligence Interview Questions

Stand Together Business Intelligence Jobs