Manager, business intelligence finance

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 Business Intelligence Manager is responsible for leading the design, development, and optimization of business intelligence solutions that support data-driven decision-making across the organization.

This role partners closely with cross-functional teams, including Finance, Sales, Marketing, Demand Planning, Customer Support, and global stakeholders, to deliver impactful reporting and analytics capabilities.

The position oversees the development of interactive dashboards and reports in Power BI and leverages Databricks for data processing, transformation, and advanced analytics.

In addition, this role serves as the U.S. AI champion, helping to identify, advance, and promote practical AI use cases across the business, including AI-enabled solutions and automation opportunities.

Job Responsibilities Design, develop, and maintain Power BI dashboards, reports, and visualizations to support business performance management and decision-making.

Conduct data analysis, develop user acceptance testing criteria, and maintain business intelligence documentation to support solution delivery and adoption.

Partner with stakeholders to gather business requirements and translate them into effective reporting and analytics solutions.

Perform complex data transformations and calculations using DAX within Power BI to support business reporting needs.

Optimize reporting solutions for performance, scalability, and user experience.

Leverage Databricks to support data preparation, transformation, and analytics processes.

Work with large and complex datasets using Databricks notebooks, Delta Lake, and Spark SQL. Collaborate with data engineers, analysts, and business intelligence teams to ensure efficient and reliable data flow between Databricks and Power BI. Promote adherence to data governance standards, including data security, privacy, and compliance requirements.

Communicate insights, recommendations, and analysis effectively to technical and non-technical stakeholders, including senior leadership.

Apply best practices in report design, including user experience and interface design principles.

Serve as the U.S. AI champion by supporting the adoption of AI capabilities, identifying business use cases, and contributing to the design and implementation of AI-enabled solutions, including intelligent agents and automation initiatives.

Works in a safe manner collaborating as a team member to achieve all outcomes.

Demonstrate Behaviours that exhibit our organizational Values: Integrity, Courage, Teamwork, and Innovation.

Ensure 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 policies.

All other relevant duties as assigned.

Job Requirements Education Bachelor’s degree in Computer Science, Information Technology, Data Science, or related field (or equivalent work experience).

Knowledge, Skills and Abilities Knowledge of integrating Databricks with business intelligence tools such as Power BI, Tableau, or similar platforms.

Working knowledge of programming languages such as Python or R for data manipulation, analytics, and process automation.

Knowledge of data visualization best practices and user experience/interface design principles.

Experience Minimum of 5 to 7 years of experience developing and mai