Manager, Finance Business Intelligence

Apotex is a Canadian-based global health company improving everyday access to affordable, innovative medicines and health products for millions worldwide. With a broad portfolio of generic, biosimilar, innovative branded pharmaceuticals, and consumer health products, Apotex is headquartered in Toronto and operates regional offices globally, including in the United States, Mexico, and India. As the largest Canadian-based pharmaceutical company, Apotex serves as a health partner of choice for pharmaceutical licensing and product acquisitions in the Americas.

About the role

The Business Intelligence Manager leads the design, development, and optimization of business intelligence solutions that support data-driven decision-making across the organization. This role partners 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 interactive dashboards and reports in Power BI, leverages Databricks for data processing and advanced analytics, and serves as the U.S. AI champion, identifying and promoting practical AI use cases and automation opportunities.

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.
• Comply with all company policies and procedures, including applicable safety rules and regulations.
• Perform duties in accordance with the Company’s Code of Conduct, Business Ethics, and all established regulatory, compliance, and safety requirements.
• Demonstrate the Company’s core values of Collaboration, Courage, Perseverance, and Passion in the execution of all responsibilities.
• Perform other duties as assigned.

Requirements

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

• 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.
• Minimum of 5 to 7 years of experience developing and maintaining interactive Power BI dashboards and reports.
• Minimum of 2 to 3 years of experience working with Databricks in a data engineering, analytics, or business intelligence environment.
• Experience working with large, complex datasets and supporting ETL or data transformation processes.
• Hands-on experience with AI solutions, including the development of AI agents, identification of business use cases, and application of generative AI or automation tools to enhance business processes and support decision-making.
• Experience with cloud platforms such as Azure, AWS, or Google Cloud is preferred.
• Relevant Databricks certifications are preferred (e.g., Databricks Certified Associate Developer for Apache Spark).