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

Business Wire Business Intelligence Interview Guide

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


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

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

Overview

Business Wire 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.

Business Wire 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

Business Wire Business Intelligence Interview Questions

Business Wire, a Berkshire Hathaway company, is the global market leader in press release distribution and regulatory disclosure. We are on a mission to redefine how organizations connect with their audiences - and that's just the beginning! <br><br>Organizations, large and small, depend on us to accurately publicize market-moving news and multimedia, and generate social engagements that develop interactions with their target audiences. <br><br><b>About the Role</b> <br><br>We are looking for an experienced Principal Software Engineer with a strong cloud engineering design background to lead engineering design and development for an architecture modernization effort for Business Wire's industry leading press release processing system. The project requires a complete rebuild of Business Wire's back office system, including transition from a legacy architecture to a modern, serverless technology stack, a new database platform, new REST API platform, and optimization of the system to ensure its long-term operational reliability. <br> <br><strong>What You'll Do</strong> <br><ul> <ul><li>Develop engineering design and documentation for multiple components of a press release processing system, with emphasis on reliability, performance, and maintainability. </li><li>Provide technical leadership and direct contribution to the code base using modern technology stacks, with emphasis on serverless platforms. </li><li>Lead development of proof of concepts (POCs). </li><li>Contribute to design of development environments, develop usage guidelines, and SDLC best practices. </li><li>Lead and contribute to implementation of CI/CD flows. </li><li> Tackle a wide variety of technical problems throughout the stack and contribute daily to all parts of our product code base. </li><li>Collaborate with product managers, designers, infrastructure teams, and other stakeholders to develop complex systems. </li><li>Perform code reviews to ensure code quality, adherence to coding standards, and maintainability. </li><li>Monitor the correct implementation of engineering designs and address implementation issues. </li><li>Identify and design solutions for performance bottlenecks across the entire application. </li><li>Identify design and operational improvements to existing applications. </li></ul> </ul><strong>What You'll Need</strong> <ul> <ul><li>15+ years of relevant hands-on programming experience. </li><li>Technical leadership experience, leading 6-10 engineers on 6+ months long projects. </li><li>Expert level knowledge in modern programming languages and their ecosystems, including Python, Go Lang, Node.js or similar. </li><li>Extensive experience in Cloud platform architectures, at least one of AWS, GCP or Azure. </li><li>Expertise in multiple types of database and data retrieval technologies including Relational, NoSQL, GraphQL and others. </li><li>Excellent communication skills. </li><li>Excellent skills in developing engineering designs and related documentation. </li><b>Business Wire will not sponsor a new applicant for employment authorization for this position.</b><b>What We Offer</b>The base salary range for this position is $215K to $235K/year. Offered salary will be determined by several factors, including but not limited to: applicant's education, experience, knowledge, skills and abilities, as well as internal equity and alignment with geographic market data. Business Wire reserves the right to modify this salary range at any time.Business Wire's total rewards include: <li>Ability to work remotely </li><li>Excellent health benefits that begin on your first day of employment </li><li>$100 monthly fitness allotment, a tuition reimbursement program, and enhanced mental health resources </li><li>401(k) plan with generous company match, and annual profit sharing contribution (subject to company performance) </li><li>PTO, Floating Holidays, Wellness Day Off, Birthday Day Off, and more! </li></ul> </ul><br> <br><b>A pre-employment background check will be required after the acceptance of an offer. </b>Business Wire is proud to be an equal opportunity workplace. We are committed to equal employment opportunity regardless of race, color, ancestry, religion, sex, national origin, sexual orientation, age, citizenship, marital status, disability, gender identity or Veteran status. Pursuant to the San Francisco Fair Chance Ordinance and other similar state laws and local ordinances, and its internal policy, Business Wire will also consider for employment qualified applicants with arrest and conviction records.

Business Wire Business Intelligence Interview Guide

Overview

Business Wire Business Intelligence Salary

Business Wire Business Intelligence Interview Process

Business Wire Business Intelligence Interview Questions

Business Wire Business Intelligence Jobs