Prepare for and practice interview questions from Pharmerica.

Pharmerica Interview Questions

Pharmerica Interview Guides

<p>Let’s say we have a table with an <code>id</code> and <code>name</code> fields. The table holds over 100 million rows and we want to sample a random row in the table without throttling the database.</p>

<p>Write a query to randomly sample a row from this table.</p>

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

<p><code>big_table</code> table</p>

<table>
<thead>
<tr>
<th>Columns</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>


Write a query to randomly sample a row from a big table.

Random SQL Sample

<p>Let’s say that your company is running a standard control and variant AB test on a feature to increase conversion rates on the landing page. The PM checks the results and finds a .04 p-value.</p>

<p>How would you assess the validity of the result?</p>


Experiment Validity

<p>You are testing hundreds of hypotheses with many <em>t</em>-tests. What considerations should be made?</p>


<p>What is a key disadvantage of the F-test when compared to multiple t-tests?</p>

What is a key disadvantage of the F-test when compared to multiple t-tests?

Hundreds of Hypotheses

You are testing hundreds of hypotheses with many t-tests. What considerations should be made?

Pharmerica Salaries by Position

<p>Our Company PharMerica Overview Remote We seek a meticulous and committed Advanced Business Analyst who has a pivotal role in our Pharmacy Systems team. Your focus on quality assurance (QA) and functionality analysis will be instrumental in ensuring the quality, reliability, and functionality of our pharmacy systems, particularly in long-term care (LTC) settings. Your substantial experience in QA processes and proficiency in SQL, SSRS, and Power BI will be crucial in supporting data validation and reporting. This is a remote position. Applicants can reside anwhere within the Continental USA. Business travel to support our Clients: 25-75% This is a great opportunity: Work on impactful projects that ensure the stability and reliability of critical pharmacy applications. Be part of a collaborative, dynamic team that values innovation and continuous improvement. Competitive salary and benefits package. Opportunities for professional growth and development. Enjoy the flexibility of a remote work environment We offer: Competitive pay Health, dental, vision and life insurance benefits Company paid STD and LTD Employee Discount Program 401k Paid-time off Tuition reimbursement Non-retail/Closed-door environment If your passion is service excellence and top-quality care come join our team and apply today Responsibilities QA Testing: Conduct comprehensive quality assurance testing on pharmacy systems to ensure they meet functional requirements and are defects-free. This includes both manual and automated testing processes. Test Planning and Execution: Based on system requirements and specifications, develop detailed test plans, test cases, and scripts. Execute these tests, document the results, and identify any issues or discrepancies. Functionality Analysis: Perform in-depth analysis of new system functionalities and how they relate to new or existing workflow best practices and provide recommendations for their integration. Apply your knowledge of pharmacy workflows and industry standards to ensure all system updates and enhancements meet regulatory requirements and best practices. Defect and Enhancement Management: Identify, document, and track defects using QA tools and methodologies. Track the progress of these requests with vendors, ensuring timely resolution and integration into the system. User and Technical Documentation: Create detailed user and technical documentation for new functionalities, workflows, and system updates. Ensure all documentation is clear, accurate, and accessible to technical and non-technical users. Data and Report Validation: Utilize SQL, SSRS, and Power BI to validate the accuracy and integrity of data within pharmacy systems. Ensure that all data is correctly integrated, processed, and reported. SQL and Data Analysis: SQL analyzes data and supports decision-making processes. Based on data analysis, provide insights and recommendations to improve system functionality and performance. Documentation: Maintain thorough and accurate QA documentation, including test plans, test cases, defect logs, and QA reports. Ensure that all documentation is updated and easily accessible. Collaboration: Work closely with cross-functional teams, including developers, business analysts, and project managers, to ensure that QA processes align with project goals and timelines. Continuous Improvement: Identify opportunities to enhance QA processes and methodologies. Implement best practices to improve the efficiency and effectiveness of QA activities. Qualifications Bachelor's degree in Information Technology, Computer Science, Pharmacy, Business Administration, or a related field or equivalent experience. Minimum of 3 years of experience as a Business or QA Analyst, with experience in system testing, quality assurance processes, and workflow design. Strong experience in quality assurance, workflow analysis, and documentation within the pharmacy or healthcare industry. Experience in defect and enhancement management, particularly in collaboration with external vendors. Preferred Experience: Experience in the LTC pharmacy industry. Experience in user experience (UX) design and analysis. Strong proficiency in SQL, SSRS, and Power BI, with the ability to perform data validation, report verification, and troubleshooting. Deep understanding of pharmacy workflows, industry standards, and regulatory requirements. Knowledge of pharmacy system applications, with experience in system configurations and workflow optimization. Excellent analytical and problem-solving skills, with strong attention to detail. Strong documentation skills, with the ability to create clear and detailed technical documents. Strong communication and collaboration skills, with the ability to work effectively with cross-functional teams. Proven ability to manage multiple priorities and projects in a fast-paced environment. Preferred Skills: Knowledge of Agile methodologies and tools. Familiarity with other pharmacy systems and applications, such as DocuTrack, ECM, and EMRs. Understanding healthcare regulations and compliance requirements, particularly those relevant to LTC pharmacies. Travel 25-75% About our Line of Business PharMerica is a full-service pharmacy solution providing value beyond medication. PharMerica is the long-term care pharmacy services provider of choice for senior living communities, skilled nursing facilities, public health organizations and post-acute care organizations. PharMerica is one of the nation's largest pharmacy companies. PharMerica offers unmatched employee development, exceptional company culture, seemingly endless opportunities for advancement and the highest hiring goals in decades. For more information about PharMerica, please visit www.pharmerica.com. Follow us on Facebook, Twitter, and LinkedIn. Salary Range USD $80,000.00 - $90,000.00 / Year</p>

