Job ID: R2000575502   Job Description: Reporting directly to the Director, Pharmacy Service Analytics, the incumbent is responsible for analyzing and reporting on SDM and Loblaw Health and Wellness initiatives, identifying areas of opportunities, success factors and potential barriers. The ideal candidate is someone with an analytical mindset and a proven ability to quickly grasp unstructured situations, drive insights from both the quantitative and qualitative information available, and present results and recommendations in a clear and concise manner. What you will do:Lead the translation of various stakeholder requests and questions into analytical problems. Requests can be strategic or tactical in nature, including but not limited to patient outcomes, segmentations, development of dashboards and reportsWorking proactively to develop patient insights in key areas, build dashboards to inform on priority initiatives, and develop a strong relationship with business partners to help in their day-to-day decision makingDesign, develop, and maintain various KPI dashboards and reports to identify and track pharmacy program eligibility and outcomes following service deliveryWrite and optimize SQL queries to extract, transform, and analyze large datasets from multiple sourcesDevelop and automate reports, ensuring accuracy, consistency, and timely deliveryEffectively communicate across different forums and audiences verbally and in writing (e.g. formal presentations, one-on-one meetings, in front of large audiences, with business leaders)Provide and clearly articulate actionable insights based on thorough analysis of complex data sets and macro trends that can be utilized by senior management for strategic decision-making processesStay abreast with current trends and regulatory changes in pharmacy sector across different regions in Canada; as well as internal and competitors initiatives that may impact market shareWhat you will need:Proven experience in an analytical role. Experience ideally in Retail, Pharmacy or Health related sectorPost secondary education equivalent to a university degree in business or technologyAdvanced computer skills to produce reports, dashboards and presentations, as required:Expert knowledge MS Office software (including Excel and PowerPoint)Strong experience with SQL/Teradata/Python programming and business intelligence software (e.g., PowerBI, MicroStrategy, etc.)Innovative self-starter and patient centric thinking, with strong critical thinking / problem solving skills and ability to take requests vague in nature, and distill them into practical insightsStrong ability to manage competing priorities and move in a fast-paced dynamic environment, while maintaining ability to influence across all levels of the team and in the organizationAbility to build and maintain effective cross functional relationships Why work at Shoppers Drug Mart?Acting as consultants, supporting internal customers and the Associate-Owners, you will get experience unique to the retail industry while working for an award-winning national brand.   Benefit from a purchase discount program, competitive pay and online learning through Academy.Take ownership of your work and find more ways to care about your work, co-workers, customers and community. How You ll Succeed: At Shoppers Drug Mart Inc., we seek great people to continually strengthen our culture.  We believe great people model our values, are authentic, build trust and make connections.  If that sounds like you, and you are open-minded, responsive to change and up to the challenges provided in a fast-paced retail environment, apply today.  Employment Type:Full time Type of Role:Regular Shoppers Drug Mart Inc. recognizes Canada's diversity as a source of national pride and strength. We have made it a priority to reflect our nation s evolving diversity in the products we sell, the people we hire, and the culture we create in our organization. Accommodation is available upon request for applicants with disabilities in the recruitment and assessment process and when hired. In addition, we believe that compliance with laws is about doing the right thing.  Upholding the law is part of our Code of Conduct it reinforces what our customers and stakeholders expect of us. Please Note: If you have Employee Self Service (ESS) on Workday, apply to this job via the Workday application.