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

Pointclickcare Business Intelligence Interview Guide

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


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

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

Overview

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

Pointclickcare 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 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

<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

Pointclickcare Business Intelligence Interview Questions

PointClickCare is a leading North American healthcare technology platform enabling meaningful care collaboration and real-time patient insights. For over 20 years, the company has been focused on realizing its vision: to help create a world in which providers and plans can confidently deliver frictionless care. Since its inception, PointClickCare has grown exponentially, with over 2,200 employees working to impact millions across North America. Recognized by Forbes as one of the top 100 private cloud companies and acknowledged by Waterstone Human Capital as Canada's Most Admired Corporate Cultures, PointClickCare leads the way in creating cloud-based healthcare software. At PointClickCare, we offer a wealth of opportunities and a vibrant culture that empowers our employees. Our dynamic environment is the perfect place to advance your career while engaging in meaningful work alongside incredible colleagues. Here, you'll discover a space where your talents can thrive, your career can grow, and your work will have a lasting impact on healthcare across North America. We believe that work becomes profoundly fulfilling when driven by a higher purpose. Join us and be part of a team that is making a real impact. To learn more about us, check out Life at PointClickCare and connect with us on Glassdoor and LinkedIn. <br> <b>We are looking for a Data Analyst (or Associate Data Scientist, or Data Scientist depending on experience) to join our Data Science department. </b> <br> <b>Position Summary:</b> The position is primarily aimed at analysis and reporting for our internal Product department. Our products generally focus on providing insights from hospital and skilled nursing facilities (SNFs) data to a variety of customers including hospitals, health systems, health plans, ACOs, and other similar health or data exchange entities. This role will be responsible for using real-time and historical healthcare data and user data to investigate new product opportunities and determine the health and user behavior of our current products. The main skillsets include extracting, cleaning, and preparing data; summarizing, visualizing, and interpreting data for a range of customer personas; and providing recommendations to Product personnel, Data Science personnel, management, other departments, and external clients <h5>Key Responsibilities: </h5> <ul class="posting-requirements plain-list"><ul> <li>Extract data to build metrics or create/update Tableau dashboards to track success toward company, department, and customer KPIs </li><li>Share insights with internal and external customers regarding drivers of success or areas of opportunity </li> <li>Analyze data in new areas to help prioritize areas of focus </li> <li>Consult with internal and external customers to develop new dashboards, metrics, KPIs, outcomes evaluation, or ROI </li> <li>Respond to ad hoc analytic requests from internal and external customers </li><li>Understand and use the data warehouse and relational databases </li><li>Ensure accurate quality of deliverables by participating in peer review </li> </ul></ul> <h5>Who you'll work with: </h5><ul class="posting-requirements plain-list"> <ul><li>This role will work closely with other members of our Data Science department as well as many teams throughout the organization such as Product, Customer Success, Clinical Solutions, Sales, Marketing, Professional Services, and more. </li> </ul></ul> <h5>Required Experience: </h5><ul class="posting-requirements plain-list"> <ul><li>Bachelor's degree (or equivalent experience) in data science, analytics, mathematics, statistics, public health, economics, social science, or actuarial science. Master's degree preferred. </li><li>0-2 years of experience related to analytics work or equivalent combination of education and experience (experience and skillsets are used to determine the appropriate level in the job family) </li><li>Previous healthcare related industry experience a plus </li><li>Experience with data manipulation tools such as Python; data visualization tools such as Tableau; and data extraction via querying languages (SQL) </li><li>Knowledge of all Microsoft Office applications, including Word, Excel, and PowerPoint </li><li>Ability to meet deadlines, work with tight schedules, and manage multiple priorities under minimum supervision </li><li>Excellent verbal and written communication skills </li><li>Strong analysis skills </li><li>Strong attention to detail </li><li>Experience with cleaning, aggregating, and pre-processing data from varied sources. Experience creating complex SQL queries for standard as well as ad hoc data mining purposes. </li></ul> </ul> $82,000 - $89,000 a year At PointClickCare, base salary is one of the many components that make up our total rewards package. The US base salary range for this position is $82,000 - $89,000 + bonus + benefits,non-overtime eligible. Our salary ranges are determined by job and level. The range displayed on each job posting reflects the target for new hire salaries for the position across all US locations. Within the range, individual compensation is determined by job-related skills and knowledge, relevant experience including professional and lived experience, and/or work location. Your recruiter can share more information about our total rewards package during the hiring process. #LI-DNI <br> It is the policy of PointClickCare to ensure equal employment opportunity without discrimination or harassment on the basis of race, religion, national origin, status, age, sex, sexual orientation, gender identity or expression, marital or domestic/civil partnership status, disability, veteran status, genetic information, or any other basis protected by law. PointClickCare welcomes and encourages applications from people with disabilities. Accommodations are available upon request for candidates taking part in all aspects of the selection process. Please contact recruitment@pointclickcare.com should you require any accommodations. <br> When you apply for a position, your information is processed and stored with Lever, in accordance with Lever's Privacy Policy. We use this information to evaluate your candidacy for the posted position. We also store this information, and may use it in relation to future positions to which you apply, or which we believe may be relevant to you given your background. When we have no ongoing legitimate business need to process your information, we will either delete or anonymize it. If you have any questions about how PointClickCare uses or processes your information, or if you would like to ask to access, correct, or delete your information, please contact PointClickCare's human resources team: recruitment@pointclickcare.com <br> PointClickCare is committed to Information Security. By applying to this position, if hired, you commit to following our information security policies and procedures and making every effort to secure confidential and/or sensitive information. Apply for this job

Pointclickcare Business Intelligence Interview Guide

Overview

Pointclickcare Business Intelligence Salary

Pointclickcare Business Intelligence Interview Process

Pointclickcare Business Intelligence Interview Questions

Pointclickcare Business Intelligence Jobs