Apotex is a Canadian-based global health company. We improve everyday access to affordable, innovative medicines and health products for millions of people worldwide, with a broad portfolio of generic, biosimilar, cutting-edge branded pharmaceuticals and consumer health products. Headquartered in Toronto, with regional offices globally, including in the United States, Mexico and India, we are the largest Canadian-based pharmaceutical company and a health partner of choice for the Americas for pharmaceutical licensing and product acquisitions.Job SummaryPosition is a 12‑month contract.TheConsultant, Business Intelligenceis responsible for delivering actionable insights to support Canadian Commercial performance through high‑quality data visualization, reporting, and analytics. This person will develop new dashboards, and maintain existing ones, to advance use of data and analysis in making sound business decisions. This role partners closely with cross‑functional stakeholders to understand business requirements and translate them into scalable BI solutions, primarily using Power BI and modern analytics tools. The Consultant works with IT to align database architecture with business needs, applying sound database management concepts and developing robust processes for extracting, transforming, and standardizing data from multiple sources.In addition to enabling data‑driven decision‑making, this role supports commercial execution by collaborating with sales leadership to set sales targets, and by executing commercial budgeting and performance calculation processes. The Consultant leverages modern query languages and analytics technologies to ensure data accuracy, consistency, and usability, playing a key role in enabling insight‑led growth across the Canadian Commercial organization.The Consultant, Business Intelligence will utilize best practices of Organizational Change Management to guide all rollout plans of new technology and processes.Job ResponsibilitiesResponsible for executing ad hoc reporting and analysis as required by cross‑functional teams within Apotex Canada Commercial and as prioritized within Commercial Excellence deliverablesDevelop and maintain data visualization apps in support of Apotex Canada Commercial teamsUnderstand user requirements and implement BI projectsLiaise with users and GIS to troubleshoot issues with active BI dashboards owned by Commercial ExcellenceEnsure that all tools, applications, and reports provided by Commercial Excellence team adhere to defined Data Sourcing standardsResponsible for QA testing, ensuring quality of reporting being provided by GBS Commercial teamBuild and maintain reporting on SLAs for deliverables of GBS Commercial teamRole should provide actionable insights and/or time‑saving reporting efficiencies each yearDatabase ManagementUnderstand Apotex Canada Commercial data requirements and nuance of complex datasetsLiaise with IT teams to ensure database architecture aligns with ability to efficienty fulfil business needsManage Commercial databases, ensuring timely flow of clean and accurate dataProvide database architecture solutions and suggestions based on a deep understanding of data sources and business needsDevelop processes for extracting, receiving, and standardizing data to be used in reportingPerformance ReportingWork with sales leadership to develop sales targetsExecute Commercial target and sales performance reporting and processes, identifying areas requiring attention via management reportsManage a central database for Apotex Canada targetsManage a Sales Rep performance database that will generate reports and variance analysisSupply deliverables accurately and on time for each compensation cycleGeneralUtilize best practices of Organizational Change Management to roll out new tools, applications and processes to stakeholdersBuild and deliver training plans for tools, applications, and processes delivered to stakeholdersEnsure deliverables provide a simple, repeatable, output with minimal intervention by Commercial Excellence teamSupport, as needed, any existing tools and processes owned by Commercial ExcellenceWorks in a safe manner collaborating as a team member to achieve all outcomesDemonstrate Behaviours that exhibit our organizational Values: Integrity, Courage, Teamwork, and InnovationEnsure personal adherence with all compliance programs including the Global Business Ethics and Compliance Program, Global Quality policies and procedures, Safety and Environment policies, and HR policiesAll other relevant duties as assignedJob RequirementsEducationUniversity degree: Business, Engineering, Science, Mathematics,



Computer Sciences preferredKnowledge, Skills and AbilitiesProficiency in SQL, Python, VBA, and other development tools. Knowledge of machine learning an assetProfiency with data visualization software (Power BI preferred; Qlik; Tableau)Proficiency with ETL processes and automation in a SQL environmentPrevious experience with Databricks an assetHigh level of proficiency in all MS Office applications, including Excel and AccessPrevious experience in SAP or an ERP system an assetKnowledge of statistical procedures and applied data validationExcellent written and verbal communication skillsAbility to work with all levels within the organizationExperienceExperience in the Canadian Pharmaceutical industry working with pharmaceutical data systems and conducting focused analytics preferredExperience in performance analyticsAt Apotex, we are committed to fostering a welcoming and accessible work environment, where all everyone feels valued, respected, and supported to succeed.We offer accommodation for applicants with disabilities as part of its recruitment process. If you are contacted to arrange for an interview or testing, please advise us if you require an accommodation.The hiring range for this position is $83,126.43 to $116,377 CAD per year. The final agreed‑upon salary may vary based on factors such as job‑related knowledge, skills and experience.We are looking for top talent. If your qualifications differ from those listed above, the scope of work and final agreed‑upon salary may be adjusted to reflect your individual qualifications.Apotex Total Rewards package goes beyond base salary. Apotex offers bonus programs based on your position in the organization, you can excel based on our pay‑for‑performance philosophy. With comprehensive benefits, a pension plan to help you save for retirement and learning and development opportunities, we provide a comprehensive package for your personal and professional development.Apotex will use artificial intelligence to screen, select and/or assess your application for this job.Consultant, Business Intelligence (12‑month contract) - North York, ON, CA, M9L 2Z7#J-18808-Ljbffr

📌 Consultant, Business Intelligence (12-Month Contract) - C$83,126.4 - C$116,377 A Year (Winnipeg)
🏢 APOTEX
📍 Winnipeg