If you are a talented and experienced Data Analyst, David Aplin Group has partnered with our client to recruit a Data Analyst who will be responsible for supporting the program through the contracting process, collating data from vendors, performing data analysis based on categories, market share, and ROI, and providing insights and recommendations.
This is a permanent role available to candidates in the Langley area and is offered as fully remote until further notice.
Supports the vendor contract process starting from the annual Request for Proposal (RFP) to set up the auto-substitution process at the wholesalers, the contractual database, compliance reporting, processing of shorts, and maintenance of molecule lists from the annual Request for Proposal (RFP) to finalizing contracts and setting up the new contractual database
Ability to manipulate data collected from the RFP process to provide analysis on data collected, such as preparing (Right of First Refusal) ROFRs, impact analysis based on vendor and/or category changes, and other analysis required to support the RFP process
Maintains the database, formulary, and pricing files through wholesale catalogs, provincial formulary updates, vendor pricing lists, and national price files
Provides ongoing support and maintenance of the program which will include new molecule launches, vendor pricing changes, molecule shortages, alternate vendors, etc.
Supports the Accounting department through the monthly and quarterly reconciliation process with the vendors and the regions as it pertains to the program and compliance reporting
Collaborates with IT teams in testing and developing business processes, pricing, and data management; and with the National Accounting team to update, support, and maintain the Database, Store Distribution Reports, and the Central Maintenance Database
Communicates with wholesalers to identify key molecules that require substitution in the event of shortages and manufacturer backorders in order to maintain the auto-substitution program
Prepares quarterly and annual data on program performance and key indicators
Collaborates with colleagues to achieve the optimal use of organization resources; maintains good working relationships with teams in other organizational units; liaises with external stakeholders to provide support and communication for the national program, the regions, and the stores
Bachelor’s in Commerce or a related field, or a diploma/certification in business, data analytics, etc.
3+ years of relevant work experience in a fast-paced environment
Strong technical skills in Word, PowerPoint, Access, and Acrobat
Advanced skills in Microsoft Excel, including pivot tables, are essential
Exceptional attention to detail and ability to deliver accurate data/information
Strong organization skills and ability to multi-task
Familiarity with the pharmaceutical industry and pharmacy pricing is considered an asset
Job ID: JZ408190620
If you are interested in this position and meet the qualifications, apply today! We thank all applicants; however, only those who are authorized to work in Canada or are selected for an interview will be contacted.
David Aplin Group, one of Canada’s Best Managed Companies, is an employment agency specializing in finding top talent for exceptional organizations across North America. There are no fees to apply to our jobs or engage with our recruiters to find a new career. Companies hire us to help them grow their teams. Visit our website to learn more: www.aplin.com#LI-DNP#IND-DNP
Privacy & Cookies Policy
Necessary cookies are absolutely essential for the website to function properly. This category only includes cookies that ensures basic functionalities and security features of the website. These cookies do not store any personal information.
Any cookies that may not be particularly necessary for the website to function and is used specifically to collect user personal data via analytics, ads, other embedded contents are termed as non-necessary cookies. It is mandatory to procure user consent prior to running these cookies on your website.