Manager, BI

About Apotex Inc.

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, innovative 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.

For more information visit: www.apotex.com.

Job Summary

The Manager, Business Intelligence & Reporting is responsible for designing and delivering Commercial reporting architecture, data strategy & governance, visualization and reporting. This person will work with IT to align database architecture with evolving business needs, applying sound database management principles and developing robust processes for extracting, transforming, and standardizing data from multiple sources. They must also develop and maintain processes for retrieving, standardizing, and loading data in an accurate and timely manner into relevant database tables. The role is responsible for modernizing data management and reporting processes, by leveraging best practices and emerging technologies, including Databricks. They will architect scalable data structures that enable integrated reporting across multiple lines of business through a single, consistent reporting framework. The Manager, Business Intelligence & Reporting will be organizing,overseeing, and executing Business Intelligence reporting needs of the Canadian Commercial organization, providing insights and time savings to a variety of Commercial stakeholders through high‑quality data visualization, reporting, and analytics. 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. They are further responsible for ensuring that all reports, applications, and tools provided to the business are using correct and consistent data sources. In addition to enabling data‑driven decision‑making, this role supports commercial IBP, budgeting and performance calculation processes by maintaining data and providing reporting related to budget, targets, and performance. They will take ownership of supplying supporting data for these key processes, working with deliverable owners to ensure deliverables can be provided accurately and on time for each cycle. They will utilize best practices of Organizational Change Management to guide all rollout plans of new technology and processes. As a Manager, they should take on a leadership role within the team, training on processes, and sharing knowledge and best methods as widely as possible.

Job Responsibilities

• Improve and modernize data preparation and load processes
• Identify and implement opportunities for modernized data flows utilizing best in class approach to Databricks functionality
• Understand Apotex Canada Commercial data requirements and complex datasets
• Integrate data from various lines of business and sources into a unified reporting view
• Liaise with IT teams to ensure database architecture aligns with ability to efficiently fulfil business needs
• Manage Commercial databases, ensuring timely flow of clean and accurate data
• Provide database architecture solutions and suggestions based on a deep understanding of data sources and business needs
• Develop processes for extracting, receiving, and standardizing data to be used in reporting
• Design database in a way that supports growing development of data-driven AI projects

• Develop and maintain data visualization apps in support of Apotex Canada Commercial teams
• Understand user requirements and implement BI projects
• Responsible for executing or overseeing ad hoc reporting and analysis as required by cross-functional teams within Apotex Canada Commercial, or areas impacting Apotex Canada Commercial, and as prioritized within Commercial Excellence deliverables
• Lead development of Power BI applications for Apotex Canada Commercial teams
• Responsible for developing and maintaining Data Sourcing standards to be used across all tools, applications, and reports delivered by Commercial Excellence team
• Lead cross-functional project teams to gather, understand, and execute requirements to maximize efficiency within the Commercial organization
• Liaise with GIS on cross functional projects, develop priorities given limited resources and ensure alignment of all teams to achieve goals
• Provide expertise on data preparation, sourcing, and management for AI initiatives
• Liaise with users and GIS to troubl