<p>Our Company PharMerica Overview We seek an experienced and motivated T echnical Business Analyst who focuses on pharmacy applications and integrations, not limited to EMR, Courier platforms, internal proprietary integrations, etc., applications within the long-term care (LTC) pharmacy industry. In this role, you will use your technical skills to help analyze, implement, and optimize pharmacy applications to enhance operational efficiency and patient care. The ideal candidate will have knowledge of LTC pharmacy workflows and a strong understanding of EMAR and other integrated pharmacy application systems. This role requires a blend of technical expertise, analytical skills, and business acumen to drive the successful implementation and optimization of our pharmacy-related applications. This is a remote position . Applicants can reside any where within the Continental USA We offer: Competitive pay Health, dental, vision and life insurance benefits Company paid STD and LTD Employee Discount Program 401k Paid-time off Tuition reimbursement Non-retail/Closed-door environment Short Term Incentive Bonus If your passion is service excellence and top-quality care come join our team and apply today Position will be posted for a minimum of 7 business days Responsibilities EMAR System Implementation, Pharmacy System Application Integrations and Optimization: Lead the implementation and optimization of EMAR systems across LTC pharmacy operations. Ensure that systems are configured to meet the specific needs of long-term care facilities, enhancing patient care and compliance. Data Analysis and Reporting: Develop and maintain dashboards and reports using SSRS and Power to monitor key performance indicators and ensure compliance with regulatory requirements and internal standards. Automation & Scripting: Use PowerShell and PowerApps to automate routine tasks and enhance the functionality of EMAR and pharmacy systems, streamlining workflows and reducing manual interventions. Pharmacy Application Management: Analyze, implement, and support pharmacy applications used in LTC settings. Work closely with stakeholders to identify system requirements, develop solutions, and ensure seamless integration with existing workflows. Workflow Analysis and Improvement: Conduct detailed analyses of current pharmacy workflows to identify areas for improvement. Develop and implement new workflows that optimize efficiency, reduce errors, and improve patient outcomes. System Testing and Quality Assurance: Develop and execute test plans to ensure that EMAR and pharmacy applications meet functional requirements and are free of defects. Collaborate with the QA team to identify and resolve issues before deployment. Vendor Management: Work closely with EMAR and pharmacy application vendors to manage system upgrades, enhancements, and troubleshooting. Ensure that all vendor deliverables meet the organization's quality and performance standards. Training and Support: Provide training and ongoing support to end-users, ensuring that they are fully equipped to use EMAR systems, other type of pharmacy integrated software, and pharmacy applications effectively. Develop user guides and training materials as needed. Qualifications Bachelor's degree in Information Technology, Computer Science, Pharmacy, Business Administration, or a related field or equivalent experience. Experience developing data-driven solutions using PowerApps, PowerShell, or other development tools. Minimum of 5 years of experience as a Technical Business Analyst, focusing on EMAR systems and pharmacy applications in the LTC pharmacy industry. Experience in system testing, quality assurance, and user training. Preferred Experience: Experience with Agile methodologies and project management tools. Experience in data integration and interoperability between pharmacy systems and other healthcare applications. In-depth knowledge of LTC pharmacy workflows and industry standards, particularly about EMAR systems and other pharmacy-integrated software. Strong proficiency in data integration, report development, and dashboards using SSIS, SSRS, and Power BI. Excellent written and verbal communication skills, with the ability to convey technical information to non-technical stakeholders. Strong documentation skills, with the ability to create clear and comprehensive business requirements, functional specifications, and user guides. Preferred Skills: Familiarity with specific EMAR systems and pharmacy applications commonly used in LTC settings, such as FrameworkLTC, DocuTrack, and PointClickCare. Knowledge of HL7 and SCRIPT standards. Understand healthcare regulations and compliance requirements related to LTC pharmacies. Travel 0-25% About our Line of Business PharMerica is a full-service pharmacy solution providing value beyond medication. PharMerica is the long-term care pharmacy services provider of choice for senior living communities, skilled nursing facilities, public health organizations and post-acute care organizations. PharMerica is one of the nation's largest pharmacy companies. PharMerica offers unmatched employee development, exceptional company culture, seemingly endless opportunities for advancement and the highest hiring goals in decades. For more information about PharMerica, please visit www.pharmerica.com. Follow us on Facebook, Twitter, and LinkedIn. Salary Range USD $80,000.00 - $90,000.00 / Year</p>

Pharmerica Interview Questions

Pharmerica Interview Guides

Pharmerica Interview Questions

Pharmerica Salaries by Position

Pharmerica Opening Jobs