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

Amerisourcebergen Business Intelligence Interview Guide

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


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

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

Overview

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

Amerisourcebergen 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

Amerisourcebergen Business Intelligence Interview Questions

<p>Our team members are at the heart of everything we do. At Cencora, we are united in our responsibility to create healthier futures, and every person here is essential to us being able to deliver on that purpose. If you want to make a difference at the center of health, come join our innovative company and help us improve the lives of people and animals everywhere. Apply today!

Considering making an application for this job Check all the details in this job description, and then click on Apply.
Job Details Under general direction of the Senior Manager, Pricing, the Pricing Analyst, will provide quantitative rationale and assessment for the Wholesale and Specialty segment daily pricing management. The Pricing Analyst will leverage data and analytics to verify, validate and ensure alignment to contracted commitments; assess bids and analyze impacts; and build and maintain tools and processes to monitor and improve pricing processes. The Pricing Analyst will actively participate in the development pricing strategy recommendations in future contract development, as well as implementation.
Responsibilities

Performs monthly and quarterly detailed analysis of transaction level data; synthesizing findings into relevant trends and correlations and assisting in the construction and implementation of solutions that drive revenue and margin optimization

Actively participates in the development of customer pricing strategies and tactics for assigned channels / classes of trade

Collaborates with Business / Customer Operations and other teams to ensure timely and effective on-boarding, set-up and maintenance of required pricing rules and conditions in consistent alignment with commercial contracted commitments is achieved

Participates in quantification and impact analysis of existing or proposed pricing policies, procedures and governance frameworks

Fields and resolves sales inquiries related to pricing, rebates, and customer setup

Conducts financial analysis for deal structures

Understands Branded Rx pricing initiatives, solutions, and messaging. Responsible for educating the Sales Teams on the Branded Rx strategies.

Documents processes and procedures related to primary duties and responsibilities.

Assesses issues related to invoicing, Customer Setup, pricing or supply issues and determines appropriate solutions.

Performs any related duties as assigned

Education and Work Experience
Requires broad training in fields such as business administration, finance, pricing, marketing, economics, statistics, mathematics, engineering, computer science, strategy, or similar vocations generally obtained through completion of a four year bachelor's degree program or equivalent combination of experience and education. Prefer 1 years’ experience in analytics and project/process management.
Skills and Knowledge
Sound expertise in financial / mathematical / statistical modeling and analysis

Proven ability to work analytically; synthesizing vast data into relevant, actionable information

Ability to implement and manage projects / processes aimed at driving simplification, standardization, or adherence to policy

Strong communication skills both written and verbal

Ability to work independently with limited supervision

Ability to learn quickly in a dynamic environment.

Proven ability to handle many diverse projects at once and meet deadlines in fast-paced environment with shifting priorities.

Strong organizational and time management skills

Strong attention to detail

Excellent interpersonal skills

Excellent project management skills; establishing and keeping deadlines

Excellent analytical, strategic and problem-solving skills; ability to resolve issues effectively and efficiently

Good presentation skills

Fluency in Microsoft Suite applications (Word, Project, Excel, Access and PowerPoint)

#LI-MF1
What Cencora offers We provide compensation, benefits, and resources that enable a highly inclusive culture and support our team members’ ability to live with purpose every day. In addition to traditional offerings like medical, dental, and vision care, we also provide a comprehensive suite of benefits that focus on the physical, emotional, financial, and social aspects of wellness. This encompasses support for working families, which may include backup dependent care, adoption assistance, infertility coverage, family building support, behavioral health solutions, paid parental leave, and paid caregiver leave. To encourage your personal growth, we also offer a variety of training programs, professional development resources, and opportunities to participate in mentorship programs, employee resource groups, volunteer activities, and much more. For details, visit https://www.virtualfairhub.com/cencora
Equal Employment Opportunity Cencora is committed to providing equal employment opportunity without regard to race, color, religion, sex, sexual orientation, gender identity, genetic information, national origin, age, disability, veteran status or membership in any other class protected by federal, state or local law.
The company’s continued success depends on the full and effective utilization of qualified individuals. Therefore, harassment is prohibited and all matters related to recruiting, training, compensation, benefits, promotions and transfers comply with equal opportunity principles and are non-discriminatory.
Cencora is committed to providing reasonable accommodations to individuals with disabilities during the employment process which are consistent with legal requirements. If you wish to request an accommodation while seeking employment, please call 888.692.2272 or email hrsc@cencora.com. We will make accommodation determinations on a request-by-request basis. Messages and emails regarding anything other than accommodations requests will not be returned
Affiliated Companies Affiliated Companies: AmerisourceBergen Services Corporation</p>

