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

Pomeroy Business Intelligence Interview Guide

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


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

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

Overview

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

Pomeroy 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 show the number of users, number of transactions placed, and total order amount per month in the year 2020. Assume that we are only interested in the monthly reports for a single year (January-December).</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>products</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>price</code></td>
<td>FLOAT</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>

<tr>
<td><code>sex</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>month</code></td>
<td>INTEGER</td>
</tr>

<tr>
<td><code>num_customers</code></td>
<td>INTEGER</td>
</tr>

<tr>
<td><code>num_orders</code></td>
<td>INTEGER</td>
</tr>

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


Monthly Customer Report

Pomeroy Business Intelligence Interview Questions

<p><strong>Six month contract to hire. No Corp to Corp third-party candidates will be considered.</strong> </p> <p><strong>About the Role:</strong> </p><p>The Business Analyst will be responsible for supporting strategic and tactical operation of the Salesforce.com platform, related processes and workflows, as well as working with user community on an ongoing basis to improve and enhance the CRM platform. The analyst needs to have firm grasp of CRM best practices to drive and foster greater CRM adoption and to improve internal customer experience on an ongoing basis. Candidates must be willing to be onsite in Franklin, Tennessee 2-3 days a week from the outset. </p> <p><strong>Responsibilities:</strong> </p><ul> <li>Manage the collection and implementation of business process requirements for SalesForce.com. </li><li>Work in a cross functional environment with various business groups, IT and end users to identify, document, and communicate business processes. </li><li>Create Requirements for maintaining and enhancing visual layouts, workflow rules and business logic layer to streamline and enhance business processes and improve user experience. </li><li>Work with the development teams to implement and integrate third-party products / applications on the force.com platform. </li><li>Work with IT and Salesforce.com and other 3rd party vendors to maintain smooth operation and performance of the platform. </li><li>Coordinate and lead user acceptance tests with the business units and end users against business requirements. </li><li>Maintain key system metrics to track trends in usage / adoption and data integrity. </li><li>Train end users prepare related documentation (requirements, training materials, process and data flows, use cases, functional design, etc), participate in cross-functional teams, communicate key messages or address critical questions from the user base involving the CRM. </li><li>Perform system administrator function of the Salesforce.com CRM application. Responsible for maintaining functional areas of contacts / relationship, accounts, opportunities, dashboards and reports. </li><li>Create and execute queries and reports, maintain user roles, security and profiles. </li></ul> <p><strong>Qualifications:</strong> </p><p>Bachelor’s degree in business or information systems preferred </p> <p><strong>Required Skills:</strong> </p><ul> <li>Excellent verbal and written communication skills required </li><li>Excellent interpersonal skills with a demonstrated ability to work in a cross functional team environment required </li><li>Strong customer focus, ability to probe customer needs and translate customer requirements into system specifications required </li><li>3 years of business analyst experience required </li><li>Strong business acumen, superb knowledge of business processes and CRM best practice required </li></ul> <p><strong>Preferred Skills:</strong> </p><ul> <li>1+ years of strong operational experience with SalesForce.com preferred </li><li>Salesforce.com administrator certification a strong plus </li></ul> <p><strong>Pay range and compensation package:</strong> </p><p>N/A </p> <p><strong>Equal Opportunity Statement:</strong> </p><p>We seek out and reward people for being straightforward, open, passionate, effective and challenging the status quo. We want our employees to reflect the diversity of the communities in which we operate. We welcome people as they are, creating an inclusive culture where all forms of diversity are seen as a real value for the company. We’re looking for people with a passion for success — on the job and beyond. </p>

<p></p><p><strong>Six month contract to hire. No Corp to Corp third-party candidates will be considered.</strong></p><p><br></p><p><strong>About the Role:</strong></p><p>The Business Analyst will be responsible for supporting strategic and tactical operation of the Salesforce.com platform, related processes and workflows, as well as working with user community on an ongoing basis to improve and enhance the CRM platform. The analyst needs to have firm grasp of CRM best practices to drive and foster greater CRM adoption and to improve internal customer experience on an ongoing basis. Candidates must be willing to be onsite in Franklin, Tennessee 2-3 days a week from the outset.</p><p><br></p><p><strong>Responsibilities:</strong> </p><ul><li>Manage the collection and implementation of business process requirements for SalesForce.com.</li><li>Work in a cross functional environment with various business groups, IT and end users to identify, document, and communicate business processes.</li><li>Create Requirements for maintaining and enhancing visual layouts, workflow rules and business logic layer to streamline and enhance business processes and improve user experience.</li><li>Work with the development teams to implement and integrate third-party products / applications on the force.com platform.</li><li>Work with IT and Salesforce.com and other 3rd party vendors to maintain smooth operation and performance of the platform.</li><li>Coordinate and lead user acceptance tests with the business units and end users against business requirements.</li><li>Maintain key system metrics to track trends in usage / adoption and data integrity.</li><li>Train end users prepare related documentation (requirements, training materials, process and data flows, use cases, functional design, etc), participate in cross-functional teams, communicate key messages or address critical questions from the user base involving the CRM.</li><li>Perform system administrator function of the Salesforce.com CRM application. Responsible for maintaining functional areas of contacts / relationship, accounts, opportunities, dashboards and reports.</li><li>Create and execute queries and reports, maintain user roles, security and profiles.</li></ul><p><br></p><p> <strong>Qualifications:</strong> </p><p>Bachelor’s degree in business or information systems preferred</p><p><br></p><p><strong>Required Skills:</strong> </p><ul><li>Excellent verbal and written communication skills required</li><li>Excellent interpersonal skills with a demonstrated ability to work in a cross functional team environment required</li><li>Strong customer focus, ability to probe customer needs and translate customer requirements into system specifications required</li><li>3 years of business analyst experience required</li><li>Strong business acumen, superb knowledge of business processes and CRM best practice required</li></ul><p><br></p><p> <strong>Preferred Skills:</strong> </p><ul><li>1+ years of strong operational experience with SalesForce.com preferred</li><li>Salesforce.com administrator certification a strong plus</li></ul><p><br></p><p> <strong>Pay range and compensation package:</strong> </p><p>N/A</p><p><br></p><p><strong>Equal Opportunity Statement:</strong> </p><p>We seek out and reward people for being straightforward, open, passionate, effective and challenging the status quo. We want our employees to reflect the diversity of the communities in which we operate. We welcome people as they are, creating an inclusive culture where all forms of diversity are seen as a real value for the company. We’re looking for people with a passion for success — on the job and beyond.</p><p></p>

Pomeroy Business Intelligence Interview Guide

Overview

Pomeroy Business Intelligence Salary

Pomeroy Business Intelligence Interview Process

Pomeroy Business Intelligence Interview Questions

Pomeroy Business Intelligence Jobs