Data Analyst, Pharmacy Inventory Optimization
About the role
The Role: Data Analyst, Pharmacy Inventory Optimization
What you are looking for:
- A closely connected culture
- A total rewards package meant to enhance your work-life flexibility
- Fully utilizing your talent
- Professional growth and development via challenging projects and assignments
- Warm and fuzzy feelings knowing you have helped your community, your team, the business and social causes through the Rexall Care Network
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.
About Rexall
With a heritage dating back more than 100 years, Rexall has evolved to become one of Canada's most trusted pharmacy brands.
Our legacy of helping Canadians has endured through successive evolutions of Rexall and Rexall Pharma Plus, from the apothecary-type drugstores to the modern community pharmacies we are today. Rexall in Canada was established in 1904 in the early days of the United Drug Company and quickly established itself as an innovator in retail pharmacy. At the same time, Tamblyn Drugs was establishing itself in Toronto, Ontario, and would eventually become Pharma Plus.
This progression has led us where we are today, a proud member of the McKesson family ranked seventh on the Fortune 500 and the industry's oldest, largest, most experienced and sophisticated pharmaceutical distributor.
At Rexall, our employees are family, and our culture reflects a close-knit community. From coast to coast, from retail store to Support Centre, we are ALL IN!
A lot may have changed over the years, but our commitment to helping Canadian families and communities be healthier has never been stronger. This vision continues to guide us as we look to the future and increase access to convenient, quality healthcare and products that Canadians can feel good about.
Our 390+ Rexall and Rexall Pharma Plus locations are supported by 7,000 staff dedicated to providing exceptional service and care in 180 communities across Canada. From providing vaccinations such as flu, COVID-19 * or other services within the expanding scopes of pharmacy care. Or offering exclusive daily living products that can help put you on a healthy path, Rexall is focused on continuously evolving to meet the changing needs of our patients and customers.
Rexall is a member of the Rexall Pharmacy Group ULC., a wholly-owned subsidiary of McKesson Corporation.
*Where regulations permit pharmacists to administer the flu vaccinations.
Data Analyst, Pharmacy Inventory Optimization
About the role
The Role: Data Analyst, Pharmacy Inventory Optimization
What you are looking for:
- A closely connected culture
- A total rewards package meant to enhance your work-life flexibility
- Fully utilizing your talent
- Professional growth and development via challenging projects and assignments
- Warm and fuzzy feelings knowing you have helped your community, your team, the business and social causes through the Rexall Care Network
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.
About Rexall
With a heritage dating back more than 100 years, Rexall has evolved to become one of Canada's most trusted pharmacy brands.
Our legacy of helping Canadians has endured through successive evolutions of Rexall and Rexall Pharma Plus, from the apothecary-type drugstores to the modern community pharmacies we are today. Rexall in Canada was established in 1904 in the early days of the United Drug Company and quickly established itself as an innovator in retail pharmacy. At the same time, Tamblyn Drugs was establishing itself in Toronto, Ontario, and would eventually become Pharma Plus.
This progression has led us where we are today, a proud member of the McKesson family ranked seventh on the Fortune 500 and the industry's oldest, largest, most experienced and sophisticated pharmaceutical distributor.
At Rexall, our employees are family, and our culture reflects a close-knit community. From coast to coast, from retail store to Support Centre, we are ALL IN!
A lot may have changed over the years, but our commitment to helping Canadian families and communities be healthier has never been stronger. This vision continues to guide us as we look to the future and increase access to convenient, quality healthcare and products that Canadians can feel good about.
Our 390+ Rexall and Rexall Pharma Plus locations are supported by 7,000 staff dedicated to providing exceptional service and care in 180 communities across Canada. From providing vaccinations such as flu, COVID-19 * or other services within the expanding scopes of pharmacy care. Or offering exclusive daily living products that can help put you on a healthy path, Rexall is focused on continuously evolving to meet the changing needs of our patients and customers.
Rexall is a member of the Rexall Pharmacy Group ULC., a wholly-owned subsidiary of McKesson Corporation.
*Where regulations permit pharmacists to administer the flu vaccinations.