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

Geisinger Business Intelligence Interview Guide

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


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

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

Overview

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

Geisinger 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>Let’s say you’re working for a social media company trying to grow your user base. You know that people tend to use the same social network as their peers, so you want to target all your growth and marketing efforts on specific age groups so as to take advantage of network effects.</p>

<p>You wish to begin with the age group that is currently generating the most connections (fastest growing).</p>

<p>Write a SQL query to find the average number of accepted friend requests for each age group and order the results in descending order.</p>

<p><em>Note: The average number of accepted friend requests is calculated as the total number of friend requests sent by an age group that was accepted divided by the number of members in said age group.</em></p>

<p><em>We can assume the tables hold valid data in that there are no duplicate friend requests, friend requests are only accepted once, and user A can only accept a friend request from User B after B sends A a friend request.</em></p>

<p><em>The result should be rounded to two decimal places.</em></p>

<h3>Example:</h3>

<p><strong>Input:</strong></p>

<p><strong><code>friend_requests</code></strong></p>

<table>
<thead>
<tr>
<th>Column</th>
<th>Type</th>
</tr>
</thead>

<tbody>
<tr>
<td>requester_id</td>
<td>INTEGER</td>
</tr>

<tr>
<td>receiver_id</td>
<td>INTEGER</td>
</tr>

<tr>
<td>sent_at</td>
<td>DATETIME</td>
</tr>
</tbody>
</table>
<p><strong><code>requests_accepted</code></strong></p>

<table>
<thead>
<tr>
<th>Column</th>
<th>Type</th>
</tr>
</thead>

<tbody>
<tr>
<td>accepter_id</td>
<td>INTEGER</td>
</tr>

<tr>
<td>requester_id</td>
<td>INTEGER</td>
</tr>

<tr>
<td>accepted_at</td>
<td>DATETIME</td>
</tr>
</tbody>
</table>
<p><strong><code>age_groups</code></strong></p>

<table>
<thead>
<tr>
<th>Column</th>
<th>Type</th>
</tr>
</thead>

<tbody>
<tr>
<td>user_id</td>
<td>INTEGER</td>
</tr>

<tr>
<td>age_group</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>age_group</td>
<td>VARCHAR</td>
</tr>

<tr>
<td>average_acceptance</td>
<td>FLOAT</td>
</tr>
</tbody>
</table>


Find the average number of accepted friend requests for each age group that sent the requests.

Avg Friend Requests By Age Group

Geisinger Business Intelligence Interview Questions