<p>Our team members are at the heart of everything we do. At Cencora, we are united in our responsibility to create healthier futures, and every person here is essential to us being able to deliver on that purpose. If you want to make a difference at the center of health, come join our innovative company and help us improve the lives of people and animals everywhere. Apply today! </p> <h5><b>Job Details</b> </h5> <p>Under general direction of the Senior Manager, Pricing, the Pricing Analyst, will provide quantitative rationale and assessment for the Wholesale and Specialty segment daily pricing management. The Pricing Analyst will leverage data and analytics to verify, validate and ensure alignment to contracted commitments; assess bids and analyze impacts; and build and maintain tools and processes to monitor and improve pricing processes. The Pricing Analyst will actively participate in the development pricing strategy recommendations in future contract development, as well as implementation. </p><p><b>Responsibilities </b> </p><ul> <li><p>Performs monthly and quarterly detailed analysis of transaction level data; synthesizing findings into relevant trends and correlations and assisting in the construction and implementation of solutions that drive revenue and margin optimization </p></li> <li><p>Actively participates in the development of customer pricing strategies and tactics for assigned channels / classes of trade </p></li> <li><p>Collaborates with Business / Customer Operations and other teams to ensure timely and effective on-boarding, set-up and maintenance of required pricing rules and conditions in consistent alignment with commercial contracted commitments is achieved </p></li> <li><p>Participates in quantification and impact analysis of existing or proposed pricing policies, procedures and governance frameworks </p></li> <li><p>Fields and resolves sales inquiries related to pricing, rebates, and customer setup </p></li> <li><p>Conducts financial analysis for deal structures </p></li> <li><p>Understands Branded Rx pricing initiatives, solutions, and messaging. Responsible for educating the Sales Teams on the Branded Rx strategies. </p></li> <li><p>Documents processes and procedures related to primary duties and responsibilities. </p></li> <li><p>Assesses issues related to invoicing, Customer Setup, pricing or supply issues and determines appropriate solutions. </p></li> <li><p>Performs any related duties as assigned </p></li> </ul><p><b>Education and Work Experience </b> </p><p>Requires broad training in fields such as business administration, finance, pricing, marketing, economics, statistics, mathematics, engineering, computer science, strategy, or similar vocations generally obtained through completion of a four year bachelor's degree program or equivalent combination of experience and education. Prefer 1 years’ experience in analytics and project/process management. </p><p><b>Skills and Knowledge </b> </p><ul> <li><p>Sound expertise in financial / mathematical / statistical modeling and analysis </p></li> <li><p>Proven ability to work analytically; synthesizing vast data into relevant, actionable information </p></li> <li><p>Ability to implement and manage projects / processes aimed at driving simplification, standardization, or adherence to policy </p></li> <li><p>Strong communication skills both written and verbal </p></li> <li><p>Ability to work independently with limited supervision </p></li> <li><p>Ability to learn quickly in a dynamic environment. </p></li> <li><p>Proven ability to handle many diverse projects at once and meet deadlines in fast-paced environment with shifting priorities. </p></li> <li><p>Strong organizational and time management skills </p></li> <li><p>Strong attention to detail </p></li> <li><p>Excellent interpersonal skills </p></li> <li><p>Excellent project management skills; establishing and keeping deadlines </p></li> <li><p>Excellent analytical, strategic and problem-solving skills; ability to resolve issues effectively and efficiently </p></li> <li><p>Good presentation skills </p></li> <li><p>Fluency in Microsoft Suite applications (Word, Project, Excel, Access and PowerPoint) </p></li> </ul><p>#LI-MF1 </p><h5><b><b><b>What Cencora offers</b></b></b> </h5><p>We provide compensation, benefits, and resources that enable a highly inclusive culture and support our team members’ ability to live with purpose every day. In addition to traditional offerings like medical, dental, and vision care, we also provide a comprehensive suite of benefits that focus on the physical, emotional, financial, and social aspects of wellness. This encompasses support for working families, which may include backup dependent care, adoption assistance, infertility coverage, family building support, behavioral health solutions, paid parental leave, and paid caregiver leave. To encourage your personal growth, we also offer a variety of training programs, professional development resources, and opportunities to participate in mentorship programs, employee resource groups, volunteer activities, and much more. For details, visit https://www.virtualfairhub.com/cencora </p><h5><b><b><b><b>Equal Employment Opportunity</b></b></b></b> </h5><p>Cencora is committed to providing equal employment opportunity without regard to race, color, religion, sex, sexual orientation, gender identity, genetic information, national origin, age, disability, veteran status or membership in any other class protected by federal, state or local law. </p><p>The company’s continued success depends on the full and effective utilization of qualified individuals. Therefore, harassment is prohibited and all matters related to recruiting, training, compensation, benefits, promotions and transfers comply with equal opportunity principles and are non-discriminatory. </p><p>Cencora is committed to providing reasonable accommodations to individuals with disabilities during the employment process which are consistent with legal requirements. If you wish to request an accommodation while seeking employment, please call 888.692.2272 or email hrsc@cencora.com. We will make accommodation determinations on a request-by-request basis. Messages and emails regarding anything other than accommodations requests will not be returned </p><h5><b><b><b>Affiliated Companies</b> </b></b> </h5>Affiliated Companies: AmerisourceBergen Services Corporation

Amerisourcebergen Business Intelligence Interview Guide

Overview

Amerisourcebergen Business Intelligence Salary

Amerisourcebergen Business Intelligence Interview Process

Amerisourcebergen Business Intelligence Interview Questions

Amerisourcebergen Business Intelligence Jobs