Data Analyst, Pharmacy Inventory Optimization

Reporting to the Senior Manager, Financial Planning and Analytics, the Data Analyst – Pharmacy Inventory Optimization will support the pharmacy operations team by providing advanced data analysis and insights to optimize inventory levels and reorder points. This role will focus on leveraging historical data, algorithms, and predictive models to improve inventory efficiency, service levels and reduce write-offs. The analyst will work closely with stakeholders across pharmacy operations, supply chain, and analytics teams to ensure accurate, timely, and actionable reporting.

What you will do: 

• Analyze large datasets related to pharmacy inventory optimization and performance across multiple stores.
• Develop and maintain algorithms/formulas to evaluate reorder points and recommend adjustments based on historical trends and predictive modeling.
• Create and maintain dashboards and reports in Power BI and Excel to visualize key metrics, trends, and performance indicators.
• Partner with pharmacy operations, supply chain, and IT teams to ensure data integrity and alignment with business objectives.
• Monitor and report on KPIs related to inventory optimization, prescription fulfillment, and cost control.
• Identify opportunities for process improvement and automation within data workflows.
• Support ad hoc analysis requests from leadership and provide actionable insights for decision-making.
• Document methodologies, assumptions, and processes for transparency and reproducibility.
• Collaborate with stakeholders to refine requirements and enhance reporting tools and systems.
• Other duties as assigned by Rexall.

How you will succeed:

• University degree in Data Analytics, Statistics, Computer Science, Business, or related discipline is preferred.
• 3+ years of experience in data analysis, preferably in retail or healthcare/pharmacy environments.
• Advanced proficiency in Microsoft Excel (including complex formulas, pivot tables, and macros) is a must.
• Strong experience with Power BI for dashboard creation and data visualization is a must.
• Familiarity with SQL and relational databases for data extraction and manipulation.
• Ability to synthesize large, complex datasets into clear, actionable insights.
• Strong problem-solving skills and attention to detail.
• Excellent communication skills (verbal and written) for presenting findings to non-technical stakeholders.
• Ability to manage multiple priorities in a fast-paced environment.
• Knowledge of pharmacy operations or inventory management is an asset.

At Rexall, we are better together. We serve our customers, partners, and patients best—we are our best—when everyone brings their true self to work. Our connected, inclusive culture celebrates our lived experiences, backgrounds, expertise, and self-expression to let us win as one team. Leveraging our differences distinguishes us and brings out our best performance.

Are you #ALLin?

Rexall Pharmacy Group is committed to providing an accessible environment for all of our customers, employees, and job applicants. Rexall Pharmacy Group will make available to any selected applicants’ accommodations and/or accessible formats should they require. Candidates are encouraged to discuss any accommodation they may need in order to allow for the most effective selection process.