<ul>
<li>Independently consults with stakeholders to gather project requirements and define scope on projects of all sizes.</li>
<li>Collaborates with internal partners and organizations in the design and development of reporting solutions and analytic studies to support business needs.</li>
<li>Plans projects and requests completion tasks.</li>
<li>Provides time and effort estimates based on requirements gathering. Strong experience independently managing multiple projects is also required.</li>
<li>Demonstrates working knowledge of relevant source systems needed to support primary stakeholders and proficiency with related databases/data marts within the first year in the role. Must stay abreast of current industry trends and become facile with the various business intelligence software systems used at Geisinger.</li>
<li>Recommends analysis approach and additional analyses or reporting needed based on business questions, requirements, and initial analysis findings.</li>
<li>Develops, validates, and executes complex queries. Develops complex reports and performs complex data analysis that answers business questions for internal customers. Interprets results and makes recommendations to business areas based on findings.</li>
<li>Presents analysis and reports to internal customers and stakeholders.</li>
<li>Routinely uses statistical methods during analyses and considers how best to visualize data that accurately reflects the intended message including the limitations.</li>
<li>Reports and helps troubleshoot data quality issues when performing data profiling, testing, or validation.</li>
<li>Collaborative and eager to share knowledge with team members.</li>
<li>Responsible for participating in strategic departmental initiatives.</li>
<li>Acts as a mentor to other analysts.</li>
<li>May participate in industry advisory and/or user groups.</li>
<li>Strong attention to detail and the ability to be precise and clear when describing results of data analyses.</li>
<li>Shares important and relevant information with the team. Proactively offers suggestions, provides resources, volunteers for assignments, and removes barriers to help the team accomplish its goals.</li>
<li>Follows all department's policies and procedures including request intake/fulfillment, change management, and data governance practices.</li>
<li>Works with the product team on the overall management of funded products and projects.</li>
<li>Communicates resource needs, issues, portfolio and product statuses, and milestones met to leadership.</li>
</ul>
<p>Work is typically performed in an office environment. Accountable for satisfying all job-specific obligations and complying with all organization policies and procedures. The specific statements in this profile are not intended to be all-inclusive. They represent typical elements considered necessary to successfully perform the job.</p>
<p>*Relevant experience may be a combination of related work experience and degree obtained (Associate’s Degree = 2 years; Bachelor’s Degree = 4 years; Master's Degree = 6 years).</p>
<p><b>Highly Preferred Qualifications:</b></p>
<ul>
<li>3 years working in non-cogito Epic application with experience working in Reporting Workbench, Radar, and SlicerDicer.</li>
<li>Epic Application certification preferred.</li>
</ul>
<p><b><span>OR</span></b></p>
<ul>
<li>2 years experience working in the cogito suite of tools.</li>
<li>Epic Cogito certifications preferred.</li>
<li>Other Epic Application certifications preferred.</li>
</ul>
#J-18808-Ljbffr

<p>The Senior BI Analyst serves as a partner to the business or clinical area supported and will use analytic expertise including knowledge of data structures, programming, and statistics along with critical thinking and an understanding of their assigned subject area/business to help the organization make data-driven decisions. The Senior BI Analyst makes contributions to the organization by collecting, cleaning, and interpreting data sets in order to answer a question or solve a problem including identifying and effectively communicating improvement opportunities and supporting the evaluation of existing processes and strategic improvement efforts. Senior BI Analysts consistently act as the analytics expert in meetings and discussions with their stakeholders and are capable of operating independently. Must be articulate in both oral and written communications, including presentations with the ability to translate analyses and opportunity insights to non-technical stakeholders. Senior BI Analysts must exhibit initiative and organizational skills, as well as possess the ability to inspire trust and confidence to maintain outstanding customer relationships. Senior BI Analysts mentor junior BI developers by offering project feedback, participating in code reviews, and providing training in areas of expertise.</p><p>Job Duties</p><p>Independently consults with stakeholders to gather project requirements and define scope on projects of all sizes.</p><p>Collaborates with internal partners and organizations in the design and development of reporting solutions and analytic studies to support business needs.</p><p>Plans projects and request completion tasks.</p><p>Provides time and effort estimates based on requirements gathering. Strong experience independently managing multiple projects is also required.</p><p>Demonstrates working knowledge of relevant source systems needed to support primary stakeholders and proficiency with related databases/data marts within first year in role. Must stay abreast of current industry trends and become facile with the various business intelligence software systems used at Geisinger.</p><p>Recommends analysis approach and additional analyses or reporting needed based on business questions, requirements, and initial analysis findings.</p><p>Develops, validates, and executes complex queries. Develops complex reports and performs complex data analysis that answers business questions for internal customers. Interprets results and makes recommendations to business areas based on findings.</p><p>Presents analysis and reports to internal customers and stakeholders.</p><p>Routinely uses statistical methods during analyses and considers how best to visualize data that accurately reflects the intended message including the limitations.</p><p>Reports and helps troubleshoot data quality issues when performing data profiling, testing, or validation.</p><p>Collaborative and eager to share knowledge with team members</p><p>Responsible for participating in strategic departmental initiatives.</p><p>Acts as a mentor to other analysts</p><p>May participate in industry advisory and/or user groups.</p><p>Strong attention to detail and the ability to be precise and clear when describing results of data analyses.</p><p>Shares important and relevant information with the team. Proactively offers suggestions, provides resources, volunteers for assignments, and removes barriers to help the team accomplish its goals.</p><p>Follows all department's policies and procedures including request intake/fulfillment, change management, and data governance practices.</p><p>Works with the product team on the overall management of funded products and projects.</p><p>Communicates recourse needs, issues, portfolio and product statuses and milestones met to leadership</p><p>Work is typically performed in an office environment. Accountable for satisfying all job specific obligations and complying with all organization policies and procedures. The specific statements in this profile are not intended to be all-inclusive. They represent typical elements considered necessary to successfully perform the job.</p><p>*Relevant experience may be a combination of related work experience and degree obtained (Associate’s Degree = 2 years; Bachelor’s Degree = 4 years, Master's Degree = 6 years).</p><p>Highly Preferred Qualifications:</p><p>3 years working in non cogito Epic application with experience working in Reporting Workbench, Radar, and SlicerDicer.</p><p>Epic Application certification preferred.</p><p> OR</p><p>2 year experience working in the cogito suite of tools.</p><p>Epic Cogito certifications preferred.</p><p>Other Epic Application certifications preferred.</p><p>Education</p><p>High School Diploma or Equivalent (GED)- (Required)</p><p>Experience</p><p>Minimum of 8 years-Relevant experience* (Required)</p><p>Certification(s) and License(s)</p><p>OUR PURPOSE & VALUES: Everything we do is about caring for our patients, our members, our students, our Geisinger family and our communities. KINDNESS: We strive to treat everyone as we would hope to be treated ourselves. EXCELLENCE: We treasure colleagues who humbly strive for excellence. LEARNING: We share our knowledge with the best and brightest to better prepare the caregivers for tomorrow. INNOVATION: We constantly seek new and better ways to care for our patients, our members, our community, and the nation. SAFETY: We provide a safe environment for our patients and members and the Geisinger family We offer healthcare benefits for full time and part time positions from day one, including vision, dental and domestic partners. Perhaps just as important, from senior management on down, we encourage an atmosphere of collaboration, cooperation and collegiality. We know that a diverse workforce with unique experiences and backgrounds makes our team stronger. Our patients, members and community come from a wide variety of backgrounds, and it takes a diverse workforce to make better health easier for all. We are proud to be an affirmative action, equal opportunity employer and all qualified applicants will receive consideration for employment regardless to race, color, religion, sex, sexual orientation, gender identity, national origin, disability or status as a protected veteran.</p><p>We are an Affirmative Action, Equal Opportunity Employer Women and Minorities are Encouraged to Apply. All qualified applicants will receive consideration for employment and will not be discriminated against on the basis of disability or their protected veteran status.</p>
#J-18808-Ljbffr

Geisinger Business Intelligence Interview Guide

Overview

Geisinger Business Intelligence Salary

Geisinger Business Intelligence Interview Process

Geisinger Business Intelligence Interview Questions

Geisinger Business Intelligence Jobs