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

Select medical Business Intelligence Interview Guide

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


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

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

Overview

Select medical 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.

Select medical 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 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

Select medical Business Intelligence Interview Questions

<p>Design, build, and maintain ETL pipelines from various sources into data warehouses and/or data lakes Optimize, monitor, and troubleshoot existing ETL pipelines to ensure accuracy, scalability, timeliness of all processes. Coordinate with business st Business, Intelligence, Engineer, Senior, Technology, Healthcare, Skills</p>

<p>Overview Database and Business Intelligence Internship (ON-SITE in Mechanicsburg, PA) Select Medical is pleased to offer the 2025 Summer Internship Program at our corporate office located in Mechanicsburg, Pennsylvania. This 12-week paid internship is designed for college juniors or seniors who wish to study and experience the operations of a health care company with multiple subsidiaries throughout the U.S. We are searching for highly motivated, energetic, mature individuals to assist in accounting project work beginning Monday, May 12, 2025 and extending for twelve weeks with completion on Friday, August 8, 2025 Our Database Team's primary role is the storage and organization of the large amount of data that flows through the enterprise. The Data Warehouse and Business Intelligence teams collect, organize, maintain, and most importantly make sense of the gathered information. The Data Intern may be assisting with incoming requests from the business to pull information for clinical, finance, and corporate teams. Our interns work with technologies such as Structured Query Langue (SQL) , Extracting Transforming and Loading (ETL) data (ODI, SSIS), and utilizing reporting tools (SSRS, MicroStrategy). Juniors and Seniors applying to this position should have a keen interest in data manipulation and analysis. The rate is $15.00 per hour. The internship is on-site in Mechanicsburg, PA. It is not remote. Responsibilities Come work with a professional, challenging organization and gain working experience in conjunction with your educational studies. This will be a valuable asset as you explore future career opportunities. The program includes 20 hours of classroom lecture, 460 hours of supervised work experience, weekly reading assignments, learning luncheons, and a tour of one of our local hospitals and outpatient clinics. Qualifications Requirements : You must be pursuing a bachelors degree in Information Technology or related majors. Your sophomore year must be completed before the internship starts. Your attendance for the entire internship is required. Additional Data Select Medical is committed to having a workforce that reflects diversity at all levels and is an equal opportunity employer. Qualified applicants are considered for employment, and employees are treated during employment without regard to race, color, religion, national origin, citizenship, age, sex, sexual orientation, gender identity, marital status, ancestry, physical or mental disability, veteran status, or any other characteristic protected under applicable law. Apply for this job (https://jobs-selectmedicalcorp.icims.com/jobs/302736/data-analyst-internship/job?modeapply&applyyes&in_iframe1&hashed1374627814) Share this job Job ID 302736 Location US-PA-Mechanicsburg Experience (Years) 0 Category Information Systems Street Address 4714 Gettysburg Rd Company Select Medical Position Type Full Time</p>

<p>In addition, the role will hold the following responsibilities: Impact You'll Make:Provide support to projects related to EPIC applications. Completion of assigned tasks for newly developed functionality and maintaining existing applications on the e Business Analyst, Business, Analyst, Technology, Healthcare, Application</p>

Select medical Business Intelligence Interview Guide

Overview

Select medical Business Intelligence Salary

Select medical Business Intelligence Interview Process

Select medical Business Intelligence Interview Questions

Select medical Business Intelligence Jobs